Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/1323/steps/test_2/logs/stdio
innodb.innodb-wl5522-debug 'innodb' w2 [ fail ]
|
Test ended at 2017-10-18 21:36:38
|
|
CURRENT_TEST: innodb.innodb-wl5522-debug
|
mysqltest: At line 1303: query 'ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE' failed with wrong errno 1815: 'Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Data structure corruption', instead of 1034...
|
|
The result from queries just before the failure was:
|
< snip >
|
unlink: t1.cfg
|
CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
|
ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
|
SELECT COUNT(*) FROM test_wl5522.t1;
|
ERROR HY000: Tablespace has been discarded for table `t1`
|
restore: t1 .ibd and .cfg files
|
SET SESSION debug_dbug="+d,ib_import_trigger_corruption_2";
|
ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
|
ERROR HY000: Index corrupt: Externally stored column(5) has a reference length of 19 in the cluster index GEN_CLUST_INDEX
|
SET SESSION debug_dbug=@saved_debug_dbug;
|
DROP TABLE test_wl5522.t1;
|
unlink: t1.ibd
|
unlink: t1.cfg
|
CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
|
ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
|
SELECT COUNT(*) FROM test_wl5522.t1;
|
ERROR HY000: Tablespace has been discarded for table `t1`
|
restore: t1 .ibd and .cfg files
|
SET SESSION debug_dbug="+d,ib_import_trigger_corruption_3";
|
ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
|
|
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/2/log/innodb-wl5522-debug.log
|
|
- saving '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/2/log/innodb.innodb-wl5522-debug-innodb/' to '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/log/innodb.innodb-wl5522-debug-innodb/'
|
|
Retrying test innodb.innodb-wl5522-debug, attempt(2/3)...
|
|
worker[2] > Restart - not started
|
***Warnings generated in error logs during shutdown after running tests: innodb.innodb-wl5522-debug
|
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: Cannot open datafile for read-only: './test_wl5522/t1.ibd' OS error: 71
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-10-18 21:35:40 3078043968 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-10-18 21:35:40 3078043968 [Warning] InnoDB: Ignoring tablespace for `test_wl5522`.`t1` because it could not be opened.
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: Cannot open datafile for read-only: './test_wl5522/t1.ibd' OS error: 71
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-10-18 21:35:42 2903214912 [ERROR] InnoDB: Table test_wl5522/t1 in the InnoDB data dictionary has tablespace id 4, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?
|
2017-10-18 21:35:45 2963020608 [Warning] InnoDB: Tablespace for table `test_wl5522`.`t1` is set as discarded.
|
2017-10-18 21:35:50 2903214912 [Warning] InnoDB: Tablespace for table `test_wl5522`.`t1` is set as discarded.
|
2017-10-18 21:35:50 2903214912 [ERROR] InnoDB: Page for tablespace 7 is index page with id 24 but that index is not found from configuration file. Current index name GEN_CLUST_INDEX and id 23
|
2017-10-18 21:35:54 2963020608 [Warning] InnoDB: Tablespace for table `test_wl5522`.`t1` is set as discarded.
|
2017-10-18 21:35:57 2963020608 [ERROR] InnoDB: IO Error: while reading index meta-data, expected to read 44 bytes but read only 0 bytes
|
2017-10-18 21:36:05 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:05 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:05 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:05 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:06 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:06 2963020608 [Warning] InnoDB: Monitor ibuf_merges is already enabled.
|
2017-10-18 21:36:06 2963020608 [Warning] InnoDB: Monitor ibuf_merges_insert is already enabled.
|
2017-10-18 21:36:34 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:35 2963020608 [Warning] InnoDB: Page 0 at offset 0 looks corrupted in file ./test_wl5522/t1.ibd
|
2017-10-18 21:36:36 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:37 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|
2017-10-18 21:36:37 2963020608 [Warning] InnoDB: Page 141 at offset 2310144 looks corrupted in file ./test_wl5522/t1.ibd
|
2017-10-18 21:36:38 2963020608 [ERROR] mysqld: Index for table 't1' is corrupt; try to repair it
|