Debian Codegraph @

mysql-test/suite/encryption/t/innochecksum.test

raw
1 #
2 # MDEV-8773: InnoDB innochecksum does not work with encrypted or page compressed tables
3 #
4
5 # Don't test under embedded as we restart server
6 -- source include/not_embedded.inc
7 # Require InnoDB
8 -- source include/have_innodb.inc
9 -- source include/have_file_key_management_plugin.inc
10 -- source include/innodb_page_size_small.inc
11 -- source include/innodb_checksum_algorithm.inc
12 -- source include/maybe_debug.inc
13
14 if (!$INNOCHECKSUM) {
15 --echo Need innochecksum binary
16 --die Need innochecksum binary
17 }
18
19 --disable_query_log
20 # This may be triggered on a slow system or one that lacks native AIO.
21 call mtr.add_suppression("InnoDB: Trying to delete tablespace.*pending operations");
22 if ($have_debug) {
23 SET GLOBAL DEBUG_DBUG='+d,ib_log_checkpoint_avoid_hard';
24 call mtr.add_suppression("InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size");
25 }
26 --enable_query_log
27
28 let $checksum_algorithm = `SELECT @@innodb_checksum_algorithm`;
29 # zlib
30 set global innodb_compression_algorithm = 1;
31
32
33 --echo # Create and populate a tables
34 CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
35 CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
36 CREATE TABLE t3 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=NO;
37 CREATE TABLE t4 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB PAGE_COMPRESSED=1;
38 CREATE TABLE t5 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=YES ENCRYPTION_KEY_ID=4;
39 CREATE TABLE t6 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB;
40
41 --disable_query_log
42 --let $i = 1000
43 begin;
44 while ($i)
45 {
46 INSERT INTO t1 (b) VALUES (REPEAT('abcdefghijklmnopqrstuvwxyz', 100));
47 dec $i;
48 }
49 INSERT INTO t2 SELECT * FROM t1;
50 INSERT INTO t3 SELECT * FROM t1;
51 INSERT INTO t4 SELECT * FROM t1;
52 INSERT INTO t5 SELECT * FROM t1;
53 INSERT INTO t6 SELECT * FROM t1;
54 commit;
55 --enable_query_log
56
57 let $MYSQLD_DATADIR=`select @@datadir`;
58 let t1_IBD = $MYSQLD_DATADIR/test/t1.ibd;
59 let t2_IBD = $MYSQLD_DATADIR/test/t2.ibd;
60 let t3_IBD = $MYSQLD_DATADIR/test/t3.ibd;
61 let t4_IBD = $MYSQLD_DATADIR/test/t4.ibd;
62 let t5_IBD = $MYSQLD_DATADIR/test/t5.ibd;
63 let t6_IBD = $MYSQLD_DATADIR/test/t6.ibd;
64
65 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
66 let MYSQLD_DATADIR=`select @@datadir`;
67
68 --source include/shutdown_mysqld.inc
69
70 -- disable_result_log
71 --echo # Run innochecksum on t1, check -S does not cause crash for encrypted file
72 --exec $INNOCHECKSUM -S $t1_IBD
73
74 --echo # Run innochecksum on t2
75
76 --exec $INNOCHECKSUM $t2_IBD
77
78 --echo # Run innochecksum on t3
79
80 --exec $INNOCHECKSUM $t3_IBD
81
82 --echo # Run innochecksum on t4
83
84 --exec $INNOCHECKSUM $t4_IBD
85
86 --echo # Run innochecksum on t4
87
88 --exec $INNOCHECKSUM $t4_IBD
89
90 --echo # Run innochecksum on t5
91
92 --exec $INNOCHECKSUM $t5_IBD
93
94 --echo # Run innochecksum on t6
95
96 --exec $INNOCHECKSUM $t6_IBD
97
98 --enable_result_log
99
100 --echo # Backup tables before corrupting
101 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd.backup
102 --copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t2.ibd.backup
103 --copy_file $MYSQLD_DATADIR/test/t3.ibd $MYSQLD_DATADIR/test/t3.ibd.backup
104 --copy_file $MYSQLD_DATADIR/test/t4.ibd $MYSQLD_DATADIR/test/t4.ibd.backup
105 --copy_file $MYSQLD_DATADIR/test/t5.ibd $MYSQLD_DATADIR/test/t5.ibd.backup
106 --copy_file $MYSQLD_DATADIR/test/t6.ibd $MYSQLD_DATADIR/test/t6.ibd.backup
107
108 #
109 # MDEV-11939: innochecksum mistakes a file for an encrypted one
110 #
111
112 --echo # Corrupt FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION
113
114 perl;
115 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t1.ibd") or die "open";
116 binmode FILE;
117 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 26, SEEK_SET) or die "seek";
118 print FILE pack("H*", "c00lcafedeadb017");
119 close FILE or die "close";
120 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t2.ibd") or die "open";
121 binmode FILE;
122 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 26, SEEK_SET) or die "seek";
123 print FILE pack("H*", "c00lcafedeadb017");
124 close FILE or die "close";
125 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t3.ibd") or die "open";
126 binmode FILE;
127 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 26, SEEK_SET) or die "seek";
128 print FILE pack("H*", "c00lcafedeadb017");
129 close FILE or die "close";
130 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t6.ibd") or die "open";
131 binmode FILE;
132 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 26, SEEK_SET) or die "seek";
133 print FILE pack("H*", "c00lcafedeadb017");
134 close FILE or die "close";
135 EOF
136
137 -- disable_result_log
138 --error 1
139 --exec $INNOCHECKSUM $t1_IBD
140
141 --echo # Run innochecksum on t2
142
143 --error 1
144 --exec $INNOCHECKSUM $t2_IBD
145
146 --echo # Run innochecksum on t3
147 --echo # no encryption corrupting the field should not have effect
148 --exec $INNOCHECKSUM $t3_IBD
149
150 --echo # Run innochecksum on t6
151 --echo # In new checksum format, checksum calculated for whole page.
152 --echo # So It should affected.
153 let $error_code = 0;
154 if ($checksum_algorithm == "full_crc32")
155 {
156 let $error_code = 1;
157 }
158
159 if ($checksum_algorithm == "strict_full_crc32")
160 {
161 let $error_code = 1;
162 }
163
164 --error $error_code
165 --exec $INNOCHECKSUM $t6_IBD
166
167 --enable_result_log
168
169 --echo # Restore the original tables
170 --remove_file $MYSQLD_DATADIR/test/t1.ibd
171 --remove_file $MYSQLD_DATADIR/test/t2.ibd
172 --remove_file $MYSQLD_DATADIR/test/t3.ibd
173 --remove_file $MYSQLD_DATADIR/test/t4.ibd
174 --remove_file $MYSQLD_DATADIR/test/t5.ibd
175 --remove_file $MYSQLD_DATADIR/test/t6.ibd
176 --copy_file $MYSQLD_DATADIR/test/t1.ibd.backup $MYSQLD_DATADIR/test/t1.ibd
177 --copy_file $MYSQLD_DATADIR/test/t2.ibd.backup $MYSQLD_DATADIR/test/t2.ibd
178 --copy_file $MYSQLD_DATADIR/test/t3.ibd.backup $MYSQLD_DATADIR/test/t3.ibd
179 --copy_file $MYSQLD_DATADIR/test/t4.ibd.backup $MYSQLD_DATADIR/test/t4.ibd
180 --copy_file $MYSQLD_DATADIR/test/t5.ibd.backup $MYSQLD_DATADIR/test/t5.ibd
181 --copy_file $MYSQLD_DATADIR/test/t6.ibd.backup $MYSQLD_DATADIR/test/t6.ibd
182
183 --echo # Corrupt FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION+4 (post encryption checksum)
184
185 perl;
186 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t1.ibd") or die "open";
187 binmode FILE;
188 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 30, SEEK_SET) or die "seek";
189 print FILE pack("H*", "c00lcafedeadb017");
190 close FILE or die "close";
191 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t2.ibd") or die "open";
192 binmode FILE;
193 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 30, SEEK_SET) or die "seek";
194 print FILE pack("H*", "c00lcafedeadb017");
195 close FILE or die "close";
196 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t3.ibd") or die "open";
197 binmode FILE;
198 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 30, SEEK_SET) or die "seek";
199 print FILE pack("H*", "c00lcafedeadb017");
200 close FILE or die "close";
201 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t6.ibd") or die "open";
202 binmode FILE;
203 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 30, SEEK_SET) or die "seek";
204 print FILE pack("H*", "c00lcafedeadb017");
205 close FILE or die "close";
206 EOF
207
208 -- disable_result_log
209 --error 1
210 --exec $INNOCHECKSUM $t1_IBD
211
212 --echo # Run innochecksum on t2
213 --error 1
214 --exec $INNOCHECKSUM $t2_IBD
215
216 --echo # Run innochecksum on t3
217 --error 1
218 --exec $INNOCHECKSUM $t3_IBD
219
220 --echo # Run innochecksum on t6
221 --echo # Space ID mismatch
222 --error 1
223 --exec $INNOCHECKSUM $t6_IBD
224
225 --enable_result_log
226
227 --echo # Restore the original tables
228 --remove_file $MYSQLD_DATADIR/test/t1.ibd
229 --remove_file $MYSQLD_DATADIR/test/t2.ibd
230 --remove_file $MYSQLD_DATADIR/test/t3.ibd
231 --remove_file $MYSQLD_DATADIR/test/t4.ibd
232 --remove_file $MYSQLD_DATADIR/test/t5.ibd
233 --remove_file $MYSQLD_DATADIR/test/t6.ibd
234 --copy_file $MYSQLD_DATADIR/test/t1.ibd.backup $MYSQLD_DATADIR/test/t1.ibd
235 --copy_file $MYSQLD_DATADIR/test/t2.ibd.backup $MYSQLD_DATADIR/test/t2.ibd
236 --copy_file $MYSQLD_DATADIR/test/t3.ibd.backup $MYSQLD_DATADIR/test/t3.ibd
237 --copy_file $MYSQLD_DATADIR/test/t4.ibd.backup $MYSQLD_DATADIR/test/t4.ibd
238 --copy_file $MYSQLD_DATADIR/test/t5.ibd.backup $MYSQLD_DATADIR/test/t5.ibd
239 --copy_file $MYSQLD_DATADIR/test/t6.ibd.backup $MYSQLD_DATADIR/test/t6.ibd
240
241 --echo # Corrupt FIL_DATA+10 (data)
242
243 perl;
244 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t1.ibd") or die "open";
245 binmode FILE;
246 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 48, SEEK_SET) or die "seek";
247 print FILE pack("H*", "c00lcafedeadb017");
248 close FILE or die "close";
249 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t2.ibd") or die "open";
250 binmode FILE;
251 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 48, SEEK_SET) or die "seek";
252 print FILE pack("H*", "c00lcafedeadb017");
253 close FILE or die "close";
254 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t3.ibd") or die "open";
255 binmode FILE;
256 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 48, SEEK_SET) or die "seek";
257 print FILE pack("H*", "c00lcafedeadb017");
258 close FILE or die "close";
259 open(FILE, "+<", "$ENV{MYSQLD_DATADIR}/test/t6.ibd") or die "open";
260 binmode FILE;
261 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * 3 + 48, SEEK_SET) or die "seek";
262 print FILE pack("H*", "c00lcafedeadb017");
263 close FILE or die "close";
264 EOF
265
266 if (0 && $have_debug) { # these messages sometimes fail to appear
267 --let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
268 --let SEARCH_PATTERN= InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size; last checkpoint LSN=\\d+, current LSN=\\d+\\. Shutdown is in progress\\..*InnoDB: Crash recovery was broken.*
269 --echo # FOUND 1 is expected for both.
270 --source include/search_pattern_in_file.inc
271 --let SEARCH_PATTERN= InnoDB: Crash recovery was broken
272 --source include/search_pattern_in_file.inc
273 }
274
275 -- disable_result_log
276 --error 1
277 --exec $INNOCHECKSUM $t1_IBD
278
279 --echo # Run innochecksum on t2
280 --error 1
281 --exec $INNOCHECKSUM $t2_IBD
282
283 --echo # Run innochecksum on t3
284 --error 1
285 --exec $INNOCHECKSUM $t3_IBD
286
287 --echo # Run innochecksum on t6
288 --error 1
289 --exec $INNOCHECKSUM $t6_IBD
290
291 --enable_result_log
292
293 --echo # Restore the original tables
294 --move_file $MYSQLD_DATADIR/test/t1.ibd.backup $MYSQLD_DATADIR/test/t1.ibd
295 --move_file $MYSQLD_DATADIR/test/t2.ibd.backup $MYSQLD_DATADIR/test/t2.ibd
296 --move_file $MYSQLD_DATADIR/test/t3.ibd.backup $MYSQLD_DATADIR/test/t3.ibd
297 --move_file $MYSQLD_DATADIR/test/t4.ibd.backup $MYSQLD_DATADIR/test/t4.ibd
298 --move_file $MYSQLD_DATADIR/test/t5.ibd.backup $MYSQLD_DATADIR/test/t5.ibd
299 --move_file $MYSQLD_DATADIR/test/t6.ibd.backup $MYSQLD_DATADIR/test/t6.ibd
300
301 --source include/start_mysqld.inc
302
303 --echo # Trigger AHI and test pages_hashed, pages_old as non zero from sys view
304
305 SELECT STRAIGHT_JOIN COUNT(t6a.a)
306 FROM t6 AS t6a, t6 AS t6b, t6 AS t6c
307 WHERE t6a.a = t6b.a AND t6c.a = t6a.a;
308
309 let $no_ps=`SELECT count(*)=0 FROM information_schema.engines WHERE
310 (support = 'YES' OR support = 'DEFAULT') AND
311 engine = 'PERFORMANCE_SCHEMA'`;
312
313 if ($no_ps) {
314 --echo SELECT SUM(pages_hashed)>0 `1`, SUM(pages_old)>0 `1`
315 --echo FROM sys.innodb_buffer_stats_by_table;
316 --echo 1 1
317 --echo 1 1
318 }
319 if (!$no_ps) {
320 SELECT SUM(pages_hashed)>0 `1`, SUM(pages_old)>0 `1`
321 FROM sys.innodb_buffer_stats_by_table;
322 }
323
324 DROP TABLE t1, t2, t3, t4, t5, t6;