Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6.22
-
None
-
None
Description
We had 3 nodes galera cluster that (node1+node2+witness) with version is 10.6.22 (node1)+10.6.22(node2)+galera-4-26.4.19 (witness)
It happened flow control while run ALTER TABLE board MODIFY COLUMN declaration TEXT in node2, then we manual restart node1, but the restart failed, at the same time, the node2 cannot provide read service as well, In other words, it means the cluster crashed
------------------------------------------
the node1 error alert:
2025-08-29 16:42:35 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2025-08-29 16:42:37 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Warning: Memory not freed: 50300856
2025-08-29 16:42:51 0 [Note] Starting MariaDB 10.6.22-MariaDB-log source revision 19644f6821d59ecca0f9b1f44fadb3b887061965 server_uid Gu98QFjGMnijDA3kQgssnPW1GVI= as process 2431561
......
2025-08-29 16:42:55 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
2025-08-29 16:42:55 2 [Note] WSREP: Requesting state transfer failed: No donor candidates temporarily available in suitable state. Will keep retrying every 1 second(s)
2025-08-29 16:42:56 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
.....
-----------------------------------------
the node2 error alert:
2025-08-29 15:56:34 9 [Note] InnoDB: WSREP: BF lock wait long for trx:0x137d8a3 error: Success query: ALTER TABLE board MODIFY COLUMN declaration_of_interest_decision_text_end TEXT
------- TRX HAS BEEN WAITING 50000150 us FOR THIS LOCK TO BE GRANTED:
TABLE LOCK table `eopms`.`writeup_lock` trx id 20437155 lock mode X waiting
...........
2025-08-29 16:42:54 0 [Note] WSREP: Flow-control interval: [707, 707]
2025-08-29 16:42:55 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
2025-08-29 16:42:56 0 [Note] WSREP: Member 0.0 (p1vdbs-csbeopms-peopdb-1-01) requested state transfer from 'any', but it is impossible to select State Transfer donor: No donor candidates temporarily available in suitable state
......