Debian Codegraph @

mysql-test/suite/innodb/t/innodb-wl5522-debug.test

raw
1 # mysql-test-run.pl --embedded cannot restart the server.
2 --source include/not_embedded.inc
3
4 # Adding big test option for this test.
5 --source include/big_test.inc
6
7 # This test case needs to crash the server. Needs a debug server.
8 --source include/have_debug.inc
9
10 # Don't test this under valgrind, memory leaks will occur.
11 --source include/not_valgrind.inc
12
13 # Avoid CrashReporter popup on Mac
14 --source include/not_crashrep.inc
15
16 --source include/have_innodb.inc
17 --source include/default_charset.inc
18 --source include/have_sequence.inc
19
20 let $restart_noprint=2;
21 call mtr.add_suppression("InnoDB: Operating system error number .* in a file operation.");
22 call mtr.add_suppression("InnoDB: Error number \\d+ means");
23 call mtr.add_suppression("InnoDB: Cannot open datafile for read-only: .*");
24 call mtr.add_suppression("InnoDB: Ignoring tablespace .* because it could not be opened.");
25 call mtr.add_suppression("InnoDB: Tablespace for table .* is set as discarded.");
26 call mtr.add_suppression("InnoDB: Cannot calculate statistics for table .*");
27 call mtr.add_suppression("InnoDB: Page 0 at offset 0 looks corrupted in file");
28 call mtr.add_suppression("InnoDB: Page for tablespace ");
29 call mtr.add_suppression("InnoDB: Invalid FSP_SPACE_FLAGS=");
30 call mtr.add_suppression("InnoDB: Unknown index id .* on page");
31 call mtr.add_suppression("InnoDB: Cannot save statistics for table `test`\\.`t1` because the \\.ibd file is missing");
32 call mtr.add_suppression("InnoDB: Failed to read page \\d+ from file '.*test/t1\\.ibd'");
33 call mtr.add_suppression("InnoDB: File '.*(ibdata1|t1\\.ibd)' is corrupted");
34 FLUSH TABLES;
35
36 let MYSQLD_DATADIR =`SELECT @@datadir`;
37 let $strerrfix=/ (\(.+\))//;
38
39 CREATE TABLE t1 (c1 INT) ENGINE = InnoDB;
40 INSERT INTO t1 VALUES(1),(2),(3);
41
42 --let $_expect_file_name= `select regexp_replace(@@tmpdir, '^.*/','')`
43 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/$_expect_file_name.expect
44
45 --write_line wait $_expect_file_name
46 SET SESSION debug_dbug="+d,ib_discard_before_commit_crash";
47 --error 2013
48 ALTER TABLE t1 DISCARD TABLESPACE;
49
50 --source include/start_mysqld.inc
51
52 DROP TABLE t1;
53
54 CREATE TABLE t1 (c1 INT) ENGINE = InnoDB;
55 INSERT INTO t1 VALUES(1),(2),(3);
56
57 --write_line wait $_expect_file_name
58 SET SESSION debug_dbug="+d,ib_discard_after_commit_crash";
59 --error 2013
60 ALTER TABLE t1 DISCARD TABLESPACE;
61
62 --source include/start_mysqld.inc
63
64 DROP TABLE t1;
65
66 # Create the table that we will use for crash recovery (during IMPORT)
67 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
68 INSERT INTO t1 VALUES (1), (2), (3), (4);
69
70 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
71
72 FLUSH TABLES t1 FOR EXPORT;
73
74 perl;
75 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
76 ib_backup_tablespaces("test", "t1");
77 EOF
78 UNLOCK TABLES;
79
80 DROP TABLE t1;
81
82 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
83 INSERT INTO t1 VALUES (1);
84
85 ALTER TABLE t1 DISCARD TABLESPACE;
86
87 --error ER_TABLESPACE_DISCARDED
88 SELECT COUNT(*) FROM t1;
89
90 # Restore files
91 perl;
92 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
93 ib_restore_tablespaces("test", "t1");
94 EOF
95
96 --error ER_TABLESPACE_DISCARDED
97 SELECT * FROM t1;
98
99 --write_line wait $_expect_file_name
100 SET SESSION debug_dbug="+d,ib_import_before_commit_crash";
101 --error 2013
102 ALTER TABLE t1 IMPORT TABLESPACE;
103
104 --source include/start_mysqld.inc
105
106 # Check that the DD is consistent after recovery
107
108 --error ER_TABLESPACE_DISCARDED
109 SELECT COUNT(*) FROM t1;
110
111 --exec echo wait > $_expect_file_name
112 SET SESSION debug_dbug="+d,ib_import_before_checkpoint_crash";
113 --error 2013
114 ALTER TABLE t1 IMPORT TABLESPACE;
115
116 # After the above test the results are non-deterministic,
117 # delete the old tablespace files and drop the table,
118 # recreate the table and do a proper import.
119 perl;
120 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
121 ib_unlink_tablespace("test", "t1");
122 EOF
123
124 --source include/start_mysqld.inc
125
126 DROP TABLE t1;
127
128 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
129
130 ALTER TABLE t1 DISCARD TABLESPACE;
131
132 perl;
133 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
134 ib_restore_tablespaces("test", "t1");
135 EOF
136
137 ALTER TABLE t1 IMPORT TABLESPACE;
138 CHECK TABLE t1;
139
140 SELECT COUNT(*) FROM t1;
141
142 INSERT INTO t1 VALUES(400), (500), (600);
143
144 SELECT * FROM t1;
145
146 DROP TABLE t1;
147
148 # Test IO Write error(s), flush tables doesn't return an error message
149 # so we have to make do with the error/warning pushed by the server
150 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
151 INSERT INTO t1 VALUES (1);
152
153 SET @saved_debug_dbug = @@SESSION.debug_dbug;
154 SET SESSION debug_dbug="+d,ib_export_io_write_failure_1";
155
156 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
157
158 FLUSH TABLES t1 FOR EXPORT;
159
160 UNLOCK TABLES;
161
162 SET SESSION debug_dbug=@saved_debug_dbug;
163
164 DROP TABLE t1;
165
166
167 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
168 INSERT INTO t1 VALUES (1);
169
170 SET SESSION debug_dbug="+d,ib_export_io_write_failure_2";
171
172 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
173
174 FLUSH TABLES t1 FOR EXPORT;
175
176 UNLOCK TABLES;
177
178 SET SESSION debug_dbug=@saved_debug_dbug;
179
180 DROP TABLE t1;
181
182 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
183 INSERT INTO t1 VALUES (1);
184
185 SET SESSION debug_dbug="+d,ib_export_io_write_failure_3";
186
187 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
188
189 FLUSH TABLES t1 FOR EXPORT;
190
191 UNLOCK TABLES;
192
193 SET SESSION debug_dbug=@saved_debug_dbug;
194
195 DROP TABLE t1;
196
197 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
198 INSERT INTO t1 VALUES (1);
199
200 SET SESSION debug_dbug="+d,ib_export_io_write_failure_4";
201
202 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
203
204 FLUSH TABLES t1 FOR EXPORT;
205
206 UNLOCK TABLES;
207
208 SET SESSION debug_dbug=@saved_debug_dbug;
209
210 DROP TABLE t1;
211
212 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
213 INSERT INTO t1 VALUES (1);
214
215 SET SESSION debug_dbug="+d,ib_export_io_write_failure_5";
216
217 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
218
219 FLUSH TABLES t1 FOR EXPORT;
220
221 UNLOCK TABLES;
222
223 SET SESSION debug_dbug=@saved_debug_dbug;
224
225 DROP TABLE t1;
226
227
228 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
229 INSERT INTO t1 VALUES (1);
230
231 SET SESSION debug_dbug="+d,ib_export_io_write_failure_6";
232
233 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
234
235 FLUSH TABLES t1 FOR EXPORT;
236
237 UNLOCK TABLES;
238
239 SET SESSION debug_dbug=@saved_debug_dbug;
240
241 DROP TABLE t1;
242
243
244 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
245 INSERT INTO t1 VALUES (1);
246
247 SET SESSION debug_dbug="+d,ib_export_io_write_failure_7";
248
249 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
250
251 FLUSH TABLES t1 FOR EXPORT;
252
253 UNLOCK TABLES;
254
255 SET SESSION debug_dbug=@saved_debug_dbug;
256
257 DROP TABLE t1;
258
259
260 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
261 INSERT INTO t1 VALUES (1);
262
263 SET SESSION debug_dbug="+d,ib_export_io_write_failure_8";
264
265 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
266
267 FLUSH TABLES t1 FOR EXPORT;
268
269 UNLOCK TABLES;
270
271 SET SESSION debug_dbug=@saved_debug_dbug;
272
273 DROP TABLE t1;
274
275 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
276 INSERT INTO t1 VALUES (1);
277
278 SET SESSION debug_dbug="+d,ib_export_io_write_failure_10";
279
280 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
281
282 FLUSH TABLES t1 FOR EXPORT;
283
284 UNLOCK TABLES;
285
286 SET SESSION debug_dbug=@saved_debug_dbug;
287
288 DROP TABLE t1;
289
290
291 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
292 INSERT INTO t1 VALUES (1);
293
294 SET SESSION debug_dbug="+d,ib_export_io_write_failure_11";
295
296 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
297
298 FLUSH TABLES t1 FOR EXPORT;
299
300 UNLOCK TABLES;
301
302 SET SESSION debug_dbug=@saved_debug_dbug;
303
304 DROP TABLE t1;
305
306
307 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
308 INSERT INTO t1 VALUES (1);
309
310 SET SESSION debug_dbug="+d,ib_export_io_write_failure_12";
311
312 --replace_regex /, .*\).*t1.cfg/, Bad file descriptor) t1.cfg/
313
314 FLUSH TABLES t1 FOR EXPORT;
315
316 UNLOCK TABLES;
317
318 SET SESSION debug_dbug=@saved_debug_dbug;
319
320 DROP TABLE t1;
321
322 # Create a table and save the tablespace and .cfg file
323 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
324 INSERT INTO t1 VALUES (100), (200), (300);
325 SELECT COUNT(*) FROM t1;
326 FLUSH TABLES t1 FOR EXPORT;
327
328 perl;
329 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
330 ib_backup_tablespaces("test", "t1");
331 EOF
332
333 UNLOCK TABLES;
334
335 DROP TABLE t1;
336
337 # Test IO Read error(s)
338 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
339 INSERT INTO t1 VALUES (1);
340
341 ALTER TABLE t1 DISCARD TABLESPACE;
342
343 --error ER_TABLESPACE_DISCARDED
344 SELECT COUNT(*) FROM t1;
345
346 SET SESSION debug_dbug="+d,ib_import_io_read_error_1";
347
348 perl;
349 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
350 ib_restore_cfg_files("test", "t1");
351 EOF
352
353 --replace_regex $strerrfix
354
355 --error ER_IO_READ_ERROR
356 ALTER TABLE t1 IMPORT TABLESPACE;
357
358 SET SESSION debug_dbug=@saved_debug_dbug;
359
360 DROP TABLE t1;
361
362 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
363 INSERT INTO t1 VALUES (1);
364
365 ALTER TABLE t1 DISCARD TABLESPACE;
366
367 --error ER_TABLESPACE_DISCARDED
368 SELECT COUNT(*) FROM t1;
369
370 SET SESSION debug_dbug="+d,ib_import_io_read_error_2";
371
372 perl;
373 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
374 ib_restore_cfg_files("test", "t1");
375 EOF
376
377 --replace_regex $strerrfix
378
379 --error ER_IO_READ_ERROR
380 ALTER TABLE t1 IMPORT TABLESPACE;
381
382 SET SESSION debug_dbug=@saved_debug_dbug;
383
384 DROP TABLE t1;
385
386 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
387 INSERT INTO t1 VALUES (1);
388
389 ALTER TABLE t1 DISCARD TABLESPACE;
390
391 --error ER_TABLESPACE_DISCARDED
392 SELECT COUNT(*) FROM t1;
393
394 SET SESSION debug_dbug="+d,ib_import_io_read_error_3";
395
396 perl;
397 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
398 ib_restore_cfg_files("test", "t1");
399 EOF
400
401 --replace_regex $strerrfix
402
403 --error ER_IO_READ_ERROR
404 ALTER TABLE t1 IMPORT TABLESPACE;
405
406 SET SESSION debug_dbug=@saved_debug_dbug;
407
408 DROP TABLE t1;
409
410 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
411 INSERT INTO t1 VALUES (1);
412
413 ALTER TABLE t1 DISCARD TABLESPACE;
414
415 --error ER_TABLESPACE_DISCARDED
416 SELECT COUNT(*) FROM t1;
417
418 SET SESSION debug_dbug="+d,ib_import_io_read_error_4";
419
420 perl;
421 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
422 ib_restore_cfg_files("test", "t1");
423 EOF
424
425 --replace_regex $strerrfix
426
427 --error ER_IO_READ_ERROR
428 ALTER TABLE t1 IMPORT TABLESPACE;
429
430 SET SESSION debug_dbug=@saved_debug_dbug;
431
432 DROP TABLE t1;
433
434 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
435 INSERT INTO t1 VALUES (1);
436
437 ALTER TABLE t1 DISCARD TABLESPACE;
438
439 --error ER_TABLESPACE_DISCARDED
440 SELECT COUNT(*) FROM t1;
441
442 SET SESSION debug_dbug="+d,ib_import_io_read_error_5";
443
444 perl;
445 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
446 ib_restore_cfg_files("test", "t1");
447 EOF
448
449 --replace_regex $strerrfix
450
451 --error ER_IO_READ_ERROR
452 ALTER TABLE t1 IMPORT TABLESPACE;
453
454 SET SESSION debug_dbug=@saved_debug_dbug;
455
456 DROP TABLE t1;
457
458 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
459 INSERT INTO t1 VALUES (1);
460
461 ALTER TABLE t1 DISCARD TABLESPACE;
462
463 --error ER_TABLESPACE_DISCARDED
464 SELECT COUNT(*) FROM t1;
465
466 SET SESSION debug_dbug="+d,ib_import_io_read_error_6";
467
468 perl;
469 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
470 ib_restore_cfg_files("test", "t1");
471 EOF
472
473 --replace_regex $strerrfix
474
475 --error ER_IO_READ_ERROR
476 ALTER TABLE t1 IMPORT TABLESPACE;
477
478 SET SESSION debug_dbug=@saved_debug_dbug;
479
480 DROP TABLE t1;
481
482 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
483 INSERT INTO t1 VALUES (1);
484
485 ALTER TABLE t1 DISCARD TABLESPACE;
486
487 --error ER_TABLESPACE_DISCARDED
488 SELECT COUNT(*) FROM t1;
489
490 SET SESSION debug_dbug="+d,ib_import_io_read_error_7";
491
492 perl;
493 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
494 ib_restore_cfg_files("test", "t1");
495 EOF
496
497 --replace_regex $strerrfix
498
499 --error ER_IO_READ_ERROR
500 ALTER TABLE t1 IMPORT TABLESPACE;
501
502 SET SESSION debug_dbug=@saved_debug_dbug;
503
504 DROP TABLE t1;
505
506 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
507 INSERT INTO t1 VALUES (1);
508
509 ALTER TABLE t1 DISCARD TABLESPACE;
510
511 --error ER_TABLESPACE_DISCARDED
512 SELECT COUNT(*) FROM t1;
513
514 SET SESSION debug_dbug="+d,ib_import_io_read_error_8";
515
516 perl;
517 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
518 ib_restore_cfg_files("test", "t1");
519 EOF
520
521 --replace_regex $strerrfix
522
523 --error ER_IO_READ_ERROR
524 ALTER TABLE t1 IMPORT TABLESPACE;
525
526 SET SESSION debug_dbug=@saved_debug_dbug;
527
528 DROP TABLE t1;
529
530 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
531 INSERT INTO t1 VALUES (1);
532
533 ALTER TABLE t1 DISCARD TABLESPACE;
534
535 --error ER_TABLESPACE_DISCARDED
536 SELECT COUNT(*) FROM t1;
537
538 SET SESSION debug_dbug="+d,ib_import_io_read_error_9";
539
540 perl;
541 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
542 ib_restore_cfg_files("test", "t1");
543 EOF
544
545 --replace_regex $strerrfix
546
547 --error ER_IO_READ_ERROR
548 ALTER TABLE t1 IMPORT TABLESPACE;
549
550 SET SESSION debug_dbug=@saved_debug_dbug;
551
552 DROP TABLE t1;
553
554 # Test string read failure
555 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
556 INSERT INTO t1 VALUES (1);
557
558 ALTER TABLE t1 DISCARD TABLESPACE;
559
560 --error ER_TABLESPACE_DISCARDED
561 SELECT COUNT(*) FROM t1;
562
563 SET SESSION debug_dbug="+d,ib_import_string_read_error";
564
565 perl;
566 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
567 ib_restore_cfg_files("test", "t1");
568 EOF
569
570 --replace_regex $strerrfix
571
572 --error ER_IO_READ_ERROR
573 ALTER TABLE t1 IMPORT TABLESPACE;
574
575 SET SESSION debug_dbug=@saved_debug_dbug;
576
577 DROP TABLE t1;
578
579 # Test OOM error during import
580
581 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
582 INSERT INTO t1 VALUES (1);
583
584 ALTER TABLE t1 DISCARD TABLESPACE;
585
586 --error ER_TABLESPACE_DISCARDED
587 SELECT COUNT(*) FROM t1;
588
589 # Restore files
590 perl;
591 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
592 ib_restore_tablespaces("test", "t1");
593 EOF
594
595 SET SESSION debug_dbug="+d,ib_import_OOM_1";
596
597 --replace_regex /'.*t1.cfg'/'t1.cfg'/
598
599 --error ER_OUT_OF_RESOURCES
600 ALTER TABLE t1 IMPORT TABLESPACE;
601
602 SET SESSION debug_dbug=@saved_debug_dbug;
603
604 DROP TABLE t1;
605
606
607 perl;
608 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
609 ib_unlink_tablespace("test", "t1");
610 EOF
611
612
613 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
614 INSERT INTO t1 VALUES (1);
615
616 ALTER TABLE t1 DISCARD TABLESPACE;
617
618 --error ER_TABLESPACE_DISCARDED
619 SELECT COUNT(*) FROM t1;
620
621 # Restore files
622 perl;
623 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
624 ib_restore_tablespaces("test", "t1");
625 EOF
626
627 SET SESSION debug_dbug="+d,ib_import_OOM_2";
628
629 --replace_regex /'.*t1.cfg'/'t1.cfg'/
630
631 --error ER_OUT_OF_RESOURCES
632 ALTER TABLE t1 IMPORT TABLESPACE;
633
634 SET SESSION debug_dbug=@saved_debug_dbug;
635
636 DROP TABLE t1;
637
638
639 perl;
640 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
641 ib_unlink_tablespace("test", "t1");
642 EOF
643
644
645 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
646 INSERT INTO t1 VALUES (1);
647
648 ALTER TABLE t1 DISCARD TABLESPACE;
649
650 --error ER_TABLESPACE_DISCARDED
651 SELECT COUNT(*) FROM t1;
652
653 # Restore files
654 perl;
655 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
656 ib_restore_tablespaces("test", "t1");
657 EOF
658
659 SET SESSION debug_dbug="+d,ib_import_OOM_4";
660
661 --replace_regex /'.*t1.cfg'/'t1.cfg'/
662
663 --error ER_OUT_OF_RESOURCES
664 ALTER TABLE t1 IMPORT TABLESPACE;
665
666 SET SESSION debug_dbug=@saved_debug_dbug;
667
668 DROP TABLE t1;
669
670
671 perl;
672 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
673 ib_unlink_tablespace("test", "t1");
674 EOF
675
676
677 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
678 INSERT INTO t1 VALUES (1);
679
680 ALTER TABLE t1 DISCARD TABLESPACE;
681
682 --error ER_TABLESPACE_DISCARDED
683 SELECT COUNT(*) FROM t1;
684
685 # Restore files
686 perl;
687 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
688 ib_restore_tablespaces("test", "t1");
689 EOF
690
691 SET SESSION debug_dbug="+d,ib_import_OOM_5";
692
693 --replace_regex /'.*t1.cfg'/'t1.cfg'/
694
695 --error ER_OUT_OF_RESOURCES
696 ALTER TABLE t1 IMPORT TABLESPACE;
697
698 SET SESSION debug_dbug=@saved_debug_dbug;
699
700 DROP TABLE t1;
701
702
703 perl;
704 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
705 ib_unlink_tablespace("test", "t1");
706 EOF
707
708 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
709 INSERT INTO t1 VALUES (1);
710
711 ALTER TABLE t1 DISCARD TABLESPACE;
712
713 --error ER_TABLESPACE_DISCARDED
714 SELECT COUNT(*) FROM t1;
715
716 # Restore files
717 perl;
718 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
719 ib_restore_tablespaces("test", "t1");
720 EOF
721
722 SET SESSION debug_dbug="+d,ib_import_OOM_6";
723
724 --replace_regex /'.*t1.cfg'/'t1.cfg'/
725
726 --error ER_OUT_OF_RESOURCES
727 ALTER TABLE t1 IMPORT TABLESPACE;
728
729 SET SESSION debug_dbug=@saved_debug_dbug;
730
731 DROP TABLE t1;
732
733 perl;
734 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
735 ib_unlink_tablespace("test", "t1");
736 EOF
737
738 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
739 INSERT INTO t1 VALUES (1);
740
741 ALTER TABLE t1 DISCARD TABLESPACE;
742
743 --error ER_TABLESPACE_DISCARDED
744 SELECT COUNT(*) FROM t1;
745
746 # Restore files
747 perl;
748 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
749 ib_restore_tablespaces("test", "t1");
750 EOF
751
752 SET SESSION debug_dbug="+d,ib_import_OOM_7";
753
754 --replace_regex /'.*t1.cfg'/'t1.cfg'/
755
756 --error ER_OUT_OF_RESOURCES
757 ALTER TABLE t1 IMPORT TABLESPACE;
758
759 SET SESSION debug_dbug=@saved_debug_dbug;
760
761 DROP TABLE t1;
762
763 perl;
764 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
765 ib_unlink_tablespace("test", "t1");
766 EOF
767
768 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
769 INSERT INTO t1 VALUES (1);
770
771 ALTER TABLE t1 DISCARD TABLESPACE;
772
773 --error ER_TABLESPACE_DISCARDED
774 SELECT COUNT(*) FROM t1;
775
776 # Restore files
777 perl;
778 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
779 ib_restore_tablespaces("test", "t1");
780 EOF
781
782 SET SESSION debug_dbug="+d,ib_import_OOM_8";
783
784 --replace_regex /'.*t1.cfg'/'t1.cfg'/
785
786 --error ER_OUT_OF_RESOURCES
787 ALTER TABLE t1 IMPORT TABLESPACE;
788
789 SET SESSION debug_dbug=@saved_debug_dbug;
790
791 DROP TABLE t1;
792
793 perl;
794 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
795 ib_unlink_tablespace("test", "t1");
796 EOF
797
798 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
799 INSERT INTO t1 VALUES (1);
800
801 ALTER TABLE t1 DISCARD TABLESPACE;
802
803 --error ER_TABLESPACE_DISCARDED
804 SELECT COUNT(*) FROM t1;
805
806 # Restore files
807 perl;
808 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
809 ib_restore_tablespaces("test", "t1");
810 EOF
811
812 SET SESSION debug_dbug="+d,ib_import_OOM_9";
813
814 --replace_regex /'.*t1.cfg'/'t1.cfg'/
815
816 --error ER_OUT_OF_RESOURCES
817 ALTER TABLE t1 IMPORT TABLESPACE;
818
819 SET SESSION debug_dbug=@saved_debug_dbug;
820
821 DROP TABLE t1;
822
823 perl;
824 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
825 ib_unlink_tablespace("test", "t1");
826 EOF
827
828 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
829 INSERT INTO t1 VALUES (1);
830
831 ALTER TABLE t1 DISCARD TABLESPACE;
832
833 --error ER_TABLESPACE_DISCARDED
834 SELECT COUNT(*) FROM t1;
835
836 # Restore files
837 perl;
838 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
839 ib_restore_tablespaces("test", "t1");
840 EOF
841
842 SET SESSION debug_dbug="+d,ib_import_OOM_10";
843
844 --replace_regex /'.*t1.cfg'/'t1.cfg'/
845
846 --error ER_OUT_OF_RESOURCES
847 ALTER TABLE t1 IMPORT TABLESPACE;
848
849 SET SESSION debug_dbug=@saved_debug_dbug;
850
851 DROP TABLE t1;
852
853 perl;
854 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
855 ib_unlink_tablespace("test", "t1");
856 EOF
857
858 ####
859 # Test handling of internal failure error
860 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
861
862 ALTER TABLE t1 DISCARD TABLESPACE;
863
864 --error ER_TABLESPACE_DISCARDED
865 SELECT COUNT(*) FROM t1;
866
867 # Restore files
868 perl;
869 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
870 ib_restore_tablespaces("test", "t1");
871 EOF
872
873 # Test failure after reset of space id and LSN in the tablespace
874 SET SESSION debug_dbug="+d,ib_import_internal_error";
875
876 --replace_regex /'.*t1.cfg'/'t1.cfg'/
877
878 --error ER_INTERNAL_ERROR
879 ALTER TABLE t1 IMPORT TABLESPACE;
880
881 SET SESSION debug_dbug=@saved_debug_dbug;
882
883 # Restore files
884 perl;
885 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
886 ib_restore_tablespaces("test", "t1");
887 EOF
888
889 ALTER TABLE t1 IMPORT TABLESPACE;
890
891 DROP TABLE t1;
892
893
894 # Test failure after reset of space id and LSN in the tablespace
895 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
896
897 ALTER TABLE t1 DISCARD TABLESPACE;
898
899 --error ER_TABLESPACE_DISCARDED
900 SELECT COUNT(*) FROM t1;
901
902 # Restore files
903 perl;
904 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
905 ib_restore_tablespaces("test", "t1");
906 EOF
907
908 # Test failure after reset of space id and LSN in the tablespace
909 SET SESSION debug_dbug="+d,ib_import_reset_space_and_lsn_failure";
910
911 --replace_regex /'.*t1.cfg'/'t1.cfg'/
912
913 --error ER_INTERNAL_ERROR
914 ALTER TABLE t1 IMPORT TABLESPACE;
915
916 # Restore files
917 perl;
918 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
919 ib_restore_tablespaces("test", "t1");
920 EOF
921
922 SET SESSION debug_dbug=@saved_debug_dbug;
923
924 # Test failure after attempting a tablespace open
925 SET SESSION debug_dbug="+d,ib_import_open_tablespace_failure";
926
927 --replace_result \\ /
928 --error ER_GET_ERRMSG
929 ALTER TABLE t1 IMPORT TABLESPACE;
930
931 SET SESSION debug_dbug=@saved_debug_dbug;
932
933 # Restore files
934 perl;
935 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
936 ib_restore_tablespaces("test", "t1");
937 EOF
938
939 # Test failure after adjusting the cluster index root page
940 SET SESSION debug_dbug="+d,ib_import_cluster_root_adjust_failure";
941
942 --error ER_NOT_KEYFILE
943 ALTER TABLE t1 IMPORT TABLESPACE;
944
945 SET SESSION debug_dbug=@saved_debug_dbug;
946
947 # Restore files
948 perl;
949 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
950 ib_restore_tablespaces("test", "t1");
951 EOF
952
953 # Test failure after importing the cluster index
954 SET SESSION debug_dbug="+d,ib_import_cluster_failure";
955
956 --error ER_NOT_KEYFILE
957 ALTER TABLE t1 IMPORT TABLESPACE;
958
959 SET SESSION debug_dbug=@saved_debug_dbug;
960
961 # Restore files
962 perl;
963 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
964 ib_restore_tablespaces("test", "t1");
965 EOF
966
967 # Test failure after importing the secondary index(es)
968 SET SESSION debug_dbug="+d,ib_import_sec_root_adjust_failure";
969
970 --error ER_NOT_KEYFILE
971 ALTER TABLE t1 IMPORT TABLESPACE;
972
973 SET SESSION debug_dbug=@saved_debug_dbug;
974
975 # Restore files
976 perl;
977 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
978 ib_restore_tablespaces("test", "t1");
979 EOF
980
981 ALTER TABLE t1 IMPORT TABLESPACE;
982 DROP TABLE t1;
983
984 #
985 # Create a large table with delete marked records, disable purge during
986 # the update so that we can test the IMPORT purge code.
987 #
988 CREATE TABLE t1 (
989 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
990 c2 BIGINT,
991 c3 VARCHAR(2048),
992 c4 VARCHAR(2048),
993 INDEX idx1(c2),
994 INDEX idx2(c3(512)),
995 INDEX idx3(c4(512))) Engine=InnoDB;
996
997 # Stop purge so that it doesn't remove the delete marked entries.
998 connect (purge_control,localhost,root);
999 START TRANSACTION WITH CONSISTENT SNAPSHOT;
1000 connection default;
1001
1002 INSERT INTO t1
1003 SELECT 1 + seq, 1 + (seq MOD 4),
1004 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048),
1005 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048)
1006 FROM seq_0_to_127;
1007
1008 UPDATE t1 SET c2 = c2 + c1;
1009 UPDATE t1 SET c2 = c2 + c1;
1010 UPDATE t1 SET c2 = c2 + c1;
1011 UPDATE t1 SET c2 = c2 + c1;
1012 UPDATE t1 SET c2 = c2 + c1;
1013 UPDATE t1 SET c2 = c2 + c1;
1014 UPDATE t1 SET c2 = c2 + c1;
1015 UPDATE t1 SET c2 = c2 + c1;
1016 UPDATE t1 SET c2 = c2 + c1;
1017 UPDATE t1 SET c2 = c2 + c1;
1018 UPDATE t1 SET c2 = c2 + c1;
1019 UPDATE t1 SET c2 = c2 + c1;
1020 UPDATE t1 SET c2 = c2 + c1;
1021 UPDATE t1 SET c2 = c2 + c1;
1022 UPDATE t1 SET c2 = c2 + c1;
1023 UPDATE t1 SET c3 = REPEAT("c2", 1024);
1024 UPDATE t1 SET c4 = REPEAT("c4", 1024);
1025
1026 SHOW CREATE TABLE t1;
1027
1028 SELECT c1, c2 FROM t1;
1029 SELECT COUNT(*) FROM t1;
1030 SELECT SUM(c2) FROM t1;
1031
1032 FLUSH TABLES t1 FOR EXPORT;
1033
1034 perl;
1035 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1036 ib_backup_tablespaces("test", "t1");
1037 EOF
1038
1039 UNLOCK TABLES;
1040
1041 # Enable normal operation
1042 connection purge_control;
1043 COMMIT;
1044 disconnect purge_control;
1045 connection default;
1046
1047 DROP TABLE t1;
1048
1049 CREATE TABLE t1 (
1050 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
1051 c2 BIGINT,
1052 c3 VARCHAR(2048),
1053 c4 VARCHAR(2048),
1054 INDEX idx1(c2),
1055 INDEX idx2(c3(512)),
1056 INDEX idx3(c4(512))) Engine=InnoDB;
1057
1058 SELECT c1, c2 FROM t1;
1059
1060 ALTER TABLE t1 DISCARD TABLESPACE;
1061
1062 perl;
1063 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1064 ib_restore_tablespaces("test", "t1");
1065 EOF
1066
1067 ALTER TABLE t1 IMPORT TABLESPACE;
1068 CHECK TABLE t1;
1069
1070 SELECT c1,c2 FROM t1;
1071 SELECT COUNT(*) FROM t1;
1072 SELECT SUM(c2) FROM t1;
1073
1074 SHOW CREATE TABLE t1;
1075
1076 DROP TABLE t1;
1077
1078 ####
1079 # Create a table and save the tablespace and .cfg file, we need to create
1080 # a Btree that has several levels
1081 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1082
1083 INSERT IGNORE INTO t1 VALUES
1084 (100, REPEAT('Karanbir', 899), REPEAT('Ajeeth', 2731));
1085
1086 INSERT INTO t1
1087 SELECT 100, REPEAT('Karanbir', 128), REPEAT('Ajeeth', 1200)
1088 FROM seq_1_to_256;
1089 FLUSH TABLES t1 FOR EXPORT;
1090
1091 perl;
1092 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1093 ib_backup_tablespaces("test", "t1");
1094 EOF
1095
1096 UNLOCK TABLES;
1097
1098 DROP TABLE t1;
1099
1100 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1101
1102 ALTER TABLE t1 DISCARD TABLESPACE;
1103
1104 --error ER_TABLESPACE_DISCARDED
1105 SELECT COUNT(*) FROM t1;
1106
1107 # Restore files
1108 perl;
1109 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1110 ib_restore_tablespaces("test", "t1");
1111 EOF
1112
1113 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_1";
1114
1115 --replace_regex /'.*t1.cfg'/'t1.cfg'/
1116
1117 --error ER_INTERNAL_ERROR
1118 ALTER TABLE t1 IMPORT TABLESPACE;
1119
1120 SET SESSION debug_dbug=@saved_debug_dbug;
1121
1122 DROP TABLE t1;
1123
1124 perl;
1125 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1126 ib_unlink_tablespace("test", "t1");
1127 EOF
1128
1129 #
1130
1131 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1132
1133 ALTER TABLE t1 DISCARD TABLESPACE;
1134
1135 --error ER_TABLESPACE_DISCARDED
1136 SELECT COUNT(*) FROM t1;
1137
1138 # Restore files
1139 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
1140
1141 perl;
1142 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1143 ib_restore_tablespaces("test", "t1");
1144 my $page;
1145 my $ps = $ENV{INNODB_PAGE_SIZE};
1146 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.ibd";
1147 open(FILE, "+<$file") || die "Unable to open $file";
1148 binmode FILE;
1149 sysseek(FILE, 3*$ps, 0) || die "Unable to seek $file\n";
1150 die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
1151 substr($page,24,2)='42';
1152 sysseek(FILE, 3*$ps, 0) || die "Unable to rewind $file\n";
1153 syswrite(FILE, $page, $ps)==$ps || die "Unable to write $file\n";
1154 close(FILE) || die "Unable to close $file";
1155 EOF
1156
1157 --replace_regex /'.*t1.cfg'/'t1.cfg'/
1158
1159 --error ER_NOT_KEYFILE
1160 ALTER TABLE t1 IMPORT TABLESPACE;
1161
1162 DROP TABLE t1;
1163
1164 perl;
1165 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1166 ib_unlink_tablespace("test", "t1");
1167 EOF
1168
1169 #
1170 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1171
1172 ALTER TABLE t1 DISCARD TABLESPACE;
1173
1174 --error ER_TABLESPACE_DISCARDED
1175 SELECT COUNT(*) FROM t1;
1176
1177 # Restore files
1178 perl;
1179 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1180 ib_restore_tablespaces("test", "t1");
1181 EOF
1182
1183 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_2";
1184
1185 --error ER_INNODB_INDEX_CORRUPT
1186 ALTER TABLE t1 IMPORT TABLESPACE;
1187
1188 SET SESSION debug_dbug=@saved_debug_dbug;
1189
1190 DROP TABLE t1;
1191
1192 perl;
1193 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1194 ib_unlink_tablespace("test", "t1");
1195 EOF
1196 #
1197
1198 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1199
1200 ALTER TABLE t1 DISCARD TABLESPACE;
1201
1202 --error ER_TABLESPACE_DISCARDED
1203 SELECT COUNT(*) FROM t1;
1204
1205 # Restore files
1206 perl;
1207 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1208 ib_restore_tablespaces("test", "t1");
1209 EOF
1210
1211 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_3";
1212
1213 --error ER_NOT_KEYFILE
1214 ALTER TABLE t1 IMPORT TABLESPACE;
1215
1216 SET SESSION debug_dbug=@saved_debug_dbug;
1217
1218 DROP TABLE t1;
1219
1220 perl;
1221 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1222 ib_unlink_tablespace("test", "t1");
1223 EOF
1224
1225 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1226
1227 SET SESSION debug_dbug="+d,ib_import_create_index_failure_1";
1228
1229 --error ER_RECORD_FILE_FULL
1230 ALTER TABLE t1 ADD INDEX idx(c1);
1231
1232 SET SESSION debug_dbug=@saved_debug_dbug;
1233
1234 ALTER TABLE t1 DISCARD TABLESPACE;
1235
1236 --error ER_TABLESPACE_DISCARDED
1237 SELECT COUNT(*) FROM t1;
1238
1239 ALTER TABLE t1 ADD INDEX idx(c1);
1240
1241 DROP TABLE t1;
1242
1243 perl;
1244 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1245 ib_unlink_tablespace("test", "t1");
1246 EOF
1247
1248 #
1249
1250 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1251
1252 ALTER TABLE t1 DISCARD TABLESPACE;
1253
1254 --error ER_TABLESPACE_DISCARDED
1255 SELECT COUNT(*) FROM t1;
1256
1257 # Restore files
1258 perl;
1259 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1260 ib_restore_tablespaces("test", "t1");
1261 EOF
1262
1263 SET SESSION debug_dbug="+d,fil_space_create_failure";
1264
1265 --replace_result \\ /
1266 --error ER_GET_ERRMSG
1267 ALTER TABLE t1 IMPORT TABLESPACE;
1268
1269 SET SESSION debug_dbug=@saved_debug_dbug;
1270
1271 DROP TABLE t1;
1272
1273 perl;
1274 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1275 ib_unlink_tablespace("test", "t1");
1276 EOF
1277
1278 #
1279
1280 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1281
1282 ALTER TABLE t1 DISCARD TABLESPACE;
1283
1284 --error ER_TABLESPACE_DISCARDED
1285 SELECT COUNT(*) FROM t1;
1286
1287 # Restore files
1288 perl;
1289 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1290 ib_restore_tablespaces("test", "t1");
1291 EOF
1292
1293 SET SESSION debug_dbug="+d,dict_tf_to_fsp_flags_failure";
1294
1295 --replace_result \\ /
1296 --error ER_GET_ERRMSG
1297 ALTER TABLE t1 IMPORT TABLESPACE;
1298
1299 SET SESSION debug_dbug=@saved_debug_dbug;
1300
1301 DROP TABLE t1;
1302
1303 perl;
1304 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1305 ib_unlink_tablespace("test", "t1");
1306 EOF
1307
1308 #
1309
1310 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
1311
1312 ALTER TABLE t1 DISCARD TABLESPACE;
1313
1314 --error ER_TABLESPACE_DISCARDED
1315 SELECT COUNT(*) FROM t1;
1316
1317 # Restore files
1318 perl;
1319 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1320 ib_restore_tablespaces("test", "t1");
1321 EOF
1322
1323 SET SESSION debug_dbug="+d,fsp_flags_is_valid_failure";
1324
1325 --replace_regex /'.*t1.cfg'/'t1.cfg'/
1326
1327 --error ER_NOT_KEYFILE
1328 ALTER TABLE t1 IMPORT TABLESPACE;
1329
1330 SET SESSION debug_dbug=@saved_debug_dbug;
1331
1332 DROP TABLE t1;
1333
1334 perl;
1335 do "$ENV{MTR_SUITE_DIR}/include/innodb-util.pl";
1336 ib_unlink_tablespace("test", "t1");
1337 EOF
1338
1339 --disable_query_log
1340 call mtr.add_suppression("InnoDB: The log sequence numbers [0-9]+ and [0-9]+ in ibdata files do not match the log sequence number [0-9]+ in the ib_logfiles!");
1341 call mtr.add_suppression("'Resource temporarily unavailable'");
1342 call mtr.add_suppression("Got error -1 when reading table '.*'");
1343 call mtr.add_suppression("InnoDB: Table '.*' tablespace is set as discarded.");
1344 call mtr.add_suppression("InnoDB: Tablespace '.*' exists in the cache.*");
1345 call mtr.add_suppression("InnoDB: Freeing existing tablespace '.*' entry from the cache with id.*");
1346 call mtr.add_suppression("InnoDB: The table .* doesn't have a corresponding tablespace, it was discarded");
1347 call mtr.add_suppression(".*There was an error writing to the meta data file.*");
1348 call mtr.add_suppression("InnoDB: Trying to import a tablespace, but could not open the tablespace file");
1349 call mtr.add_suppression("Unsupported tablespace format");
1350 call mtr.add_suppression("Page is marked as free");
1351 call mtr.add_suppression("t1.ibd: Page .* at offset .* looks corrupted");
1352 call mtr.add_suppression("but tablespace with that id or name does not exist");
1353 call mtr.add_suppression("Could not find a valid tablespace file for '.*t1'");
1354 call mtr.add_suppression("while reading index meta-data, expected to read 44 bytes but read only 0 bytes");
1355 call mtr.add_suppression("Index for table 't1' is corrupt; try to repair it");
1356 --enable_query_log
1357
1358 #cleanup
1359 --remove_file $MYSQLTEST_VARDIR/tmp/t1.cfg
1360 --remove_file $MYSQLTEST_VARDIR/tmp/t1.ibd