| 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; |