Details
Critical Description
DROP TABLE of child may apply concurrently with UPDATE parent table. It appears that DROP TABLE does not append certification key for parent table, even though it takes MDL lock on the parent (thus causing the BF-BF conflict).
2024-09-26 15:45:15 2 [Note] WSREP: MDL BF-BF conflict
|
schema: test
|
request: (2 seqno 9 wsrep (toi, exec, executing) cmd 0 9 DROP TABLE t2)
|
granted: (11 seqno 10 wsrep (high priority, exec, committing) cmd 0 161 (null))
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
DROP TABLE of child may apply concurrently with UPDATE parent table. It appears that DROP TABLE does not append certification key for parent table, even though it takes MDL lock on the parent (thus causing the BF-BF conflict).
{code} 2024-09-26 15:45:15 2 [Note] WSREP: MDL BF-BF conflict schema: test request: (2 seqno 9 wsrep (toi, exec, executing) cmd 0 9 DROP TABLE t2) granted: (11 seqno 10 wsrep (high priority, exec, committing) cmd 0 161 (n ull)) {code} |
DROP TABLE of child may apply concurrently with UPDATE parent table. It appears that DROP TABLE does not append certification key for parent table, even though it takes MDL lock on the parent (thus causing the BF-BF conflict).
{code} 2024-09-26 15:45:15 2 [Note] WSREP: MDL BF-BF conflict schema: test request: (2 seqno 9 wsrep (toi, exec, executing) cmd 0 9 DROP TABLE t2) granted: (11 seqno 10 wsrep (high priority, exec, committing) cmd 0 161 (null)) {code} |
| Fix Version/s | 10.5.27 [ 29902 ] |
| Affects Version/s | 10.5.26 [ 29832 ] |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.5.26 [ 29832 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.5.27 [ 29902 ] |
| Assignee | Daniele Sciascia [ sciascid ] | Julius Goryavsky [ sysprg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Assignee | Julius Goryavsky [ sysprg ] | Daniele Sciascia [ sciascid ] |
| Assignee | Daniele Sciascia [ sciascid ] | Julius Goryavsky [ sysprg ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.5.28 [ 29952 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.6.21 [ 29953 ] | |
| Fix Version/s | 10.11.11 [ 29954 ] | |
| Fix Version/s | 11.4.5 [ 29956 ] | |
| Fix Version/s | 11.7.2 [ 29914 ] |