Debian Codegraph @

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

raw
1 --source include/have_debug_sync.inc
2
3 # This test checks scenario of recovery executed on data directory with a redo
4 # file that has invalid metadata.
5 # Scenario-2. Create scenario based on at least two redo files, in which the
6 # second redo file has start_lsn different than end_lsn of the first file.
7
8 # According to perl's documentation, 'Q' in (un)pack() is supported only if perl
9 # has been compiled with support for 64bit integers.
10 # The log_file_get_start_lsn(), which is used in this test, uses unpack('Q>').
11 --source include/have_perl_64bit_int.inc
12
13 --let $INNODB_PAGE_SIZE = `select @@innodb_page_size`
14 --let MYSQLD_IB_REDO_LOG_NON_TMP_FILES_COUNT_MIN = 2
15
16 --source include/log_multiple_files_test_begin.inc
17
18 perl;
19 require 'include/ib_redo_log_files.inc';
20 my $fpath = '';
21 my $n = 0;
22 for my $f (log_get_non_tmp_files()) {
23 if ($n++ > 0) {
24 $fpath = $f;
25 last;
26 }
27 }
28
29 my $start_lsn = 0;
30 my $start_lsn_orig = 0;
31
32 my $result_file_path = "$ENV{'MYSQLD_DATADIR'}/found.inc";
33
34 if ($fpath ne '') {
35 $start_lsn = log_file_get_start_lsn($fpath);
36 $start_lsn_orig = $start_lsn;
37 $start_lsn += 512;
38 my $packed_start_lsn = pack('Q>', $start_lsn);
39
40 log_file_set_start_lsn($fpath, $start_lsn);
41
42 open my $fh, '+>', $result_file_path or die "open failed: $!\n";
43 syswrite($fh, "let REDO_FILE=$fpath;\n") > 0 or die "write failed: $!\n";
44 syswrite($fh, "let REDO_FILE_NEW_START_LSN=$start_lsn;\n") > 0 or die "write failed: $!\n";
45 syswrite($fh, "let REDO_FILE_OLD_START_LSN=$start_lsn_orig;\n") > 0 or die "write failed: $!\n";
46 close $fh or die "close failed: $!\n";
47 } else {
48 open my $fh, '+>', $result_file_path or die "open failed: $!\n";
49 syswrite($fh, "--skip The required number of redo files was decreased just before MySQL was killed.\n") > 0 or die "write failed: $!\n";
50 close $fh or die "close failed: $!\n";
51 }
52
53 EOF
54
55 --source $MYSQLD_DATADIR/found.inc
56
57 let MYSQLD_EXTRA_ARGS = --debug="d,log_header_checksum_disabled" --innodb_page_size=$INNODB_PAGE_SIZE;
58 let SEARCH_FILE = $MYSQLD_ERROR_LOG;
59
60 --error 1,42
61 --exec $MYSQLD --no-defaults $MYSQLD_ARGS $MYSQLD_EXTRA_ARGS --innodb-unknown-param=y
62 let SEARCH_PATTERN = The redo log file .* has start_lsn $REDO_FILE_NEW_START_LSN but expected $REDO_FILE_OLD_START_LSN \(end_lsn of the previous redo log file\);
63 --replace_result $REDO_FILE_NEW_START_LSN REDO_FILE_NEW_START_LSN $REDO_FILE_OLD_START_LSN REDO_FILE_OLD_START_LSN $INNODB_PAGE_SIZE INNODB_PAGE_SIZE
64 --source include/search_pattern.inc
65
66 --source include/log_multiple_files_test_end.inc