[MDEV-14200] innodb.innodb-wl5522-debug failed in buildbot with wrong errno Created: 2017-10-29  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: 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


Generated at Thu Feb 08 08:11:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.