Debian Codegraph @

mysql-test/suite/innodb/t/log_corruption_recovery.test

raw
1 --source include/have_innodb.inc
2
3 --let DATADIR=`select @@datadir`
4 let $check_no_innodb=SELECT * FROM INFORMATION_SCHEMA.ENGINES
5 WHERE engine = 'innodb'
6 AND support IN ('YES', 'DEFAULT', 'ENABLED');
7 --let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err
8
9 --echo #
10 --echo # MDEV-37412 Corrupted page during recovery aborts the server
11 --echo #
12
13 call mtr.add_suppression("InnoDB: OPT_PAGE_CHECKSUM mismatch on \\[page id: space=127, page number=0\\]");
14 call mtr.add_suppression("InnoDB: Set innodb_force_recovery=1");
15 call mtr.add_suppression("InnoDB: Cannot apply log to \\[page id: space=127, page number=0\\] of corrupted file '.*test/t\\.ibd");
16 call mtr.add_suppression("(InnoDB: Plugin|Plugin 'InnoDB')");
17 # Allow innodb_force_recovery=1 to write up to 10 FILE_CHECKPOINT records
18 call mtr.add_suppression("InnoDB: Page .* Current system log sequence number 123(38|54)");
19 SET GLOBAL innodb_fast_shutdown=0;
20 --source include/shutdown_mysqld.inc
21 --move_file $DATADIR/ib_logfile0 $DATADIR/ib_logfile0.old
22 perl;
23 do "$ENV{MTR_SUITE_DIR}/../innodb/include/crc32.pl";
24 die unless open OUT, ">", "$ENV{DATADIR}/ib_logfile0";
25 binmode OUT;
26 sub crc32c {
27 my ($input) = @_;
28 print OUT $input, pack("N", mycrc32($input, 0, 0x82f63b78))
29 }
30 sub mtr {
31 my ($input) = @_;
32 print OUT $input, chr(1), pack("N", mycrc32($input, 0, 0x82f63b78))
33 }
34 crc32c("Phys" . pack("x[8]N", 0x3000) . "BogoDB 1.2.3.4" . chr(0) x 478);
35 print OUT chr(0) x 3584;
36 crc32c(pack("x[4]Nx[4]Nx[44]", 0x3000, 0x3000));
37 print OUT chr(0) x 8128;
38 mtr(pack("Cx[6]N", 0xfa, 0x3000)); # FILE_CHECKPOINT
39 mtr(pack("CCx", 0x8c, 127) . "test/t.ibd"); # FILE_CREATE
40 # INIT_PAGE, OPT_PAGE_CHECKSUM
41 mtr(pack("CCxCCx[6]", 0x12, 127, 0x77, 127));
42 EOF
43
44 write_file $DATADIR/test/t.ibd;
45 EOF
46
47 --source include/start_mysqld.inc
48 eval $check_no_innodb;
49 let SEARCH_PATTERN=InnoDB: Page .* Current system log sequence number;
50 --source include/search_pattern_in_file.inc
51 --let $restart_parameters=--innodb-force-recovery=1
52 --source include/restart_mysqld.inc
53 eval $check_no_innodb;
54 --source include/shutdown_mysqld.inc
55
56 --move_file $DATADIR/ib_logfile0.old $DATADIR/ib_logfile0
57 --remove_file $DATADIR/test/t.ibd
58 --let $restart_parameters=
59
60 --source include/search_pattern_in_file.inc
61 let SEARCH_PATTERN=InnoDB: OPT_PAGE_CHECKSUM mismatch on \\[page id: space=127, page number=0\\];
62 --source include/search_pattern_in_file.inc
63 let SEARCH_PATTERN=InnoDB: Cannot apply log to \\[page id: space=127, page number=0\\] of corrupted file .*test/t\\.ibd;
64 --source include/search_pattern_in_file.inc
65
66 --source include/start_mysqld.inc
67 eval $check_no_innodb;