call mtr.add_suppression("The file '.*' already exists though the corresponding table did not exist in the InnoDB data dictionary");
call mtr.add_suppression("Cannot create file '.*'");
call mtr.add_suppression("InnoDB: Error number 17 means 'File exists'");
set global innodb_file_per_table = on;
"1. Hit crash point while writing redo log."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine=innodb row_format=compressed
key_block_size=8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_while_writing_redo_log";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"2. Hit crash point on completion of redo log write."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_after_redo_log_write_complete";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"3. Hit crash point while dropping indexes."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_drop_of_clust_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_drop_of_uniq_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_drop_of_sec_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"4. Hit crash point on completing drop of all indexes before creation"
"   of index is commenced."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_drop_reinit_done_create_to_start";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"5. Hit crash point while creating indexes."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_create_of_clust_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_create_of_uniq_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_create_of_sec_index";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"6. Hit crash point after data is updated to system-table and"
"   in-memory dict."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_on_updating_dict_sys_info";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
"7. Hit crash point before/after log checkpoint is done."
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_before_log_removal";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
use test;
set global innodb_file_per_table = 1;
SET innodb_strict_mode=OFF;
create  table t (
i int, f float, c char,
primary key pk(i), unique findex(f), index ck(c))
engine = innodb row_format = compressed
key_block_size = 8;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
set session debug = "+d,ib_trunc_crash_after_truncate_done";
Warnings:
Warning	1287	'@@debug' is deprecated and will be removed in a future release. Please use '@@debug_dbug' instead
truncate table t;
ERROR HY000: Lost connection to server during query
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
select * from t where f < 2.5;
i	f	c
1	1.1	a
2	2.2	b
drop table t;
set global innodb_file_per_table = 1;