galera.galera_mdl_race failed on bb.
stdio.log:
10.4.12 983163209d026bfd979b4298053fcbdb373efa9d
|
galera.galera_mdl_race 'innodb' w1 [ fail ]
|
Test ended at 2020-01-08 18:05:01
|
|
CURRENT_TEST: galera.galera_mdl_race
|
mysqltest: At line 58: query 'reap' succeeded - should have failed with errno 1213...
|
|
The result from queries just before the failure was:
|
< snip >
|
connection node_1;
|
SET AUTOCOMMIT=ON;
|
START TRANSACTION;
|
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
|
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
connection node_1a;
|
LOCK TABLE t2 WRITE;
|
connection node_1;
|
SET @@debug_dbug = "d,sync.wsrep_before_mdl_wait";
|
SELECT * FROM t2;;
|
connection node_1a;
|
SET @@debug_dbug = "d,sync.wsrep_after_BF_victim_lock";
|
connection node_2;
|
UPDATE t1 SET f2 = 'c' WHERE f1 = 1;
|
connection node_1a;
|
SET @@debug_dbug = "";
|
SET DEBUG_SYNC = "now SIGNAL signal.wsrep_before_mdl_wait";
|
SET DEBUG_SYNC = "now SIGNAL signal.wsrep_after_BF_victim_lock";
|
UNLOCK TABLES;
|
connection node_1;
|
|
More results from queries before failure can be found in /dev/shm/var/1/log/galera_mdl_race.log
|
|
- skipping '/dev/shm/var/1/log/galera.galera_mdl_race-innodb/'
|
|
Retrying test galera.galera_mdl_race, attempt(2/3)...
|
|
galera.MDEV-6860 'innodb' w2 [ skipped ] Test requires wsrep_on=ON
|
worker[2] > Restart [mysqld.1 - pid: 9307, winpid: 9307] - using different config file
|
worker[2] > Restart [mysqld.2 - pid: 9309, winpid: 9309] - using different config file
|
worker[2] > Restart [mysqld.3 - pid: 9373, winpid: 9373] - using different config file
|
galera.galera_multi_database 'innodb' w1 [ pass ] 2055
|
galera.galera_myisam_autocommit 'innodb' w1 [ pass ] 2050
|
galera.galera_mdl_race 'innodb' w1 [ retry-pass ] 2095
|
|
Retrying test galera.galera_mdl_race, attempt(3/3)...
|
|
galera.galera_myisam_transactions 'innodb' w1 [ pass ] 2082
|
galera.galera_nopk_bit 'innodb' w1 [ pass ] 2095
|
galera.galera_mdl_race 'innodb' w1 [ retry-pass ] 2073
|
There are no comments yet on this issue.
{"report":{"fcp":1567.5,"ttfb":452.09999990463257,"pageVisibility":"visible","entityId":82449,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"4c5862b2-26f9-4c08-8340-58833e298b53","navigationType":0,"readyForUser":1659.3999996185303,"redirectCount":0,"resourceLoadedEnd":2138.8999996185303,"resourceLoadedStart":460.69999980926514,"resourceTiming":[{"duration":622.1999998092651,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":460.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":460.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1082.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":622.1999998092651,"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":461,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1083.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":631.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":461.19999980926514,"connectEnd":461.19999980926514,"connectStart":461.19999980926514,"domainLookupEnd":461.19999980926514,"domainLookupStart":461.19999980926514,"fetchStart":461.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":461.19999980926514,"responseEnd":1092.5999999046326,"responseStart":1092.5999999046326,"secureConnectionStart":461.19999980926514},{"duration":696.6000003814697,"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":461.3999996185303,"connectEnd":461.3999996185303,"connectStart":461.3999996185303,"domainLookupEnd":461.3999996185303,"domainLookupStart":461.3999996185303,"fetchStart":461.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":461.3999996185303,"responseEnd":1158,"responseStart":1158,"secureConnectionStart":461.3999996185303},{"duration":700.4000000953674,"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":461.59999990463257,"connectEnd":461.59999990463257,"connectStart":461.59999990463257,"domainLookupEnd":461.59999990463257,"domainLookupStart":461.59999990463257,"fetchStart":461.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":461.59999990463257,"responseEnd":1162,"responseStart":1162,"secureConnectionStart":461.59999990463257},{"duration":700.8000001907349,"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":461.69999980926514,"connectEnd":461.69999980926514,"connectStart":461.69999980926514,"domainLookupEnd":461.69999980926514,"domainLookupStart":461.69999980926514,"fetchStart":461.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":461.69999980926514,"responseEnd":1162.5,"responseStart":1162.5,"secureConnectionStart":461.69999980926514},{"duration":700.9000000953674,"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":461.8999996185303,"connectEnd":461.8999996185303,"connectStart":461.8999996185303,"domainLookupEnd":461.8999996185303,"domainLookupStart":461.8999996185303,"fetchStart":461.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":461.8999996185303,"responseEnd":1162.7999997138977,"responseStart":1162.7999997138977,"secureConnectionStart":461.8999996185303},{"duration":775.6999998092651,"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":462,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1237.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":701,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":462.19999980926514,"connectEnd":462.19999980926514,"connectStart":462.19999980926514,"domainLookupEnd":462.19999980926514,"domainLookupStart":462.19999980926514,"fetchStart":462.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":462.19999980926514,"responseEnd":1163.1999998092651,"responseStart":1163.1999998092651,"secureConnectionStart":462.19999980926514},{"duration":775.5,"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":462.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1237.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":701.2999997138977,"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":462.5,"connectEnd":462.5,"connectStart":462.5,"domainLookupEnd":462.5,"domainLookupStart":462.5,"fetchStart":462.5,"redirectEnd":0,"redirectStart":0,"requestStart":462.5,"responseEnd":1163.7999997138977,"responseStart":1163.7999997138977,"secureConnectionStart":462.5},{"duration":1265.5,"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":475.19999980926514,"connectEnd":475.19999980926514,"connectStart":475.19999980926514,"domainLookupEnd":475.19999980926514,"domainLookupStart":475.19999980926514,"fetchStart":475.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":475.19999980926514,"responseEnd":1740.6999998092651,"responseStart":1740.6999998092651,"secureConnectionStart":475.19999980926514},{"duration":1663.5999999046326,"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":475.2999997138977,"connectEnd":475.2999997138977,"connectStart":475.2999997138977,"domainLookupEnd":475.2999997138977,"domainLookupStart":475.2999997138977,"fetchStart":475.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":475.2999997138977,"responseEnd":2138.8999996185303,"responseStart":2138.8999996185303,"secureConnectionStart":475.2999997138977},{"duration":498.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1251.5,"connectEnd":1251.5,"connectStart":1251.5,"domainLookupEnd":1251.5,"domainLookupStart":1251.5,"fetchStart":1251.5,"redirectEnd":0,"redirectStart":0,"requestStart":1251.5,"responseEnd":1750.0999999046326,"responseStart":1750.0999999046326,"secureConnectionStart":1251.5},{"duration":640.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1560.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1560.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2201.199999809265,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":297,"responseStart":452,"responseEnd":473,"domLoading":459,"domInteractive":2157,"domContentLoadedEventStart":2157,"domContentLoadedEventEnd":2200,"domComplete":2454,"loadEventStart":2455,"loadEventEnd":2455,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2140.699999809265},{"name":"bigPipe.sidebar-id.end","time":2141.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":2141.7999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":2142.2999997138977},{"name":"activityTabFullyLoaded","time":2221.7999997138977}],"measures":[],"correlationId":"ecd288e9f0833c","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":86,"dbReadsTimeInMs":9,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}