Note: see also MDEV-18203 – different error, otherwise the same.
10.4 4edb29380c980
|
2019-01-18 21:26:44 0 [Note] mysqld: Aria engine: starting recovery
|
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (20.8 seconds); transactions to roll back: 1
|
Got error 121 when executing undo undo_key_delete
|
2019-01-18 21:27:05 0 [ERROR] mysqld: Aria engine: Undo phase failed
|
tables to flush: 8 7 6 5 4 3 2 1 0
|
2019-01-18 21:27:05 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
|
2019-01-18 21:27:05 0 [ERROR] Plugin 'Aria' init function returned error.
|
2019-01-18 21:27:05 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
|
The backup dirs are here:
ftp://ftp.askmonty.org/public/mdev18310
backup_before_prepare_0 is the initial full backup
backup_before_prepare_1 is the 1st incremental backup
backup_before_prepare_2 is the 1st incremental backup
backup_0 is the prepared backup after all prepare were executed on it.
To reproduce the failure, restore backup_0 to the datadir and run the server on it. All server default options are sufficient.
If you have doubts about the correctness of prepare, you can run it on non-prepared backups.
mariabackup logs from all stages are attached with hopefully self-explanatory names (mbackup*.log).
I have no information yet whether it affects previous versions.
Please be aware it's not necessarily reproducible the same way.
https://travis-ci.org/elenst/travis-tests/jobs/481392097
# 2528 22 2
Server: 10.4 4edb29380c98058a28e49c826bacee9c83473579
Tests: elenst-dev 19e81706fbfffc28d2f71d2c22b361ecd4593d9a
Toolbox: c949673e7706f81f5369ecd91b587b09674ece2b
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547846609 --reporters=Backtrace,ErrorLog,Deadlock --skip-gendata --gendata-advanced --views --grammar=conf/mariadb/generic-dml.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=20 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff --engine=Aria --scenario=MariaBackupIncremental
|
The test log is attached as trial.log
{"report":{"fcp":698.7999999523163,"ttfb":160.69999992847443,"pageVisibility":"visible","entityId":72025,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"74c2212b-2c30-4302-ad66-48348a7bb4b6","navigationType":0,"readyForUser":771,"redirectCount":0,"resourceLoadedEnd":797.5999999046326,"resourceLoadedStart":166.39999997615814,"resourceTiming":[{"duration":17.899999976158142,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":166.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":184.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":17.800000071525574,"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":166.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":184.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":71.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":166.69999992847443,"connectEnd":166.69999992847443,"connectStart":166.69999992847443,"domainLookupEnd":166.69999992847443,"domainLookupStart":166.69999992847443,"fetchStart":166.69999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":166.69999992847443,"responseEnd":238.19999992847443,"responseStart":238.19999992847443,"secureConnectionStart":166.69999992847443},{"duration":147.5,"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":166.89999997615814,"connectEnd":166.89999997615814,"connectStart":166.89999997615814,"domainLookupEnd":166.89999997615814,"domainLookupStart":166.89999997615814,"fetchStart":166.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":166.89999997615814,"responseEnd":314.39999997615814,"responseStart":314.39999997615814,"secureConnectionStart":166.89999997615814},{"duration":143.89999997615814,"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":166.89999997615814,"connectEnd":166.89999997615814,"connectStart":166.89999997615814,"domainLookupEnd":166.89999997615814,"domainLookupStart":166.89999997615814,"fetchStart":166.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":166.89999997615814,"responseEnd":310.7999999523163,"responseStart":310.7999999523163,"secureConnectionStart":166.89999997615814},{"duration":148.19999992847443,"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":167,"connectEnd":167,"connectStart":167,"domainLookupEnd":167,"domainLookupStart":167,"fetchStart":167,"redirectEnd":0,"redirectStart":0,"requestStart":167,"responseEnd":315.1999999284744,"responseStart":315.1999999284744,"secureConnectionStart":167},{"duration":148.5,"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":167.09999990463257,"connectEnd":167.09999990463257,"connectStart":167.09999990463257,"domainLookupEnd":167.09999990463257,"domainLookupStart":167.09999990463257,"fetchStart":167.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":167.09999990463257,"responseEnd":315.59999990463257,"responseStart":315.59999990463257,"secureConnectionStart":167.09999990463257},{"duration":148.80000007152557,"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":167.19999992847443,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316,"responseStart":0,"secureConnectionStart":0},{"duration":148.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":167.29999995231628,"connectEnd":167.29999995231628,"connectStart":167.29999995231628,"domainLookupEnd":167.29999995231628,"domainLookupStart":167.29999995231628,"fetchStart":167.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":167.29999995231628,"responseEnd":316,"responseStart":316,"secureConnectionStart":167.29999995231628},{"duration":149.10000002384186,"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":167.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.5,"responseStart":0,"secureConnectionStart":0},{"duration":149.10000002384186,"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":167.59999990463257,"connectEnd":167.59999990463257,"connectStart":167.59999990463257,"domainLookupEnd":167.59999990463257,"domainLookupStart":167.59999990463257,"fetchStart":167.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":167.59999990463257,"responseEnd":316.6999999284744,"responseStart":316.6999999284744,"secureConnectionStart":167.59999990463257},{"duration":419.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":168.29999995231628,"connectEnd":168.29999995231628,"connectStart":168.29999995231628,"domainLookupEnd":168.29999995231628,"domainLookupStart":168.29999995231628,"fetchStart":168.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":168.29999995231628,"responseEnd":587.6999999284744,"responseStart":587.6999999284744,"secureConnectionStart":168.29999995231628},{"duration":436,"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":168.39999997615814,"connectEnd":168.39999997615814,"connectStart":168.39999997615814,"domainLookupEnd":168.39999997615814,"domainLookupStart":168.39999997615814,"fetchStart":168.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":168.39999997615814,"responseEnd":604.3999999761581,"responseStart":604.3999999761581,"secureConnectionStart":168.39999997615814},{"duration":146.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":451.7999999523163,"connectEnd":451.7999999523163,"connectStart":451.7999999523163,"domainLookupEnd":451.7999999523163,"domainLookupStart":451.7999999523163,"fetchStart":451.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":451.7999999523163,"responseEnd":598.2999999523163,"responseStart":598.2999999523163,"secureConnectionStart":451.7999999523163},{"duration":63.10000002384186,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":670.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":670.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":733.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":93,"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":687.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":687.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":780.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":93.39999997615814,"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":688.3999999761581,"connectEnd":688.3999999761581,"connectStart":688.3999999761581,"domainLookupEnd":688.3999999761581,"domainLookupStart":688.3999999761581,"fetchStart":688.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":688.3999999761581,"responseEnd":781.7999999523163,"responseStart":781.7999999523163,"secureConnectionStart":688.3999999761581},{"duration":108.79999995231628,"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":688.7999999523163,"connectEnd":688.7999999523163,"connectStart":688.7999999523163,"domainLookupEnd":688.7999999523163,"domainLookupStart":688.7999999523163,"fetchStart":688.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":688.7999999523163,"responseEnd":797.5999999046326,"responseStart":797.5999999046326,"secureConnectionStart":688.7999999523163}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":11,"responseStart":161,"responseEnd":163,"domLoading":164,"domInteractive":849,"domContentLoadedEventStart":850,"domContentLoadedEventEnd":884,"domComplete":1123,"loadEventStart":1123,"loadEventEnd":1123,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":812.2999999523163},{"name":"bigPipe.sidebar-id.end","time":813},{"name":"bigPipe.activity-panel-pipe-id.start","time":813.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":814.1999999284744},{"name":"activityTabFullyLoaded","time":900.6999999284744}],"measures":[],"correlationId":"409ae9d0a94dd","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":16,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
I checked the file backup_0.tar.gz
The reason Aria recover fails is that there are not all Aria redo files in the backup.
The only files that exists is:
aria_log.00000001 of size 83009536
This is in LSN: 1,0x4f2a000 in the aria_recovery.trace file
The undo fails when trying to revert test/t5.
shell> /my/maria-10.4/storage/maria/aria_chk -dvv test/t5.MAI
Aria file: test/t5.MAI
Record format: Block
Crashsafe: yes
Character set: latin1_swedish_ci (8)
File-version: 3
Creation time: 2019-01-18 23:23:34
Check/recover time: 2019-01-18 23:23:34
LSNs: create_rename (1,0x11b21), state_horizon (1,0x9d669e8), skip_redo (1,0x11b8b)
As can be seen in LSN, the last update to the file was for LSN 1,0x9d669e8, which is bigger than what the aria_log could support.
Vlad, can you please verify that mariabackup copies ALL aria_log files!
I will in the mean time add a warning in recovery if we find a LSN on any page that is bigger than the maximum LSN that recovery can restore.