[MDEV-14191] innodb.group_commit_crash failed in buildbot with "Unknown storage engine 'InnoDB'" 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/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.


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