|
10.4 30da40bb8c303
|
2019-01-10 16:07:43 0 [Note] InnoDB: New log files created, LSN=9813228
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/seq9.ibd' OS error: 71
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2019-01-10 16:07:43 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`seq9``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
Further attempts to open tables cause more errors
MariaDB [(none)]> show create table test.seq9;
|
ERROR 1932 (42S02): Table 'test.seq9' doesn't exist in engine
|
MariaDB [(none)]> show create table test.seq8;
|
ERROR 1932 (42S02): Table 'test.seq8' doesn't exist in engine
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: Failed to find tablespace for table `test`.`seq9` in the cache. Attempting to load the tablespace with space id 649
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: Cannot open datafile for read-only: './test/seq9.ibd' OS error: 71
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2019-01-10 16:16:17 9 [ERROR] InnoDB: Could not find a valid tablespace file for ``test`.`seq9``. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2019-01-10 16:16:20 9 [ERROR] InnoDB: Expected tablespace id 631 but found 649 in the file ./test/seq8.ibd
|
2019-01-10 16:16:20 9 [ERROR] InnoDB: Expected tablespace id 631 but found 649 in the file ./test/seq8.ibd
|
2019-01-10 16:16:20 9 [ERROR] InnoDB: Table `test`.`seq8` is corrupted. Please drop the table and recreate.
|
The backup datadir before prepare is attached, as well as the backup log.
To reproduce, run
bin/mariabackup --prepare --target-dir=`pwd`/backup_before_prepare
|
bin/mariabackup --copy-back --target-dir=`pwd`/backup_before_prepare --datadir=`pwd`/data
|
and start the server. All defaults will do, or for the accuracy you can use --innodb-compression-algorithm=none which the initial server was run with. It doesn't make any difference.
I have no information yet whether it affects earlier versions.
Please note it's not necessarily reproducible this way.
https://travis-ci.org/elenst/travis-tests/jobs/477530220
Tests: elenst-dev 0ebbe452
Toolbox: ece65ed3b78
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=4 --seed=1547092682 --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 --mysqld=--innodb-compression-algorithm=none --innodb-page-size=8K --engine=InnoDB --scenario=MariaBackupFull --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy
|
The test log is attached as trial.log
- relates to
-
MDEV-18185
MariaBackup --prepare fails with InnoDB: Failing assertion: 0 in rename_table_in_prepare
-
-
Closed
There are no comments yet on this issue.
{"report":{"fcp":1591.699999988079,"ttfb":603.1000000238419,"pageVisibility":"visible","entityId":71801,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"e16d898e-52a2-43e8-b8c4-f46162d2540d","navigationType":0,"readyForUser":1682.300000011921,"redirectCount":0,"resourceLoadedEnd":1306.800000011921,"resourceLoadedStart":608.8999999761581,"resourceTiming":[{"duration":420.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":608.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":608.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1029.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":421.5,"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":609.1999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":609.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1030.699999988079,"responseStart":0,"secureConnectionStart":0},{"duration":579.5999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":609.3000000119209,"connectEnd":609.3000000119209,"connectStart":609.3000000119209,"domainLookupEnd":609.3000000119209,"domainLookupStart":609.3000000119209,"fetchStart":609.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":1033.699999988079,"responseEnd":1188.8999999761581,"responseStart":1054.300000011921,"secureConnectionStart":609.3000000119209},{"duration":697.3000000119209,"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":609.5,"connectEnd":609.5,"connectStart":609.5,"domainLookupEnd":609.5,"domainLookupStart":609.5,"fetchStart":609.5,"redirectEnd":0,"redirectStart":0,"requestStart":1033.8999999761581,"responseEnd":1306.800000011921,"responseStart":1056,"secureConnectionStart":609.5},{"duration":448.69999998807907,"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":609.6999999880791,"connectEnd":609.6999999880791,"connectStart":609.6999999880791,"domainLookupEnd":609.6999999880791,"domainLookupStart":609.6999999880791,"fetchStart":609.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":1034.5,"responseEnd":1058.3999999761581,"responseStart":1057.199999988079,"secureConnectionStart":609.6999999880791},{"duration":453.2000000476837,"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":609.8999999761581,"connectEnd":609.8999999761581,"connectStart":609.8999999761581,"domainLookupEnd":609.8999999761581,"domainLookupStart":609.8999999761581,"fetchStart":609.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1035.5,"responseEnd":1063.1000000238419,"responseStart":1061.3999999761581,"secureConnectionStart":609.8999999761581},{"duration":460.69999998807907,"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":610.1000000238419,"connectEnd":610.1000000238419,"connectStart":610.1000000238419,"domainLookupEnd":610.1000000238419,"domainLookupStart":610.1000000238419,"fetchStart":610.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1036.800000011921,"responseEnd":1070.800000011921,"responseStart":1067.6000000238419,"secureConnectionStart":610.1000000238419},{"duration":425,"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":610.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":610.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1035.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":460.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":610.5,"connectEnd":610.5,"connectStart":610.5,"domainLookupEnd":610.5,"domainLookupStart":610.5,"fetchStart":610.5,"redirectEnd":0,"redirectStart":0,"requestStart":1038.699999988079,"responseEnd":1071,"responseStart":1068.300000011921,"secureConnectionStart":610.5},{"duration":426.5,"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":610.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":610.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1037.199999988079,"responseStart":0,"secureConnectionStart":0},{"duration":459.30000001192093,"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":610.8000000119209,"connectEnd":610.8000000119209,"connectStart":610.8000000119209,"domainLookupEnd":610.8000000119209,"domainLookupStart":610.8000000119209,"fetchStart":610.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":1040.800000011921,"responseEnd":1070.1000000238419,"responseStart":1065.5,"secureConnectionStart":610.8000000119209},{"duration":662.0999999642372,"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":611.8000000119209,"connectEnd":611.8000000119209,"connectStart":611.8000000119209,"domainLookupEnd":611.8000000119209,"domainLookupStart":611.8000000119209,"fetchStart":611.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":1262.6000000238419,"responseEnd":1273.8999999761581,"responseStart":1273.300000011921,"secureConnectionStart":611.8000000119209},{"duration":663.7000000476837,"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":611.8999999761581,"connectEnd":611.8999999761581,"connectStart":611.8999999761581,"domainLookupEnd":611.8999999761581,"domainLookupStart":611.8999999761581,"fetchStart":611.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1263,"responseEnd":1275.6000000238419,"responseStart":1274.3999999761581,"secureConnectionStart":611.8999999761581},{"duration":125.19999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1317.5,"connectEnd":1317.5,"connectStart":1317.5,"domainLookupEnd":1317.5,"domainLookupStart":1317.5,"fetchStart":1317.5,"redirectEnd":0,"redirectStart":0,"requestStart":1412.199999988079,"responseEnd":1442.699999988079,"responseStart":1441.6000000238419,"secureConnectionStart":1317.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":343,"responseStart":603,"responseEnd":606,"domLoading":606,"domInteractive":1778,"domContentLoadedEventStart":1778,"domContentLoadedEventEnd":1828,"domComplete":2497,"loadEventStart":2497,"loadEventEnd":2497,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1760.3999999761581},{"name":"bigPipe.sidebar-id.end","time":1761.199999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":1761.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":1761.8999999761581},{"name":"activityTabFullyLoaded","time":1842.5}],"measures":[],"correlationId":"3c8a0e69c98526","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":167,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
