drop table if exists tc; create table tc (a int auto_increment not null, b int , primary key (a), key (b)); insert into tc (b) values (1); set debug='d,dict_set_index_corrupted'; CHECK TABLE tc; show variables like "innodb_log_files_in_group"; --source include/shutdown_mysqld.inc --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect BEGIN; insert into tc (b) values (1); ROLLBACK; BEGIN; insert into tc (b) values (1); ROLLBACK; BEGIN; insert into tc (b) values (1); ROLLBACK; BEGIN; insert into tc (b) values (1); ROLLBACK; BEGIN; insert into tc (b) values (1); ROLLBACK; BEGIN; insert into tc (b) values (1); ROLLBACK; SET SESSION debug='d,crash_commit_before'; BEGIN; # Write file to make mysql-test-run.pl start up the server again --exec echo "restart:--innodb_log_files_in_group=16" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect --error CR_SERVER_LOST insert into tc (b) values (1); --enable_reconnect --source include/wait_until_connected_again.inc --disable_reconnect show variables like "innodb_log_files_in_group"; CHECK TABLE tc;