Details
Description
Hi,
Our Galera cluster architecture is 2 DB nodes + 1 witness node. Most DB traffic is redirected to one DB node.
One of our Galera cluster encounter one node down (wsrep_ready=OFF). We restarted the DB node but IST encountered the same error. We need to remove data directory and let Galera to trigger SST in order to resume the DB node.
DB version is 10.6.10 and Galera version is 26.4.12
We have another similar incident MDEV-30303
2023-01-06 22:04:55 2 [Note] WSREP: MDL BF-BF conflict |
schema: tswtrn1
|
request: (2 seqno 31040753 wsrep (high priority, exec, executing) cmd 0 161 select nextval(`SEQUENCE_LPCO_ID`)<87>*<B8>c^S^A) |
granted: (6 seqno 31040752 wsrep (high priority, exec, preparing) cmd 0 161 (null)) |
2023-01-06 22:04:55 2 [ERROR] Aborting |
Attachments
Issue Links
- relates to
-
MDEV-30303 run optimize table got [Note] WSREP: MDL BF-BF conflict and [ERROR] Aborting
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
19d 4h 2m | 1 |
|
38d 14h 29m | 1 |
|
18m 14s | 1 |
|
45s | 1 |
|
1d 1h 17m | 1 |
|
7s | 1 |
|
7d 4h 7m | 1 |
|
4d 18h 45m | 1 |
|
21h 20m | 1 |
|
7s | 1 |
|
2m 29s | 2 |
|
2d 8h | 2 |
|
11m 35s | 1 |