Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.3(EOL)
The test innodb.innodb-index-online often fails like this on 10.6 or later branches. I suspect that it could be due to some changed timing characteristics related to MDEV-32050 .
11.0 5b6134b040b59d6c896ec0a2c86029a0bcca788c
innodb.innodb-index-online '4k,clear,innodb' w19 [ fail ]
Test ended at 2023-11-24 10:49:23
CURRENT_TEST: innodb.innodb-index-online
--- /mariadb/11/mysql-test/suite/innodb/r/innodb-index-online.result 2023-11-24 10:15:47.229132350 +0200
+++ /mariadb/11/mysql-test/suite/innodb/r/innodb-index-online.reject 2023-11-24 10:49:23.174794627 +0200
@@ -170,8 +170,8 @@
ERROR 70100: Query execution was interrupted
SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
name count
-ddl_background_drop_indexes 0
-ddl_online_create_index 0
+ddl_background_drop_indexes 1
+ddl_online_create_index 1
ddl_pending_alter_table 0
ddl_sort_file_alter_table 0
ddl_log_file_alter_table 0
mysqltest: Result content mismatch
The test scenario is the KILL of the following statement:
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2d_created WAIT_FOR kill_done' ;
CREATE INDEX c2d ON t1(c2);
When this operation is rolled back, in row_merge_drop_indexes() we would normally have table->get_ref_count() == 1 . In a failure case, a purge operation would intervene and open a table handle while row_merge_build_indexes() is blocked by the DEBUG_SYNC . This extra table handle would remain open across the rollback operation.
The following patch (which depends on MDEV-32050 , where we started to ignore innodb_purge_rseg_truncate_frequency ) will make the test stable for me. The first hunk makes the test ./mtr --repeat proof, for easier testing.
diff --git a/mysql-test/suite/innodb/t/innodb-index-online.test b/mysql-test/suite/innodb/t/innodb-index-online.test
index 3a38afa84b7..059c9e01a0c 100644
--- a/mysql-test/suite/innodb/t/innodb-index-online.test
+++ b/mysql-test/suite/innodb/t/innodb-index-online.test
@@ -4,6 +4,10 @@
--source include/have_debug_sync.inc
--source include/no_valgrind_without_big.inc
+SET GLOBAL innodb_monitor_reset_all=all;
+--disable_warnings
+SET GLOBAL innodb_monitor_reset_all=default;
+--enable_warnings
let $innodb_metrics_select=
SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
@@ -154,6 +158,7 @@ let $ID= `SELECT @id := CONNECTION_ID()`;
--error ER_QUERY_INTERRUPTED
KILL QUERY @id;
+SET GLOBAL innodb_max_purge_lag_wait=0;
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2d_created WAIT_FOR kill_done';
--send
CREATE INDEX c2d ON t1(c2);
{"report":{"fcp":1087.8999998569489,"ttfb":466.2000000476837,"pageVisibility":"visible","entityId":126610,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"92365e11-4d0c-4891-8fcc-e1614c61911d","navigationType":0,"readyForUser":1161,"redirectCount":0,"resourceLoadedEnd":734.2999999523163,"resourceLoadedStart":479.2999999523163,"resourceTiming":[{"duration":6.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":479.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":479.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":486.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":7.1000001430511475,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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","startTime":479.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":479.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":486.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":177.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/b09d0d077992e4331b5f9ec0d3ec448c-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":479.7000000476837,"connectEnd":479.7000000476837,"connectStart":479.7000000476837,"domainLookupEnd":479.7000000476837,"domainLookupStart":479.7000000476837,"fetchStart":479.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":493.09999990463257,"responseEnd":657.2999999523163,"responseStart":510.2000000476837,"secureConnectionStart":479.7000000476837},{"duration":254.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/b47ab3df14096803b180217eb8482517-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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","startTime":479.7999999523163,"connectEnd":479.7999999523163,"connectStart":479.7999999523163,"domainLookupEnd":479.7999999523163,"domainLookupStart":479.7999999523163,"fetchStart":479.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":495.2000000476837,"responseEnd":734.2999999523163,"responseStart":511.39999985694885,"secureConnectionStart":479.7999999523163},{"duration":10.800000190734863,"initiatorType":"script","name":"https://jira.mariadb.org/s/6c569cbf8087ab04e40d0bef98627457-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":479.89999985694885,"connectEnd":479.89999985694885,"connectStart":479.89999985694885,"domainLookupEnd":479.89999985694885,"domainLookupStart":479.89999985694885,"fetchStart":479.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":479.89999985694885,"responseEnd":490.7000000476837,"responseStart":490.7000000476837,"secureConnectionStart":479.89999985694885},{"duration":35,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":480.09999990463257,"connectEnd":480.09999990463257,"connectStart":480.09999990463257,"domainLookupEnd":480.09999990463257,"domainLookupStart":480.09999990463257,"fetchStart":480.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":495.2999999523163,"responseEnd":515.0999999046326,"responseStart":512.3999998569489,"secureConnectionStart":480.09999990463257},{"duration":12.699999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":480.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":480.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":492.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":35.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":480.2000000476837,"connectEnd":480.2000000476837,"connectStart":480.2000000476837,"domainLookupEnd":480.2000000476837,"domainLookupStart":480.2000000476837,"fetchStart":480.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":495.39999985694885,"responseEnd":515.3999998569489,"responseStart":513,"secureConnectionStart":480.2000000476837},{"duration":35.299999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":480.2999999523163,"connectEnd":480.2999999523163,"connectStart":480.2999999523163,"domainLookupEnd":480.2999999523163,"domainLookupStart":480.2999999523163,"fetchStart":480.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":496.2999999523163,"responseEnd":515.5999999046326,"responseStart":513.5999999046326,"secureConnectionStart":480.2999999523163},{"duration":14.599999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":480.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":480.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":495.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":39.200000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":480.5,"connectEnd":480.5,"connectStart":480.5,"domainLookupEnd":480.5,"domainLookupStart":480.5,"fetchStart":480.5,"redirectEnd":0,"redirectStart":0,"requestStart":498.59999990463257,"responseEnd":519.7000000476837,"responseStart":517.7999999523163,"secureConnectionStart":480.5},{"duration":12.799999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":497.7999999523163,"connectEnd":497.7999999523163,"connectStart":497.7999999523163,"domainLookupEnd":497.7999999523163,"domainLookupStart":497.7999999523163,"fetchStart":497.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":497.7999999523163,"responseEnd":510.59999990463257,"responseStart":510.59999990463257,"secureConnectionStart":497.7999999523163},{"duration":21.200000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":497.89999985694885,"connectEnd":497.89999985694885,"connectStart":497.89999985694885,"domainLookupEnd":497.89999985694885,"domainLookupStart":497.89999985694885,"fetchStart":497.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":497.89999985694885,"responseEnd":519.0999999046326,"responseStart":519.0999999046326,"secureConnectionStart":497.89999985694885},{"duration":196.39999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":845.7000000476837,"connectEnd":845.7000000476837,"connectStart":845.7000000476837,"domainLookupEnd":845.7000000476837,"domainLookupStart":845.7000000476837,"fetchStart":845.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1012.0999999046326,"responseEnd":1042.0999999046326,"responseStart":1041.3999998569489,"secureConnectionStart":845.7000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":22,"responseStart":466,"responseEnd":497,"domLoading":469,"domInteractive":1220,"domContentLoadedEventStart":1220,"domContentLoadedEventEnd":1263,"domComplete":2472,"loadEventStart":2472,"loadEventEnd":2472,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1201.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1201.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1202},{"name":"bigPipe.activity-panel-pipe-id.end","time":1204.5},{"name":"activityTabFullyLoaded","time":1271.5999999046326}],"measures":[],"correlationId":"a89c18cfd450e6","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":345,"dbReadsTimeInMs":15,"dbConnsTimeInMs":25,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}