The tests innodb.log_file_name_debug (and theoretically innodb.innodb-index) can cause a subsequent recovery test to fail:
./mtr --no-reorder innodb.log_file_name_debug innodb.read_only_recovery
10.4 c761b43451d54eeeecdf3c102906fcce88d4e9d9
innodb.log_file_name_debug 'innodb' [ pass ] 6736
innodb.read_only_recovery 'innodb' [ fail ] Found warnings/errors in server log file!
Test ended at 2018-11-08 14:29:29
line
2018-11-08 14:29:24 0 [Warning] InnoDB: Tablespace 4294967280 was not found at ./test/bogus file.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!
The first test does inject this error and does run crash recovery. But it fails to ensure that a redo log checkpoint will occur.
So, if a subsequent test executes crash recovery, it can get the warning due to the fault that was injected in the previous test.
The fix is to add an extra shutdown to the first test:
diff --git a/mysql-test/suite/innodb/t/log_file_name_debug.test b/mysql-test/suite/innodb/t/log_file_name_debug.test
index 0aaf798e2b3..d85fbf08194 100644
--- a/mysql-test/suite/innodb/t/log_file_name_debug.test
+++ b/mysql-test/suite/innodb/t/log_file_name_debug.test
@@ -44,5 +44,7 @@ SELECT * FROM t1;
--let $restart_parameters=
--source include/restart_mysqld.inc
+# Initiate shutdown in order to issue a redo log checkpoint and to discard
+# the redo log record that was emitted due to '+d,fil_names_write_bogus'.
+--source include/restart_mysqld.inc
DROP TABLE t1;
-
A similar problem is theoretically possible with innodb.innodb-index, but I was not able to repeat it. It is better to be safe than sorry:
diff --git a/mysql-test/suite/innodb/t/innodb-index.test b/mysql-test/suite/innodb/t/innodb-index.test
index 97014d84ca7..e575cff4774 100644
--- a/mysql-test/suite/innodb/t/innodb-index.test
+++ b/mysql-test/suite/innodb/t/innodb-index.test
@@ -1115,6 +1115,11 @@ AND support IN ('YES', 'DEFAULT', 'ENABLED');
--move_file $MYSQLD_DATADIR/test/t0.ibd $MYSQLD_DATADIR/test/t1.ibd
--source include/start_mysqld.inc
+if ($have_debug) {
+# Initiate shutdown in order to issue a redo log checkpoint and to discard
+# the redo log record that was emitted due to '+d,fil_names_write_bogus'.
+--source include/restart_mysqld.inc
+}
SELECT * FROM t1;
SELECT * FROM t2;
Marko Mäkelä
made changes -
2018-11-08 12:53
Field
Original Value
New Value
issue.field.resolutiondate
2018-11-08 12:53:40.0
2018-11-08 12:53:40.846
Marko Mäkelä
made changes -
2018-11-08 12:53
Fix Version/s
10.3.11
[ 23141
]
Fix Version/s
10.2.19
[ 23207
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:48
Workflow
MariaDB v3
[ 90491
]
MariaDB v4
[ 155171
]
{"report":{"fcp":940.7000002861023,"ttfb":271.30000019073486,"pageVisibility":"visible","entityId":70676,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"2076d2e9-cc30-4016-8557-b3fa7484e989","navigationType":0,"readyForUser":1028.2000002861023,"redirectCount":0,"resourceLoadedEnd":1090.0999999046326,"resourceLoadedStart":275.90000009536743,"resourceTiming":[{"duration":63.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":275.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":275.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":339.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":63.80000019073486,"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":276.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":276.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":339.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":119.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":276.30000019073486,"connectEnd":276.30000019073486,"connectStart":276.30000019073486,"domainLookupEnd":276.30000019073486,"domainLookupStart":276.30000019073486,"fetchStart":276.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":276.30000019073486,"responseEnd":396.09999990463257,"responseStart":396.09999990463257,"secureConnectionStart":276.30000019073486},{"duration":177.40000009536743,"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":276.5,"connectEnd":276.5,"connectStart":276.5,"domainLookupEnd":276.5,"domainLookupStart":276.5,"fetchStart":276.5,"redirectEnd":0,"redirectStart":0,"requestStart":276.5,"responseEnd":453.90000009536743,"responseStart":453.90000009536743,"secureConnectionStart":276.5},{"duration":181,"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":276.59999990463257,"connectEnd":276.59999990463257,"connectStart":276.59999990463257,"domainLookupEnd":276.59999990463257,"domainLookupStart":276.59999990463257,"fetchStart":276.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":276.59999990463257,"responseEnd":457.59999990463257,"responseStart":457.59999990463257,"secureConnectionStart":276.59999990463257},{"duration":181.2999997138977,"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":276.80000019073486,"connectEnd":276.80000019073486,"connectStart":276.80000019073486,"domainLookupEnd":276.80000019073486,"domainLookupStart":276.80000019073486,"fetchStart":276.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":276.80000019073486,"responseEnd":458.09999990463257,"responseStart":458.09999990463257,"secureConnectionStart":276.80000019073486},{"duration":181.5,"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":277,"connectEnd":277,"connectStart":277,"domainLookupEnd":277,"domainLookupStart":277,"fetchStart":277,"redirectEnd":0,"redirectStart":0,"requestStart":277,"responseEnd":458.5,"responseStart":458.5,"secureConnectionStart":277},{"duration":265.09999990463257,"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":277.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":277.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":542.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":181.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":277.30000019073486,"connectEnd":277.30000019073486,"connectStart":277.30000019073486,"domainLookupEnd":277.30000019073486,"domainLookupStart":277.30000019073486,"fetchStart":277.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":277.30000019073486,"responseEnd":458.90000009536743,"responseStart":458.90000009536743,"secureConnectionStart":277.30000019073486},{"duration":264.80000019073486,"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":277.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":277.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":542.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":181.7999997138977,"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":277.7000002861023,"connectEnd":277.7000002861023,"connectStart":277.7000002861023,"domainLookupEnd":277.7000002861023,"domainLookupStart":277.7000002861023,"fetchStart":277.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":277.7000002861023,"responseEnd":459.5,"responseStart":459.5,"secureConnectionStart":277.7000002861023},{"duration":541.7999997138977,"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":283.80000019073486,"connectEnd":283.80000019073486,"connectStart":283.80000019073486,"domainLookupEnd":283.80000019073486,"domainLookupStart":283.80000019073486,"fetchStart":283.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":283.80000019073486,"responseEnd":825.5999999046326,"responseStart":825.5999999046326,"secureConnectionStart":283.80000019073486},{"duration":604.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":284.5,"connectEnd":284.5,"connectStart":284.5,"domainLookupEnd":284.5,"domainLookupStart":284.5,"fetchStart":284.5,"redirectEnd":0,"redirectStart":0,"requestStart":284.5,"responseEnd":889,"responseStart":889,"secureConnectionStart":284.5},{"duration":270.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":555.5999999046326,"connectEnd":555.5999999046326,"connectStart":555.5999999046326,"domainLookupEnd":555.5999999046326,"domainLookupStart":555.5999999046326,"fetchStart":555.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":555.5999999046326,"responseEnd":826,"responseStart":826,"secureConnectionStart":555.5999999046326},{"duration":93,"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":841.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":841.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":934.5,"responseStart":0,"secureConnectionStart":0},{"duration":247.59999990463257,"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":842.5,"connectEnd":842.5,"connectStart":842.5,"domainLookupEnd":842.5,"domainLookupStart":842.5,"fetchStart":842.5,"redirectEnd":0,"redirectStart":0,"requestStart":842.5,"responseEnd":1090.0999999046326,"responseStart":1090.0999999046326,"secureConnectionStart":842.5},{"duration":273.59999990463257,"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":842.9000000953674,"connectEnd":842.9000000953674,"connectStart":842.9000000953674,"domainLookupEnd":842.9000000953674,"domainLookupStart":842.9000000953674,"fetchStart":842.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":842.9000000953674,"responseEnd":1116.5,"responseStart":1116.5,"secureConnectionStart":842.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":87,"responseStart":271,"responseEnd":284,"domLoading":274,"domInteractive":1094,"domContentLoadedEventStart":1094,"domContentLoadedEventEnd":1141,"domComplete":1499,"loadEventStart":1499,"loadEventEnd":1500,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1065},{"name":"bigPipe.sidebar-id.end","time":1066.2000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1066.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1068.0999999046326},{"name":"activityTabFullyLoaded","time":1162.0999999046326}],"measures":[],"correlationId":"1f2b2c02c35243","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}