The following conflict happens on MariaDB 10.4.6 (schema details removed/anonymized:
2019-07-30 0:33:47 42 [Note] WSREP: MDL BF-BF conflict
|
schema: db
|
request: (42 seqno 2086357067 wsrep (toi, exec, committed) cmd 0 102 DROP TRIGGER IF EXISTS aud_tr_t)
|
granted: (37 seqno 2086357068 wsrep (high priority, exec, executing) cmd 0 161 INSERT INTO t ... SELECT ... FROM t1, t2 WHERE ... ON DUPLICATE KEY
|
UPDATE c1 = VALUES(...)
|
2019-07-30 0:33:47 42 [ERROR] Aborting
|
|
2019-07-30 0:34:07 0 [Warning] WSREP: 0x55859a56dea8 down context(s) not set
|
2019-07-30 0:34:07 0 [Warning] WSREP: Failed to send state UUID: -107 (Transport endpoint is not connected)
|
On node1 we see in the processlist (eventually threads were killed):
...
|
1320412 jobs ...:7678 db Killed 3959 wsrep replaying trx DELETE FROM audit_change WHERE id = 459275 0.000
|
1324781 jobs ...l:18998 db Killed 3959 wsrep replaying trx INSERT INTO t ... SELECT ... FROM t1, t2 WHERE ... ON DUPLICATE KEY UPDATE c1 = VALUES(...) 0.000
|
1324822 jobs ...:19118 db Killed 3959 Commit_implicit DROP TRIGGER IF EXISTS aud_tr_t 0.000
|
...
|
Trigger works with that audit_change table.
On node2 we see:
...
|
27 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
28 system user NULL Sleep 4004 After apply log event NULL 0.000
|
29 system user edoc_live_md Sleep 4004 Commit_implicit DROP TRIGGER IF EXISTS aud_tr_t 0.000
|
30 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
31 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
32 system user NULL Sleep 4004 After apply log event NULL 0.000
|
35 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
33 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
36 system user NULL Sleep 4004 committing NULL 0.000
|
37 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
38 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
39 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
40 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
41 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
42 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
43 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
44 system user NULL Sleep 4004 After apply log event NULL 0.000
|
45 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
46 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
47 system user NULL Sleep 4004 Opening tables INSERT INTO t ... SELECT ... FROM t1, t2 WHERE ... ON DUPLICATE KEY UPDATE c1 = VALUES(...) 0.000
|
49 system user NULL Sleep 4004 wsrep applier committed NULL 0.000
|
...
|
We have:
wsrep_slave_threads = 64
|
wsrep_retry_autocommit = 50
|
wsrep_provider_options = "gcache.size=10G; gmcast.segment=2; evs.send_window=256; evs.user_send_window=64;gcs.fc_limit=512;gcs.fc_factor=0.9;evs.keepalive_period=PT3S; evs.suspect_timeout=PT15S; evs.inactive_timeout=PT30S; evs.install_timeout=PT30S; evs.inactive_check_period=PT5S; evs.join_retrans_period=PT2S"
|
I'd expect metadata locks to be set on applier node and prevent attempt to execute DROP TRIGGER in parallel, further fail and retries etc. IMHO it is a bug.
{"report":{"fcp":1342.5,"ttfb":164.69999980926514,"pageVisibility":"visible","entityId":77914,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"7acb9893-9895-46e7-8261-cdeaad69bb09","navigationType":0,"readyForUser":1463.6999998092651,"redirectCount":0,"resourceLoadedEnd":1717.8000001907349,"resourceLoadedStart":173.5,"resourceTiming":[{"duration":368.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":173.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":542.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":369.0999994277954,"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":173.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":542.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":379,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":173.89999961853027,"connectEnd":173.89999961853027,"connectStart":173.89999961853027,"domainLookupEnd":173.89999961853027,"domainLookupStart":173.89999961853027,"fetchStart":173.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":173.89999961853027,"responseEnd":552.8999996185303,"responseStart":552.8000001907349,"secureConnectionStart":173.89999961853027},{"duration":457.30000019073486,"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":174,"connectEnd":174,"connectStart":174,"domainLookupEnd":174,"domainLookupStart":174,"fetchStart":174,"redirectEnd":0,"redirectStart":0,"requestStart":174,"responseEnd":631.3000001907349,"responseStart":631.3000001907349,"secureConnectionStart":174},{"duration":462.9000005722046,"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":174.19999980926514,"connectEnd":174.19999980926514,"connectStart":174.19999980926514,"domainLookupEnd":174.19999980926514,"domainLookupStart":174.19999980926514,"fetchStart":174.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":174.19999980926514,"responseEnd":637.1000003814697,"responseStart":637.1000003814697,"secureConnectionStart":174.19999980926514},{"duration":463.69999980926514,"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":174.5,"connectEnd":174.5,"connectStart":174.5,"domainLookupEnd":174.5,"domainLookupStart":174.5,"fetchStart":174.5,"redirectEnd":0,"redirectStart":0,"requestStart":174.5,"responseEnd":638.1999998092651,"responseStart":638.1999998092651,"secureConnectionStart":174.5},{"duration":464.79999923706055,"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":174.60000038146973,"connectEnd":174.60000038146973,"connectStart":174.60000038146973,"domainLookupEnd":174.60000038146973,"domainLookupStart":174.60000038146973,"fetchStart":174.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":174.60000038146973,"responseEnd":639.3999996185303,"responseStart":639.3999996185303,"secureConnectionStart":174.60000038146973},{"duration":655,"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":174.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":829.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":465.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":174.89999961853027,"connectEnd":174.89999961853027,"connectStart":174.89999961853027,"domainLookupEnd":174.89999961853027,"domainLookupStart":174.89999961853027,"fetchStart":174.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":174.89999961853027,"responseEnd":640.8000001907349,"responseStart":640.8000001907349,"secureConnectionStart":174.89999961853027},{"duration":654.9000005722046,"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":175.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":175.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":467.19999980926514,"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":175.30000019073486,"connectEnd":175.30000019073486,"connectStart":175.30000019073486,"domainLookupEnd":175.30000019073486,"domainLookupStart":175.30000019073486,"fetchStart":175.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":175.30000019073486,"responseEnd":642.5,"responseStart":642.5,"secureConnectionStart":175.30000019073486},{"duration":754.3999996185303,"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":181,"connectEnd":181,"connectStart":181,"domainLookupEnd":181,"domainLookupStart":181,"fetchStart":181,"redirectEnd":0,"redirectStart":0,"requestStart":181,"responseEnd":935.3999996185303,"responseStart":935.3999996185303,"secureConnectionStart":181},{"duration":1536.6000003814697,"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":181.19999980926514,"connectEnd":181.19999980926514,"connectStart":181.19999980926514,"domainLookupEnd":181.19999980926514,"domainLookupStart":181.19999980926514,"fetchStart":181.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":181.19999980926514,"responseEnd":1717.8000001907349,"responseStart":1717.8000001907349,"secureConnectionStart":181.19999980926514},{"duration":66.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":869.5,"connectEnd":869.5,"connectStart":869.5,"domainLookupEnd":869.5,"domainLookupStart":869.5,"fetchStart":869.5,"redirectEnd":0,"redirectStart":0,"requestStart":869.5,"responseEnd":936.1999998092651,"responseStart":936.1999998092651,"secureConnectionStart":869.5},{"duration":600.4000005722046,"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":1208.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1208.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1809.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":599.9000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1209.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1209.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1809.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":594,"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":1210.6000003814697,"connectEnd":1210.6000003814697,"connectStart":1210.6000003814697,"domainLookupEnd":1210.6000003814697,"domainLookupStart":1210.6000003814697,"fetchStart":1210.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1210.6000003814697,"responseEnd":1804.6000003814697,"responseStart":1804.6000003814697,"secureConnectionStart":1210.6000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":4,"responseStart":165,"responseEnd":175,"domLoading":171,"domInteractive":1749,"domContentLoadedEventStart":1749,"domContentLoadedEventEnd":1809,"domComplete":3446,"loadEventStart":3446,"loadEventEnd":3448,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1722.8999996185303},{"name":"bigPipe.sidebar-id.end","time":1723.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1724},{"name":"bigPipe.activity-panel-pipe-id.end","time":1726.6000003814697},{"name":"activityTabFullyLoaded","time":1819.5}],"measures":[],"correlationId":"2532c90a5044e8","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":94,"dbReadsTimeInMs":8,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}