The if branch of wsrep_handle_mdl_conflict():
else if (granted_thd->lex->sql_command == SQLCOM_FLUSH ||
granted_thd->mdl_context.has_explicit_locks())
{
WSREP_DEBUG("BF thread waiting for FLUSH");
doesn't consider that there may be regular transactions having explicit MDL locks.
Example output:
2023-12-28 17:44:17 2 [Note] WSREP: Wsrep_high_priority_service::apply_toi: 1831
2023-12-28 17:44:17 2 [Note] WSREP: assigned new next query and trx id: 4379
T@4 : 17:44:17.637771 Query_log_event::do_apply_event: query: TRUNCATE TABLE t1
T@4 : 17:44:17.637797 reset_current_stmt_binlog_format_row: debug: temporary_tables: no, in_sub_stmt: no, system_thread: SYSTEM_THREAD_SLAVE_SQL
2023-12-28 17:44:17 2 [Note] WSREP: MDL conflict·
schema: test
request: (2 seqno 1831 wsrep (toi, exec, committed) cmd 0 8 TRUNCATE TABLE t1)
granted: (237 seqno -1 wsrep (local, exec, executing) cmd 3 5 INSERT INTO t1 VALUE (4, 'z'))
2023-12-28 17:44:17 2 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
2023-12-28 17:44:17 2 [Note] WSREP: BF thread waiting for FLUSH
2023-12-28 17:44:17 2 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
Fixed debug output printing SQL query in the mentioned if branch results in:
2023-12-28 20:09:11 2 [Note] WSREP: Wsrep_high_priority_service::apply_toi: 6599
2023-12-28 20:09:11 2 [Note] WSREP: assigned new next query and trx id: 16942
T@4 : 20:09:11.867236 Query_log_event::do_apply_event: query: TRUNCATE TABLE t1
T@4 : 20:09:11.867266 reset_current_stmt_binlog_format_row: debug: temporary_tables: no, in_sub_stmt: no, system_thread: SYSTEM_THREAD_SLAVE_SQL
2023-12-28 20:09:11 2 [Note] WSREP: MDL conflict·
schema: test
request: (2 seqno 6599 wsrep (toi, exec, committed) cmd 0 8 TRUNCATE TABLE t1)
granted: (907 seqno -1 wsrep (local, exec, executing) cmd 3 5 INSERT INTO t1 VALUE (4, 'z'))
2023-12-28 20:09:11 2 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
2023-12-28 20:09:11 2 [Note] WSREP: BF thread waiting for INSERT INTO t1 VALUE (4, 'z')
2023-12-28 20:09:11 2 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
In this case no BF-abort happens as the DML operation INSERT INTO t1 VALUE (4, 'z') holding explicit MDL locks is treated as FLUSH TABLES, which is not the case. This prevents such an operation to be aborted.
The reason why a DML operation may hold explicit locks is an open question.
relates to
MDEV-32160
GCF-1060 test failure due to wsrep MDL conflict
Closed
made changes -
2024-01-18 10:01
Assignee
Denis Protivensky
[ JIRAUSER52676
]
made changes -
2024-01-18 10:01
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2024-02-09 09:35
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.4
[ 22408
]
Affects Version/s
10.6.17
[ 29518
]
Affects Version/s
10.4.32
[ 29300
]
made changes -
2024-02-09 09:37
Status
In Progress
[ 3
]
In Testing
[ 10301
]
made changes -
2024-02-09 09:37
Assignee
Denis Protivensky
[ JIRAUSER52676
]
Julius Goryavsky
[ sysprg
]
made changes -
2024-03-27 06:15
Status
In Testing
[ 10301
]
Stalled
[ 10000
]
made changes -
2024-03-27 06:15
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2024-03-27 06:16
Fix Version/s
10.6.18
[ 29627
]
Fix Version/s
10.6
[ 24028
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
made changes -
2024-03-27 06:16
Fix Version/s
10.11.8
[ 29630
]
Fix Version/s
11.0.6
[ 29628
]
Fix Version/s
11.1.5
[ 29629
]
Fix Version/s
11.2.4
[ 29631
]
{"report":{"fcp":1024.1999998092651,"ttfb":402.69999980926514,"pageVisibility":"visible","entityId":127095,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"99748999-6767-42a8-b242-21cf047e6479","navigationType":0,"readyForUser":1126.1999998092651,"redirectCount":0,"resourceLoadedEnd":1222.8999996185303,"resourceLoadedStart":409.3999996185303,"resourceTiming":[{"duration":123.10000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":409.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":409.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.5,"responseStart":0,"secureConnectionStart":0},{"duration":123.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":409.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":409.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":133.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":409.8999996185303,"connectEnd":409.8999996185303,"connectStart":409.8999996185303,"domainLookupEnd":409.8999996185303,"domainLookupStart":409.8999996185303,"fetchStart":409.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":409.8999996185303,"responseEnd":543,"responseStart":543,"secureConnectionStart":409.8999996185303},{"duration":211.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":410.1000003814697,"connectEnd":410.1000003814697,"connectStart":410.1000003814697,"domainLookupEnd":410.1000003814697,"domainLookupStart":410.1000003814697,"fetchStart":410.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":410.1000003814697,"responseEnd":621.1999998092651,"responseStart":621.1999998092651,"secureConnectionStart":410.1000003814697},{"duration":214.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":410.3999996185303,"connectEnd":410.3999996185303,"connectStart":410.3999996185303,"domainLookupEnd":410.3999996185303,"domainLookupStart":410.3999996185303,"fetchStart":410.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":410.3999996185303,"responseEnd":625,"responseStart":625,"secureConnectionStart":410.3999996185303},{"duration":214.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":410.5,"connectEnd":410.5,"connectStart":410.5,"domainLookupEnd":410.5,"domainLookupStart":410.5,"fetchStart":410.5,"redirectEnd":0,"redirectStart":0,"requestStart":410.5,"responseEnd":625.3999996185303,"responseStart":625.3999996185303,"secureConnectionStart":410.5},{"duration":215.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":410.6000003814697,"connectEnd":410.6000003814697,"connectStart":410.6000003814697,"domainLookupEnd":410.6000003814697,"domainLookupStart":410.6000003814697,"fetchStart":410.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":410.6000003814697,"responseEnd":625.8000001907349,"responseStart":625.8000001907349,"secureConnectionStart":410.6000003814697},{"duration":275.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":410.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":410.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":686.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":215.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":411,"connectEnd":411,"connectStart":411,"domainLookupEnd":411,"domainLookupStart":411,"fetchStart":411,"redirectEnd":0,"redirectStart":0,"requestStart":411,"responseEnd":626.3000001907349,"responseStart":626.3000001907349,"secureConnectionStart":411},{"duration":275.6000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":411.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":411.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":686.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":215.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":411.30000019073486,"connectEnd":411.30000019073486,"connectStart":411.30000019073486,"domainLookupEnd":411.30000019073486,"domainLookupStart":411.30000019073486,"fetchStart":411.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":411.30000019073486,"responseEnd":626.8000001907349,"responseStart":626.8000001907349,"secureConnectionStart":411.30000019073486},{"duration":352.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":412.3999996185303,"connectEnd":412.3999996185303,"connectStart":412.3999996185303,"domainLookupEnd":412.3999996185303,"domainLookupStart":412.3999996185303,"fetchStart":412.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":412.3999996185303,"responseEnd":765.1000003814697,"responseStart":765.1000003814697,"secureConnectionStart":412.3999996185303},{"duration":773.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":416.69999980926514,"connectEnd":416.69999980926514,"connectStart":416.69999980926514,"domainLookupEnd":416.69999980926514,"domainLookupStart":416.69999980926514,"fetchStart":416.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":416.69999980926514,"responseEnd":1190.1999998092651,"responseStart":1190.1999998092651,"secureConnectionStart":416.69999980926514},{"duration":67.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":698.6999998092651,"connectEnd":698.6999998092651,"connectStart":698.6999998092651,"domainLookupEnd":698.6999998092651,"domainLookupStart":698.6999998092651,"fetchStart":698.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":698.6999998092651,"responseEnd":765.8999996185303,"responseStart":765.8000001907349,"secureConnectionStart":698.6999998092651},{"duration":257.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":965.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":965.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1222.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":231.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":966.6999998092651,"connectEnd":966.6999998092651,"connectStart":966.6999998092651,"domainLookupEnd":966.6999998092651,"domainLookupStart":966.6999998092651,"fetchStart":966.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":966.6999998092651,"responseEnd":1198.1999998092651,"responseStart":1198.1999998092651,"secureConnectionStart":966.6999998092651},{"duration":234.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":967.1999998092651,"connectEnd":967.1999998092651,"connectStart":967.1999998092651,"domainLookupEnd":967.1999998092651,"domainLookupStart":967.1999998092651,"fetchStart":967.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":967.1999998092651,"responseEnd":1201.3000001907349,"responseStart":1201.3000001907349,"secureConnectionStart":967.1999998092651},{"duration":324.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1012.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1012.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1337.1999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":178,"responseStart":403,"responseEnd":407,"domLoading":407,"domInteractive":1291,"domContentLoadedEventStart":1291,"domContentLoadedEventEnd":1337,"domComplete":1713,"loadEventStart":1713,"loadEventEnd":1713,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1254.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1255.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1255.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1259.3000001907349},{"name":"activityTabFullyLoaded","time":1358.6999998092651}],"measures":[],"correlationId":"922a4c4c68d8dc","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":132,"dbReadsTimeInMs":23,"dbConnsTimeInMs":32,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Major MDEV-32160 GCF-1060 test failure due to wsrep MDL conflict
