Backup fails for different tables (usually small, not always the same, and sometimes it completes successfully), with messages like these:
...
|
2019-12-20 2:50:05 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
[01] mariabackup: Database page corruption detected at page 5, retrying...
|
2019-12-20 2:50:05 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:05 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
2019-12-20 2:50:06 140619606296320 [Note] InnoDB: Log sequence number at the start 1919250543 and the end 1933193007 do not match
|
[01] mariabackup: Error: failed to read page after 10 retries. File ./db/table.ibd seems to be corrupted.
|
[01] mariabackup: Error: xtrabackup_copy_datafile() failed.
|
[01] mariabackup: Error: failed to copy datafile.
|
The table can be read and rebuilt, and next time backup does not fail on this same table.
innochecksum gives something like these for affected tables:
openxs@ao756:/tmp$ ~/dbs/maria10.2/bin/innochecksum -v -i -S /tmp/tt.ibd
|
|
Variables (--variable-name=value)
|
and boolean options {FALSE|TRUE} Value (after reading options)
|
--------------------------------- ----------------------------------------
|
verbose TRUE
|
count FALSE
|
start-page 0
|
end-page 0
|
page 0
|
strict-check crc32
|
no-check FALSE
|
allow-mismatches 0
|
write crc32
|
page-type-summary TRUE
|
page-type-dump (No default value)
|
per-page-details TRUE
|
log (No default value)
|
leaf FALSE
|
merge 0
|
page 0 page 1 page 2 page 3 index id=15027 page 3 leaf 0 n_recs 3 data_bytes 66
|
page 4 index id=15028 page 4 leaf 1 n_recs 13 data_bytes 307
|
page 5 index id=15027 page 5 leaf 1 n_recs 2 data_bytes 52
|
97
|
page 6 index id=15027 page 6 leaf 1 n_recs 6 data_bytes 13714
|
page 7 index id=15027 page 7 leaf 1 n_recs 5 data_bytes 9779
|
Fail: page::8 invalid
|
Exceeded the maximum allowed checksum mismatch count::1 current::0
|
So it's not only mariabackup code that considers the table problematic.
- relates to
-
MDEV-22929
MariaBackup option to report and/or continue when corruption is encountered
-
-
Closed
{"report":{"fcp":737.5999999642372,"ttfb":164.29999995231628,"pageVisibility":"visible","entityId":83054,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ba06b85a-928d-4a10-9831-e1b74edb6be6","navigationType":0,"readyForUser":817.2999999523163,"redirectCount":0,"resourceLoadedEnd":762.8999999761581,"resourceLoadedStart":170.0999999642372,"resourceTiming":[{"duration":6.800000011920929,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":170.0999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":176.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":6.699999988079071,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":170.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":177.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":67.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":170.5,"connectEnd":170.5,"connectStart":170.5,"domainLookupEnd":170.5,"domainLookupStart":170.5,"fetchStart":170.5,"redirectEnd":0,"redirectStart":0,"requestStart":170.5,"responseEnd":237.89999997615814,"responseStart":237.89999997615814,"secureConnectionStart":170.5},{"duration":186.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":170.79999995231628,"connectEnd":170.79999995231628,"connectStart":170.79999995231628,"domainLookupEnd":170.79999995231628,"domainLookupStart":170.79999995231628,"fetchStart":170.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":170.79999995231628,"responseEnd":357.39999997615814,"responseStart":357.39999997615814,"secureConnectionStart":170.79999995231628},{"duration":190.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":170.89999997615814,"connectEnd":170.89999997615814,"connectStart":170.89999997615814,"domainLookupEnd":170.89999997615814,"domainLookupStart":170.89999997615814,"fetchStart":170.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":170.89999997615814,"responseEnd":361.19999998807907,"responseStart":361.19999998807907,"secureConnectionStart":170.89999997615814},{"duration":191.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":171,"connectEnd":171,"connectStart":171,"domainLookupEnd":171,"domainLookupStart":171,"fetchStart":171,"redirectEnd":0,"redirectStart":0,"requestStart":171,"responseEnd":362.39999997615814,"responseStart":362.39999997615814,"secureConnectionStart":171},{"duration":192.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":171.19999998807907,"connectEnd":171.19999998807907,"connectStart":171.19999998807907,"domainLookupEnd":171.19999998807907,"domainLookupStart":171.19999998807907,"fetchStart":171.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":171.19999998807907,"responseEnd":363.39999997615814,"responseStart":363.39999997615814,"secureConnectionStart":171.19999998807907},{"duration":214.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":171.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":385.5,"responseStart":0,"secureConnectionStart":0},{"duration":193.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":171.5,"connectEnd":171.5,"connectStart":171.5,"domainLookupEnd":171.5,"domainLookupStart":171.5,"fetchStart":171.5,"redirectEnd":0,"redirectStart":0,"requestStart":171.5,"responseEnd":365,"responseStart":365,"secureConnectionStart":171.5},{"duration":214,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":171.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":385.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":194.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":171.89999997615814,"connectEnd":171.89999997615814,"connectStart":171.89999997615814,"domainLookupEnd":171.89999997615814,"domainLookupStart":171.89999997615814,"fetchStart":171.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":171.89999997615814,"responseEnd":366.69999998807907,"responseStart":366.69999998807907,"secureConnectionStart":171.89999997615814},{"duration":241.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":178.19999998807907,"connectEnd":178.19999998807907,"connectStart":178.19999998807907,"domainLookupEnd":178.19999998807907,"domainLookupStart":178.19999998807907,"fetchStart":178.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":178.19999998807907,"responseEnd":419.5999999642372,"responseStart":419.5,"secureConnectionStart":178.19999998807907},{"duration":273.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":179.89999997615814,"connectEnd":179.89999997615814,"connectStart":179.89999997615814,"domainLookupEnd":179.89999997615814,"domainLookupStart":179.89999997615814,"fetchStart":179.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":179.89999997615814,"responseEnd":453.39999997615814,"responseStart":453.39999997615814,"secureConnectionStart":179.89999997615814},{"duration":23.099999964237213,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":397.69999998807907,"connectEnd":397.69999998807907,"connectStart":397.69999998807907,"domainLookupEnd":397.69999998807907,"domainLookupStart":397.69999998807907,"fetchStart":397.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":397.69999998807907,"responseEnd":420.7999999523163,"responseStart":420.7999999523163,"secureConnectionStart":397.69999998807907},{"duration":23.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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","startTime":432,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":432,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":455.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":324.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":432.89999997615814,"connectEnd":432.89999997615814,"connectStart":432.89999997615814,"domainLookupEnd":432.89999997615814,"domainLookupStart":432.89999997615814,"fetchStart":432.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":432.89999997615814,"responseEnd":757.5999999642372,"responseStart":757.5999999642372,"secureConnectionStart":432.89999997615814},{"duration":329.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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","startTime":433.2999999523163,"connectEnd":433.2999999523163,"connectStart":433.2999999523163,"domainLookupEnd":433.2999999523163,"domainLookupStart":433.2999999523163,"fetchStart":433.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":433.2999999523163,"responseEnd":762.8999999761581,"responseStart":762.8999999761581,"secureConnectionStart":433.2999999523163},{"duration":202.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":518.2999999523163,"connectEnd":518.2999999523163,"connectStart":518.2999999523163,"domainLookupEnd":518.2999999523163,"domainLookupStart":518.2999999523163,"fetchStart":518.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":518.2999999523163,"responseEnd":720.7999999523163,"responseStart":720.7999999523163,"secureConnectionStart":518.2999999523163},{"duration":131.29999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":729,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":729,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":860.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":140.5999999642372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":750,"connectEnd":750,"connectStart":750,"domainLookupEnd":750,"domainLookupStart":750,"fetchStart":750,"redirectEnd":0,"redirectStart":0,"requestStart":750,"responseEnd":890.5999999642372,"responseStart":890.5999999642372,"secureConnectionStart":750}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":164,"responseEnd":179,"domLoading":168,"domInteractive":884,"domContentLoadedEventStart":884,"domContentLoadedEventEnd":927,"domComplete":1016,"loadEventStart":1016,"loadEventEnd":1017,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":862},{"name":"bigPipe.sidebar-id.end","time":862.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":862.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":863.6999999880791},{"name":"activityTabFullyLoaded","time":948.6999999880791}],"measures":[],"correlationId":"71505a3b06d182","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":13,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
Could this have been addressed by
MDEV-22929?