Debian Codegraph @

mysql-test/suite/innodb/r/ddl_crash_basic.result

raw
1 SET SESSION debug= '+d,skip_dd_table_access_check';
2 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
3 Expected as 0
4 0
5 # Test create table crash/recovery rollback.
6 set global innodb_ddl_log_crash_reset_debug = 1;
7 set session debug = '+d, ddl_log_crash_after_free_tree_log_2';
8 CREATE TABLE t1 (a INT, b INT, c INT, key(a), key(b));
9 show create table t1;
10 ERROR 42S02: Table 'test.t1' doesn't exist
11 SET SESSION debug= '+d,skip_dd_table_access_check';
12 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
13 Expected as 0
14 0
15 # Test create table crash/recovery.
16 set global innodb_ddl_log_crash_reset_debug = 1;
17 set session debug = '+d, ddl_log_before_post_ddl';
18 CREATE TABLE t1 (a INT, b INT, c INT, key(a), key(b));
19 show create table t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `a` int DEFAULT NULL,
23 `b` int DEFAULT NULL,
24 `c` int DEFAULT NULL,
25 KEY `a` (`a`),
26 KEY `b` (`b`)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 SET SESSION debug= '+d,skip_dd_table_access_check';
29 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
30 Expected as 0
31 0
32 # Test drop table crash/recovery rollback.
33 set global innodb_ddl_log_crash_reset_debug = 1;
34 set session debug = '+d, ddl_log_crash_before_drop_log_1';
35 drop table t1;
36 show create table t1;
37 Table Create Table
38 t1 CREATE TABLE `t1` (
39 `a` int DEFAULT NULL,
40 `b` int DEFAULT NULL,
41 `c` int DEFAULT NULL,
42 KEY `a` (`a`),
43 KEY `b` (`b`)
44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
45 SET SESSION debug= '+d,skip_dd_table_access_check';
46 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
47 Expected as 0
48 0
49 # Test drop table crash/recovery.
50 set global innodb_ddl_log_crash_reset_debug = 1;
51 set session debug = '+d, ddl_log_before_post_ddl';
52 drop table t1;
53 show create table t1;
54 ERROR 42S02: Table 'test.t1' doesn't exist
55 SET SESSION debug= '+d,skip_dd_table_access_check';
56 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
57 Expected as 0
58 0
59 # Test rename table crash/recovery rollback 1.
60 set global innodb_ddl_log_crash_reset_debug = 1;
61 CREATE TABLE t1 (a INT, b INT, c INT, key(a), key(b));
62 set session debug = '+d, ddl_log_crash_before_rename_space_log_1';
63 rename table t1 to t2;
64 show create table t1;
65 Table Create Table
66 t1 CREATE TABLE `t1` (
67 `a` int DEFAULT NULL,
68 `b` int DEFAULT NULL,
69 `c` int DEFAULT NULL,
70 KEY `a` (`a`),
71 KEY `b` (`b`)
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
73 show create table t2;
74 ERROR 42S02: Table 'test.t2' doesn't exist
75 SET SESSION debug= '+d,skip_dd_table_access_check';
76 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
77 Expected as 0
78 0
79 # Test rename table crash/recovery rollback 2.
80 set global innodb_ddl_log_crash_reset_debug = 1;
81 set session debug = '+d, ddl_log_crash_after_rename_space_log_1';
82 rename table t1 to t2;
83 show create table t1;
84 Table Create Table
85 t1 CREATE TABLE `t1` (
86 `a` int DEFAULT NULL,
87 `b` int DEFAULT NULL,
88 `c` int DEFAULT NULL,
89 KEY `a` (`a`),
90 KEY `b` (`b`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
92 show create table t2;
93 ERROR 42S02: Table 'test.t2' doesn't exist
94 SET SESSION debug= '+d,skip_dd_table_access_check';
95 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
96 Expected as 0
97 0
98 # Test rename table crash/recovery.
99 set global innodb_ddl_log_crash_reset_debug = 1;
100 set session debug = '+d, ddl_log_before_post_ddl';
101 rename table t1 to t2;
102 show create table t1;
103 ERROR 42S02: Table 'test.t1' doesn't exist
104 show create table t2;
105 Table Create Table
106 t2 CREATE TABLE `t2` (
107 `a` int DEFAULT NULL,
108 `b` int DEFAULT NULL,
109 `c` int DEFAULT NULL,
110 KEY `a` (`a`),
111 KEY `b` (`b`)
112 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
113 SET SESSION debug= '+d,skip_dd_table_access_check';
114 SELECT count(*) AS `Expected as 0` FROM mysql.innodb_ddl_log;
115 Expected as 0
116 0
117 drop table t2;
118 # Test truncate table crash/recovery.
119 CREATE TABLE t1
120 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
121 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
122 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
123 TRUNCATE TABLE t1;
124 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
125 DROP TABLE t1;
126 CREATE TABLE t1
127 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
128 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
129 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
130 TRUNCATE TABLE t1;
131 # No such crash injection, statement did not crash, cleaning up
132 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
133 DROP TABLE t1;
134 CREATE TABLE t1
135 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
136 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
137 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
138 TRUNCATE TABLE t1;
139 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
140 DROP TABLE t1;
141 CREATE TABLE t1
142 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
143 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
144 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
145 TRUNCATE TABLE t1;
146 # No such crash injection, statement did not crash, cleaning up
147 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
148 DROP TABLE t1;
149 CREATE TABLE t1
150 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
151 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
152 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
153 TRUNCATE TABLE t1;
154 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
155 DROP TABLE t1;
156 CREATE TABLE t1
157 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
158 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
159 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
160 TRUNCATE TABLE t1;
161 # No such crash injection, statement did not crash, cleaning up
162 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
163 DROP TABLE t1;
164 CREATE TABLE t1
165 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
166 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
167 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
168 TRUNCATE TABLE t1;
169 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
170 DROP TABLE t1;
171 CREATE TABLE t1
172 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
173 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
174 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
175 TRUNCATE TABLE t1;
176 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
177 DROP TABLE t1;
178 CREATE TABLE t1
179 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
180 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
181 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
182 TRUNCATE TABLE t1;
183 # No such crash injection, statement did not crash, cleaning up
184 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
185 DROP TABLE t1;
186 CREATE TABLE t1
187 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
188 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
189 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
190 TRUNCATE TABLE t1;
191 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
192 DROP TABLE t1;
193 CREATE TABLE t1
194 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
195 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
196 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
197 TRUNCATE TABLE t1;
198 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
199 DROP TABLE t1;
200 CREATE TABLE t1
201 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
202 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
203 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
204 TRUNCATE TABLE t1;
205 # No such crash injection, statement did not crash, cleaning up
206 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
207 DROP TABLE t1;
208 CREATE TABLE t1
209 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
210 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
211 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
212 TRUNCATE TABLE t1;
213 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
214 DROP TABLE t1;
215 CREATE TABLE t1
216 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
217 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
218 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
219 TRUNCATE TABLE t1;
220 # No such crash injection, statement did not crash, cleaning up
221 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
222 DROP TABLE t1;
223 CREATE TABLE t1
224 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
225 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
226 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
227 TRUNCATE TABLE t1;
228 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
229 DROP TABLE t1;
230 CREATE TABLE t1
231 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
232 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
233 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
234 TRUNCATE TABLE t1;
235 # No such crash injection, statement did not crash, cleaning up
236 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
237 DROP TABLE t1;
238 CREATE TABLE t1
239 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
240 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
241 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
242 TRUNCATE TABLE t1;
243 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
244 DROP TABLE t1;
245 CREATE TABLE t1
246 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
247 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
248 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
249 TRUNCATE TABLE t1;
250 # No such crash injection, statement did not crash, cleaning up
251 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
252 DROP TABLE t1;
253 CREATE TABLE t1
254 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
255 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
256 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
257 TRUNCATE TABLE t1;
258 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
259 DROP TABLE t1;
260 CREATE TABLE t1
261 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
262 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
263 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
264 TRUNCATE TABLE t1;
265 # No such crash injection, statement did not crash, cleaning up
266 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
267 DROP TABLE t1;
268 CREATE TABLE t1
269 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
270 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
271 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_1';
272 TRUNCATE TABLE t1;
273 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_1';
274 DROP TABLE t1;
275 CREATE TABLE t1
276 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
277 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
278 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_2';
279 TRUNCATE TABLE t1;
280 # No such crash injection, statement did not crash, cleaning up
281 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_2';
282 DROP TABLE t1;
283 CREATE TABLE t1
284 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
285 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
286 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
287 TRUNCATE TABLE t1;
288 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
289 DROP TABLE t1;
290 CREATE TABLE t1
291 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
292 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
293 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
294 TRUNCATE TABLE t1;
295 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
296 DROP TABLE t1;
297 CREATE TABLE t1
298 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
299 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
300 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
301 TRUNCATE TABLE t1;
302 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
303 DROP TABLE t1;
304 CREATE TABLE t1
305 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
306 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
307 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
308 TRUNCATE TABLE t1;
309 # No such crash injection, statement did not crash, cleaning up
310 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
311 DROP TABLE t1;
312 # Test optimize table crash/recovery.
313 CREATE TABLE t1
314 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
315 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
316 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
317 OPTIMIZE TABLE t1;
318 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
319 DROP TABLE t1;
320 CREATE TABLE t1
321 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
322 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
323 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
324 OPTIMIZE TABLE t1;
325 Table Op Msg_type Msg_text
326 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
327 test.t1 optimize status OK
328 # No such crash injection, statement did not crash, cleaning up
329 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
330 DROP TABLE t1;
331 CREATE TABLE t1
332 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
333 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
334 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
335 OPTIMIZE TABLE t1;
336 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
337 DROP TABLE t1;
338 CREATE TABLE t1
339 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
340 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
341 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
342 OPTIMIZE TABLE t1;
343 Table Op Msg_type Msg_text
344 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
345 test.t1 optimize status OK
346 # No such crash injection, statement did not crash, cleaning up
347 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
348 DROP TABLE t1;
349 CREATE TABLE t1
350 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
351 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
352 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
353 OPTIMIZE TABLE t1;
354 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
355 DROP TABLE t1;
356 CREATE TABLE t1
357 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
358 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
359 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
360 OPTIMIZE TABLE t1;
361 Table Op Msg_type Msg_text
362 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
363 test.t1 optimize status OK
364 # No such crash injection, statement did not crash, cleaning up
365 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
366 DROP TABLE t1;
367 CREATE TABLE t1
368 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
369 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
370 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
371 OPTIMIZE TABLE t1;
372 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
373 DROP TABLE t1;
374 CREATE TABLE t1
375 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
376 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
377 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
378 OPTIMIZE TABLE t1;
379 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
380 DROP TABLE t1;
381 CREATE TABLE t1
382 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
383 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
384 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
385 OPTIMIZE TABLE t1;
386 Table Op Msg_type Msg_text
387 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
388 test.t1 optimize status OK
389 # No such crash injection, statement did not crash, cleaning up
390 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
391 DROP TABLE t1;
392 CREATE TABLE t1
393 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
394 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
395 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
396 OPTIMIZE TABLE t1;
397 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
398 DROP TABLE t1;
399 CREATE TABLE t1
400 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
401 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
402 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
403 OPTIMIZE TABLE t1;
404 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
405 DROP TABLE t1;
406 CREATE TABLE t1
407 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
408 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
409 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
410 OPTIMIZE TABLE t1;
411 Table Op Msg_type Msg_text
412 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
413 test.t1 optimize status OK
414 # No such crash injection, statement did not crash, cleaning up
415 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
416 DROP TABLE t1;
417 CREATE TABLE t1
418 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
419 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
420 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
421 OPTIMIZE TABLE t1;
422 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
423 DROP TABLE t1;
424 CREATE TABLE t1
425 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
426 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
427 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
428 OPTIMIZE TABLE t1;
429 Table Op Msg_type Msg_text
430 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
431 test.t1 optimize status OK
432 # No such crash injection, statement did not crash, cleaning up
433 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
434 DROP TABLE t1;
435 CREATE TABLE t1
436 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
437 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
438 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
439 OPTIMIZE TABLE t1;
440 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
441 DROP TABLE t1;
442 CREATE TABLE t1
443 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
444 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
445 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
446 OPTIMIZE TABLE t1;
447 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
448 DROP TABLE t1;
449 CREATE TABLE t1
450 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
451 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
452 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
453 OPTIMIZE TABLE t1;
454 Table Op Msg_type Msg_text
455 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
456 test.t1 optimize status OK
457 # No such crash injection, statement did not crash, cleaning up
458 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
459 DROP TABLE t1;
460 CREATE TABLE t1
461 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
462 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
463 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
464 OPTIMIZE TABLE t1;
465 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
466 DROP TABLE t1;
467 CREATE TABLE t1
468 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
469 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
470 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
471 OPTIMIZE TABLE t1;
472 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
473 DROP TABLE t1;
474 CREATE TABLE t1
475 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
476 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
477 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
478 OPTIMIZE TABLE t1;
479 Table Op Msg_type Msg_text
480 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
481 test.t1 optimize status OK
482 # No such crash injection, statement did not crash, cleaning up
483 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
484 DROP TABLE t1;
485 CREATE TABLE t1
486 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
487 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
488 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
489 OPTIMIZE TABLE t1;
490 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
491 DROP TABLE t1;
492 CREATE TABLE t1
493 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
494 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
495 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
496 OPTIMIZE TABLE t1;
497 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
498 DROP TABLE t1;
499 CREATE TABLE t1
500 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
501 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
502 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
503 OPTIMIZE TABLE t1;
504 Table Op Msg_type Msg_text
505 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
506 test.t1 optimize status OK
507 # No such crash injection, statement did not crash, cleaning up
508 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
509 DROP TABLE t1;
510 CREATE TABLE t1
511 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
512 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
513 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_1';
514 OPTIMIZE TABLE t1;
515 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_1';
516 DROP TABLE t1;
517 CREATE TABLE t1
518 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
519 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
520 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_2';
521 OPTIMIZE TABLE t1;
522 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_2';
523 DROP TABLE t1;
524 CREATE TABLE t1
525 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
526 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
527 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_3';
528 OPTIMIZE TABLE t1;
529 Table Op Msg_type Msg_text
530 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
531 test.t1 optimize status OK
532 # No such crash injection, statement did not crash, cleaning up
533 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_3';
534 DROP TABLE t1;
535 CREATE TABLE t1
536 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
537 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
538 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
539 OPTIMIZE TABLE t1;
540 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
541 DROP TABLE t1;
542 CREATE TABLE t1
543 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
544 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
545 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
546 OPTIMIZE TABLE t1;
547 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
548 DROP TABLE t1;
549 CREATE TABLE t1
550 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
551 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
552 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
553 OPTIMIZE TABLE t1;
554 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
555 DROP TABLE t1;
556 CREATE TABLE t1
557 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
558 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
559 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
560 OPTIMIZE TABLE t1;
561 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
562 DROP TABLE t1;
563 CREATE TABLE t1
564 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
565 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
566 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
567 OPTIMIZE TABLE t1;
568 Table Op Msg_type Msg_text
569 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
570 test.t1 optimize status OK
571 # No such crash injection, statement did not crash, cleaning up
572 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
573 DROP TABLE t1;
574 SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;
575 #
576 # Bug#26832347 - INNODB: CANNOT FIND SPACE FOR TBS_.*_RENAME IN TABLESPACE MEMO
577 #
578 SHOW VARIABLES LIKE 'log_bin';
579 Variable_name Value
580 log_bin ON
581 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
582 SET DEBUG='+d, ib_trx_commit_crash_rseg_updated';
583 ALTER TABLESPACE ts1 RENAME TO ts1_renamed;
584 ERROR HY000: Lost connection to MySQL server during query
585 # restart
586 ALTER TABLESPACE ts1_renamed RENAME TO ts1;
587 DROP TABLESPACE ts1;