Debian Codegraph @

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

raw
1 # 1. Test redo log files with invalid value of redo format (from future).
2 # 2. Test redo log files filled with 0x00 only.
3
4 --source include/have_debug.inc
5
6 --source ../include/redo_log_error_patterns.inc
7
8 let $tmpdir = $MYSQLTEST_VARDIR/tmp;
9
10 let MYSQLD_DATADIR = $tmpdir/log_invalid_format;
11 --mkdir $MYSQLD_DATADIR
12
13
14 let MYSQLD_ERROR_LOG = $tmpdir/my_restart.err;
15 let SEARCH_FILE = $MYSQLD_ERROR_LOG;
16
17 --echo # Create new data directory (in order to corrupt its redo log files)...
18 --source include/initialize_datadir.inc
19
20 --force-rmdir $MYSQLD_DATADIR/#innodb_redo
21
22 --echo ############################################################################################
23 --echo # Case 1. Attempt to start with redo files in old location, filled with 0x00.
24 --echo ############################################################################################
25
26 --remove_file $SEARCH_FILE
27
28 --echo # Prepare...
29
30 let IB_LOGFILE0_PATH = $MYSQLD_DATADIR/ib_logfile0;
31 let IB_LOGFILE1_PATH = $MYSQLD_DATADIR/ib_logfile1;
32
33 perl;
34 sub create_empty_file {
35 my ($file_path, $file_size) = @_;
36 open my $fh, '>:raw', $file_path or die "open failed: $!\n";
37 syswrite $fh, "\0" x $file_size or die "print failed: $!\n";
38 close $fh or die "closed failed: $!\n";
39 }
40 create_empty_file($ENV{IB_LOGFILE0_PATH}, 4*1024*1024);
41 create_empty_file($ENV{IB_LOGFILE1_PATH}, 4*1024*1024);
42 EOF
43
44 let $i = 1;
45 while ($i <= 2) {
46 --echo # Start MySQL... (attempt $i)
47 --error 1,42
48 --exec $MYSQLD --no-defaults $MYSQLD_ARGS --$UNKNOWN_PARAM
49
50 --echo # Verify...
51
52 let SEARCH_PATTERN = Unsupported redo log format \(v0\);
53 # Expected: found
54 --source include/search_pattern.inc
55
56 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
57 # Expected: not found
58 --source include/search_pattern.inc
59
60 inc $i;
61 }
62
63 --move_file $SEARCH_FILE $MYSQLTEST_VARDIR/log/log_invalid_format-1.err
64
65 --echo ############################################################################################
66 --echo # Case 2. Attempt to start with redo files in new location, filled with 0x00.
67 --echo ############################################################################################
68
69 --echo # Prepare...
70 --mkdir $MYSQLD_DATADIR/#innodb_redo
71
72 --move_file $IB_LOGFILE0_PATH $MYSQLD_DATADIR/#innodb_redo/#ib_redo1
73 --move_file $IB_LOGFILE1_PATH $MYSQLD_DATADIR/#innodb_redo/#ib_redo2
74
75 let $i = 1;
76 while ($i <= 2) {
77 --echo # Start MySQL... (attempt $i)
78 --error 1,42
79 --exec $MYSQLD --no-defaults $MYSQLD_ARGS --$UNKNOWN_PARAM
80
81 --echo # Verify...
82
83 let SEARCH_PATTERN = Found redo log file.*#ib_redo1 which has format \(v0\) and is stored inside #innodb_redo;
84 # Expected: found
85 --source include/search_pattern.inc
86
87 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
88 # Expected: not found
89 --source include/search_pattern.inc
90
91 inc $i;
92 }
93
94 --move_file $MYSQLD_DATADIR/#innodb_redo/#ib_redo1 $IB_LOGFILE0_PATH
95 --move_file $MYSQLD_DATADIR/#innodb_redo/#ib_redo2 $IB_LOGFILE1_PATH
96
97 --move_file $SEARCH_FILE $MYSQLTEST_VARDIR/log/log_invalid_format-2.err
98
99 --force-rmdir $MYSQLD_DATADIR/#innodb_redo
100
101 --echo ############################################################################################
102 --echo # Case 3. Attempt to start with redo files in old location, with future format (4294967295).
103 --echo ############################################################################################
104
105 --echo # Prepare...
106 perl;
107 sub log_update_file_format {
108 my ($file_path, $format) = @_;
109 open my $fh, '+<:raw', $file_path or die "open failed: $!\n";
110 seek $fh, 0, 0;
111 syswrite($fh, pack('N', $format), 4) > 0 or die "print failed: $!\n";
112 close $fh or die "closed failed: $!\n";
113 }
114 log_update_file_format($ENV{IB_LOGFILE0_PATH}, 4294967295);
115 log_update_file_format($ENV{IB_LOGFILE1_PATH}, 4294967295);
116 EOF
117
118 let $i = 1;
119 while ($i <= 2) {
120 --echo # Start MySQL... (attempt $i)
121 --error 1,42
122 --exec $MYSQLD --no-defaults $MYSQLD_ARGS --debug="d,log_header_checksum_disabled" --$UNKNOWN_PARAM
123
124 --echo # Verify...
125
126 let SEARCH_PATTERN = Found redo log file .*ib_logfile0 which has format \(v4294967295\) and is stored outside #innodb_redo;
127 # Expected: found
128 --source include/search_pattern.inc
129
130 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
131 # Expected: not found
132 --source include/search_pattern.inc
133
134 inc $i;
135 }
136
137 --move_file $SEARCH_FILE $MYSQLTEST_VARDIR/log/log_invalid_format-3.err
138
139 --echo ############################################################################################
140 --echo # Case 4. Attempt to start with redo files in new location, with future format (4294967295).
141 --echo ############################################################################################
142
143 --echo # Prepare...
144 --mkdir $MYSQLD_DATADIR/#innodb_redo
145
146 --move_file $IB_LOGFILE0_PATH $MYSQLD_DATADIR/#innodb_redo/#ib_redo1
147 --move_file $IB_LOGFILE1_PATH $MYSQLD_DATADIR/#innodb_redo/#ib_redo2
148
149 let $i = 1;
150 while ($i <= 2) {
151 --echo # Start MySQL... (attempt $i)
152 --error 1,42
153 --exec $MYSQLD --no-defaults $MYSQLD_ARGS --debug="d,log_header_checksum_disabled" --$UNKNOWN_PARAM
154
155 --echo # Verify...
156
157 let SEARCH_PATTERN = Unknown redo log format \(v4294967295\) in file.*#ib_redo1;
158 # Expected: found
159 --source include/search_pattern.inc
160
161 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
162 # Expected: not found
163 --source include/search_pattern.inc
164
165 inc $i;
166 }
167
168 --move_file $SEARCH_FILE $MYSQLTEST_VARDIR/log/log_invalid_format-4.err
169
170 --echo ############################################################################################
171
172 --echo # Cleanup...
173
174 --force-rmdir $MYSQLD_DATADIR
175
176 let MYSQLD_ARGS=;
177 let MYSQLD_DATADIR=;
178 let MYSQLD_ERROR_LOG=;
179 let SEARCH_FILE=;
180 let SEARCH_PATTERN=;