Details
Major Description
The server crashes with:
2023-12-28 17:29:32 89 [Note] WSREP: ::rollback() thread: 89, client_state exec client_mode high priority trans_state aborted killed 0
|
2023-12-28 17:29:32 76 [Note] WSREP: MDL conflict·
|
schema: test
|
request: (75 seqno 626 wsrep (toi, exec, aborted) cmd 3 8 TRUNCATE TABLE t1)
|
granted: (89 seqno -1 wsrep (high priority, exec, aborting) cmd 0 161 (null))
|
2023-12-28 17:29:32 76 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
|
2023-12-28 17:29:32 76 [Note] WSREP: MDL BF-BF conflict
|
schema: test
|
request: (75 seqno 626 wsrep (toi, exec, aborted) cmd 3 8 TRUNCATE TABLE t1)
|
granted: (89 seqno -1 wsrep (high priority, exec, aborted) cmd 0 161 (null))
|
2023-12-28 17:29:32 76 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
|
2023-12-28 17:29:32 76 [ERROR] Aborting
|
The problem is as following:
Applied SR transaction gets BF-aborted, but there is a time window when it's already rolled back and its wsrep transaction's state is set to aborted, but it has not released MDL locks yet. This situation is incorrectly determined during MDL conflict handling and the server aborts thinking there are two high-priority transactions (TOI and high-prio applied) conflicting, which should never happen.
Attachments
Issue Links
- relates to
-
MDEV-32160 GCF-1060 test failure due to wsrep MDL conflict
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Assignee | Denis Protivensky [ JIRAUSER52676 ] |
| Affects Version/s | 10.4.32 [ 29300 ] |
| Fix Version/s | 10.4 [ 22408 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | mysqld.2.err [ 72717 ] | |
| Attachment | mysqld.1.err [ 72718 ] |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.6.16 [ 29014 ] | |
| Affects Version/s | 10.4.32 [ 29300 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Assignee | Denis Protivensky [ JIRAUSER52676 ] | Julius Goryavsky [ sysprg ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.5.27 [ 29902 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.6.20 [ 29903 ] | |
| Fix Version/s | 10.11.10 [ 29904 ] | |
| Fix Version/s | 11.2.6 [ 29906 ] | |
| Fix Version/s | 11.4.4 [ 29907 ] |