Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/bld-starfs-debug/builds/293/steps/test_1/logs/stdio
innodb.group_commit_crash 'innodb' w2 [ fail ]
|
Test ended at 2017-09-30 20:52:50
|
|
|
CURRENT_TEST: innodb.group_commit_crash
|
mysqltest: At line 74: query 'SELECT * FROM t1 ORDER BY id' failed: 1286: Unknown storage engine 'InnoDB'
|
|
|
The result from queries just before the failure was:
|
< snip >
|
SET binlog_format= mixed;
|
RESET MASTER;
|
START TRANSACTION;
|
insert into t1 select * from t2;
|
call setcrash(5);
|
COMMIT;
|
Got one of the listed errors
|
SELECT * FROM t1 ORDER BY id;
|
a b c d id
|
SHOW BINLOG EVENTS LIMIT 4,1;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
delete from t1;
|
SET binlog_format= mixed;
|
RESET MASTER;
|
START TRANSACTION;
|
insert into t1 select * from t2;
|
call setcrash(4);
|
COMMIT;
|
Got one of the listed errors
|
SELECT * FROM t1 ORDER BY id;
|
|
|
More results from queries before failure can be found in /opt/buildbot-slave/mariadb/starfsmenn1/build/mysql-test/var/2/log/group_commit_crash.log
|
|
|
- skipping '/opt/buildbot-slave/mariadb/starfsmenn1/build/mysql-test/var/2/log/innodb.group_commit_crash-innodb/'
|
|
|
Retrying test innodb.group_commit_crash, attempt(2/3)...
|
|
|
worker[2] > Restart - not started
|
***Warnings generated in error logs during shutdown after running tests: innodb.group_commit_crash
|
|
|
2017-09-30 20:52:49 140315928561536 [ERROR] InnoDB: Checksum mismatch in datafile: ./test/t2.ibd, Space ID:5, Flags: 33. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-09-30 20:52:49 140315928561536 [ERROR] InnoDB: Datafile './test/t2.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.
|
2017-09-30 20:52:49 140315928561536 [ERROR] InnoDB: Tablespace 5 was not found at ./test/t2.ibd.
|
2017-09-30 20:52:49 140315928561536 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
|
2017-09-30 20:52:49 140315928561536 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2229] with error Tablespace not found
|
2017-09-30 20:52:50 140315928561536 [ERROR] Plugin 'InnoDB' init function returned error.
|
2017-09-30 20:52:50 140315928561536 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|