Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
12.3.2
-
None
-
Docker swarm environment on Debian Linux.
Description
The galera cluster of 3 nodes deployed and ingesting data. Data manipulation works as expected.
A table is deleted of containing data, then a alter table is performed.
Error log shows this lines:
mariadb-syslog-galera_mariadb-syslog-galera.3.kxhd3ctgqjxr@server1 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.3.kxhd3ctgqjxr@server1 | request: (8 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.3.kxhd3ctgqjxr@server1 | granted: (7 seqno 3355848 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (13 seqno 3355848 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (12 seqno 3355850 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (9 seqno 3355849 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (8 seqno 3355851 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (11 seqno 3355852 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (10 seqno 3355853 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | 2026-06-26 9:40:58 2 [ERROR] WSREP: MDL BF-BF conflict |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | schema.name: syslog.exim |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | request: (2 seqno 3355847 wsrep (toi, exec, committed, BF1) cmd 0 8 truncate syslog.exim) |
mariadb-syslog-galera_mariadb-syslog-galera.1.w4z6fro4e34a@server3 | granted: (7 seqno 3355854 wsrep (high priority, exec, committing, BF1) cmd 0 162 NULL) |
After this the manipulation of structure or data in cluster on all 3 nodes is halted. Nor Insert, nor Select on any table on any node does work.
The table in mention syslog.exim is not used or populated with data during this operation.
No other messages appear in logs.
To resolve both servers where the of BF-BF conflict appear need to be restarted to allow the 3rd node to resume normal operation. After restart the nodes join the cluster and do sync with success, including altering the table.
This problem does not occur on Create table.
This problem occur on any innodb table alter manipulation.
If the node "server3" is stopped during alter table operations, the remaining 2 nodes perform alter table without any problem.
What could be the problem when 3 nodes are active in wsrep state 4?