1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
set global innodb_encrypt_tables='FORCE';
select @@innodb_encrypt_tables;
@@innodb_encrypt_tables
FORCE
set global innodb_default_encryption_key_id=4;
select @@innodb_default_encryption_key_id;
@@innodb_default_encryption_key_id
1
set global innodb_compression_algorithm=zlib;
select @@innodb_compression_algorithm;
@@innodb_compression_algorithm
zlib
set global innodb_file_format = `Barracuda`;
set global innodb_file_per_table = on;
call mtr.add_suppression("InnoDB: Database page corruption on disk or a failed file read of tablespace test/t1 page \\[page id: space=[0-9]+, page number=[0-9]+\\]. You may have to recover from a backup.");
call mtr.add_suppression("InnoDB: Database page corruption on disk or a failed file read of tablespace test/t2 page \\[page id: space=[0-9]+, page number=[0-9]+\\]. You may have to recover from a backup.");
call mtr.add_suppression("InnoDB: Database page corruption on disk or a failed file read of tablespace test/t3 page \\[page id: space=[0-9]+, page number=[0-9]+\\]. You may have to recover from a backup.");
call mtr.add_suppression("InnoDB: Database page corruption on disk or a failed file read of tablespace test/t4 page \\[page id: space=[0-9]+, page number=[0-9]+\\]. You may have to recover from a backup.");
call mtr.add_suppression("InnoDB: Page \\[page id: space=[0-9]+, page number= [0-9]+\\] in file ./test/t[0-9]+.ibd may be corrupted. Post compression checksum [0-9]+ stored [0-9]+ compression_method [ZLIB|SNAPPY|LZ4|LZO|LZMA|BZIP2]");
call mtr.add_suppression("InnoDB: Background Page read failed to read or decrypt \\[page id: space=[0-9]+, page number=[0-9]+\\]");
call mtr.add_suppression("mysqld: Index for table 't[0-9]+' is corrupt; try to repair it");
create table t0 (c1 int not null auto_increment primary key, b char(200)) engine=innodb;
create table t1 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=1;
create table t2 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=2;
create table t3 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=3;
create table t4 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=4;
create table t5 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=5;
create table t6 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=6;
create table t7 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=7;
create table t8 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=8;
create table t9 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=9;
select count(*) from t1;
count(*)
50
select count(*) from t3;
count(*)
50
select count(*) from t4;
count(*)
50
select count(*) from t5;
count(*)
50
select count(*) from t6;
count(*)
50
select count(*) from t6;
count(*)
50
select count(*) from t7;
count(*)
50
select count(*) from t8;
count(*)
50
select count(*) from t9;
count(*)
50
# t0 expected FOUND
NOT FOUND /AaAaAaAa/ in t0.ibd
# t1 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t1.ibd
# t2 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t2.ibd
# t3 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t3.ibd
# t4 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t4.ibd
# t5 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t5.ibd
# t6 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t6.ibd
# t7 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t7.ibd
# t8 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t8.ibd
# t9 page compressed expected NOT FOUND
NOT FOUND /AaAaAaAa/ in t9.ibd
# Run innochecksum on t9
# Run innochecksum on t8
# Run innochecksum on t7
# Run innochecksum on t6
# Run innochecksum on t5
# Run innochecksum on t4
# Run innochecksum on t3
# Run innochecksum on t2
# Run innochecksum on t1
select count(*) from t0;
count(*)
50
select count(*) from t1;
count(*)
50
select count(*) from t3;
count(*)
50
select count(*) from t4;
count(*)
50
select count(*) from t5;
count(*)
50
select count(*) from t6;
count(*)
50
select count(*) from t7;
count(*)
50
select count(*) from t8;
count(*)
50
select count(*) from t9;
count(*)
50
# Restart server
# Corrupting tablespaces...
# Corruption done
# Run innochecksum on t0
# Run innochecksum on t4
# Run innochecksum on t3
# Run innochecksum on t2
# Start server again
select * from t1;
Got one of the listed errors
select * from t2;
Got one of the listed errors
select * from t3;
Got one of the listed errors
select * from t4;
Got one of the listed errors
select count(*) from t5;
count(*)
50
select count(*) from t6;
count(*)
50
select count(*) from t7;
count(*)
50
select count(*) from t8;
count(*)
50
select count(*) from t9;
count(*)
50
drop table t0, t1, t2, t3, t4, t5, t6, t7, t8, t9;
|
