| 1 |
--source include/have_debug_sync.inc |
| 2 |
|
| 3 |
# This test checks recovery executed on data directory with a redo file that has invalid metadata. |
| 4 |
# Scenario-1: Make start_lsn not divisible by 512. |
| 5 |
|
| 6 |
let $tmp_dir = $MYSQLTEST_VARDIR/tmp; |
| 7 |
let MYSQLD_DATADIR = $tmp_dir/log_invalid_file; |
| 8 |
let MYSQLD_ERROR_LOG = $tmp_dir/my_restart.err; |
| 9 |
let MYSQLD_EXTRA_ARGS = ; |
| 10 |
let SEARCH_FILE = $MYSQLD_ERROR_LOG; |
| 11 |
|
| 12 |
--echo # Initialize new data directory... |
| 13 |
--source include/initialize_datadir.inc |
| 14 |
|
| 15 |
perl; |
| 16 |
require 'include/ib_redo_log_files.inc'; |
| 17 |
my $fpath = ''; |
| 18 |
for my $f (log_get_non_tmp_files()) { |
| 19 |
$fpath = $f; |
| 20 |
last; |
| 21 |
} |
| 22 |
open my $fh, '+<:raw', $fpath or die "open failed: $!\n"; |
| 23 |
seek $fh, 8+7, 0; |
| 24 |
syswrite($fh, 123, 1) == 1 or die "write failed: $!\n"; |
| 25 |
close $fh or die "close failed: $!\n"; |
| 26 |
EOF |
| 27 |
|
| 28 |
# The recovery would fail because of invalid checksum (after we corrupted start_lsn and did not update checksum) |
| 29 |
--error 1,42 |
| 30 |
--exec $MYSQLD --no-defaults $MYSQLD_ARGS |
| 31 |
let SEARCH_PATTERN = Invalid redo log header checksum; |
| 32 |
--source include/search_pattern.inc |
| 33 |
|
| 34 |
let MYSQLD_EXTRA_ARGS = --debug="d,log_header_checksum_disabled"; |
| 35 |
|
| 36 |
# Now, let's assume that the invalid start_lsn was written by broken InnoDB instance (so header has valid checksum) |
| 37 |
--error 1,42 |
| 38 |
--exec $MYSQLD --no-defaults $MYSQLD_ARGS $MYSQLD_EXTRA_ARGS |
| 39 |
let SEARCH_PATTERN = The redo log file .* has invalid start_lsn; |
| 40 |
--source include/search_pattern.inc |
| 41 |
|
| 42 |
--move_file $SEARCH_FILE $MYSQLTEST_VARDIR/log/log_file_invalid_start_lsn.err |
| 43 |
|
| 44 |
--force-rmdir $MYSQLD_DATADIR |
| 45 |
|
| 46 |
let MYSQLD_ARGS=; |
| 47 |
let MYSQLD_EXTRA_ARGS=; |
| 48 |
let MYSQLD_DATADIR=; |
| 49 |
let MYSQLD_ERROR_LOG=; |