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":880.1000003814697,"ttfb":180.19999980926514,"pageVisibility":"visible","entityId":83054,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"6996ab37-67dd-406e-a70c-1e1ab17dceb9","navigationType":0,"readyForUser":967.3000001907349,"redirectCount":0,"resourceLoadedEnd":829.1000003814697,"resourceLoadedStart":206.89999961853027,"resourceTiming":[{"duration":141.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":206.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":348.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":141.30000019073486,"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":207.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":207.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":348.5,"responseStart":0,"secureConnectionStart":0},{"duration":150,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":207.39999961853027,"connectEnd":207.39999961853027,"connectStart":207.39999961853027,"domainLookupEnd":207.39999961853027,"domainLookupStart":207.39999961853027,"fetchStart":207.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":207.39999961853027,"responseEnd":357.3999996185303,"responseStart":357.3999996185303,"secureConnectionStart":207.39999961853027},{"duration":276,"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":207.60000038146973,"connectEnd":207.60000038146973,"connectStart":207.60000038146973,"domainLookupEnd":207.60000038146973,"domainLookupStart":207.60000038146973,"fetchStart":207.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":207.60000038146973,"responseEnd":483.6000003814697,"responseStart":483.6000003814697,"secureConnectionStart":207.60000038146973},{"duration":279.69999980926514,"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":207.80000019073486,"connectEnd":207.80000019073486,"connectStart":207.80000019073486,"domainLookupEnd":207.80000019073486,"domainLookupStart":207.80000019073486,"fetchStart":207.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":207.80000019073486,"responseEnd":487.5,"responseStart":487.5,"secureConnectionStart":207.80000019073486},{"duration":279.9000005722046,"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":208.19999980926514,"connectEnd":208.19999980926514,"connectStart":208.19999980926514,"domainLookupEnd":208.19999980926514,"domainLookupStart":208.19999980926514,"fetchStart":208.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":208.19999980926514,"responseEnd":488.1000003814697,"responseStart":488,"secureConnectionStart":208.19999980926514},{"duration":279.8999996185303,"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":208.5,"connectEnd":208.5,"connectStart":208.5,"domainLookupEnd":208.5,"domainLookupStart":208.5,"fetchStart":208.5,"redirectEnd":0,"redirectStart":0,"requestStart":208.5,"responseEnd":488.3999996185303,"responseStart":488.3999996185303,"secureConnectionStart":208.5},{"duration":306.0999994277954,"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":208.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":208.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":514.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":280.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":208.80000019073486,"connectEnd":208.80000019073486,"connectStart":208.80000019073486,"domainLookupEnd":208.80000019073486,"domainLookupStart":208.80000019073486,"fetchStart":208.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":208.80000019073486,"responseEnd":489,"responseStart":489,"secureConnectionStart":208.80000019073486},{"duration":306,"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":209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":515,"responseStart":0,"secureConnectionStart":0},{"duration":280.5,"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":209.10000038146973,"connectEnd":209.10000038146973,"connectStart":209.10000038146973,"domainLookupEnd":209.10000038146973,"domainLookupStart":209.10000038146973,"fetchStart":209.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":209.10000038146973,"responseEnd":489.6000003814697,"responseStart":489.6000003814697,"secureConnectionStart":209.10000038146973},{"duration":348.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":210,"connectEnd":210,"connectStart":210,"domainLookupEnd":210,"domainLookupStart":210,"fetchStart":210,"redirectEnd":0,"redirectStart":0,"requestStart":210,"responseEnd":558.5,"responseStart":558.5,"secureConnectionStart":210},{"duration":436.80000019073486,"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":210,"connectEnd":210,"connectStart":210,"domainLookupEnd":210,"domainLookupStart":210,"fetchStart":210,"redirectEnd":0,"redirectStart":0,"requestStart":210,"responseEnd":646.8000001907349,"responseStart":646.8000001907349,"secureConnectionStart":210},{"duration":28.800000190734863,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":532,"connectEnd":532,"connectStart":532,"domainLookupEnd":532,"domainLookupStart":532,"fetchStart":532,"redirectEnd":0,"redirectStart":0,"requestStart":532,"responseEnd":560.8000001907349,"responseStart":560.8000001907349,"secureConnectionStart":532},{"duration":248.39999961853027,"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":580.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":580.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":828.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":247.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":581.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":581.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":829.1000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":15,"responseStart":180,"responseEnd":185,"domLoading":188,"domInteractive":1025,"domContentLoadedEventStart":1025,"domContentLoadedEventEnd":1070,"domComplete":1336,"loadEventStart":1336,"loadEventEnd":1337,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1004.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1005.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1005.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1006.6999998092651},{"name":"activityTabFullyLoaded","time":1085.6000003814697}],"measures":[],"correlationId":"75f07b22321a96","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":98,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
Could this have been addressed by
MDEV-22929?