Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 # Test crashes during upgrade of the InnoDB redo log.
3
4 # Avoid CrashReporter popup on Mac
5 --source include/not_crashrep.inc
6
7 # innodb-force-upgrade-crash needs debug
8 --source include/have_debug.inc
9
10 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
11 BEGIN;
12 INSERT INTO t1 VALUES (42);
13
14 let $restart_parameters = restart: --innodb-redo-log-capacity=12M;
15 --source include/kill_and_restart_mysqld.inc
16
17 SELECT * FROM t1;
18
19 INSERT INTO t1 VALUES (42);
20 BEGIN;
21 DELETE FROM t1;
22
23 let $restart_parameters = restart: --innodb-redo-log-capacity=15M;
24 --source include/kill_and_restart_mysqld.inc
25
26 SELECT * FROM t1;
27
28 INSERT INTO t1 VALUES (123);
29
30
31 SET GLOBAL innodb_log_checkpoint_now = 1;
32 --let $lctn= query_get_value(SHOW VARIABLES LIKE 'lower_case_table_names', Value, 1)
33
34 --let $MYSQLD_DATADIR1= $MYSQL_TMP_DIR/data_80011
35 --let $ZIP_FILE= $MYSQLTEST_VARDIR/std_data/upgrade/data_80011.zip
36 if ($lctn == 1)
37 {
38 --let $MYSQLD_DATADIR1= $MYSQL_TMP_DIR/data_80011_ci
39 --let $ZIP_FILE= $MYSQLTEST_VARDIR/std_data/upgrade/data_80011_ci_win.zip
40 }
41 if ($lctn == 2)
42 {
43 --let $MYSQLD_DATADIR1= $MYSQL_TMP_DIR/data_80011_ci
44 --let $ZIP_FILE= $MYSQLTEST_VARDIR/std_data/upgrade/data_80011_ci_mac.zip
45 }
46
47 --let $MYSQLD_LOG = $MYSQLD_DATADIR1/mysqld.err
48 --let SEARCH_FILE= $MYSQLD_LOG
49 let $args=--datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG --log-error-verbosity=3;
50 let $recv_crash=$args --innodb-force-recovery-crash;
51 --source include/kill_mysqld.inc
52
53 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
54 --list_files $MYSQLD_DATADIR1 ib_logfile*
55
56 --echo #
57 --echo # Crashing during recovery (common logic)
58 --echo #
59
60 --echo # Crash right before recovery starts:
61 --error 137,3
62 --exec $MYSQLD_CMD $recv_crash=1
63 let SEARCH_PATTERN= Completed space ID check;
64 --echo # Expect "found"
65 --source include/search_pattern.inc
66 --remove_file $SEARCH_FILE
67
68 --echo # Crash after log records applied:
69 --error 137,3
70 --exec $MYSQLD_CMD $recv_crash=2
71 let SEARCH_PATTERN= Starting to parse redo log at lsn = [0-9]+, whereas checkpoint_lsn = [0-9]+;
72 --echo # Expect "found"
73 --source include/search_pattern.inc
74 --remove_file $SEARCH_FILE
75
76 --echo # Crash right before recovery ends:
77 --error 137,3
78 --exec $MYSQLD_CMD $recv_crash=3
79 let SEARCH_PATTERN= Apply batch completed;
80 --echo # Expect "found"
81 --source include/search_pattern.inc
82 --remove_file $SEARCH_FILE
83
84 --echo # Crash after dynamic metadata apply:
85 --error 137,3
86 --exec $MYSQLD_CMD $recv_crash=4
87 --remove_file $SEARCH_FILE
88
89 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
90 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
91 --source include/start_mysqld.inc
92 SHOW TABLES FROM test;
93
94 # Upgraded succeeded, so now let's start again
95 --source include/kill_mysqld.inc
96 --force-rmdir $MYSQLD_DATADIR1
97 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
98
99 --echo #
100 --echo # Crashing during upgrade itself
101 --echo #
102
103 #--------------------------------------------------------
104 --echo # Crash right after verifying clean shutdown:
105 #--------------------------------------------------------
106 --error 137,3
107 --exec $MYSQLD_CMD $recv_crash=5
108 let SEARCH_PATTERN= Apply batch completed;
109 --echo # Expect "not found"
110 --source include/search_pattern.inc
111 let SEARCH_PATTERN= Upgrading redo log: .* LSN=[0-9]+;
112 --echo # Expect "found"
113 --source include/search_pattern.inc
114 --remove_file $SEARCH_FILE
115
116 #--------------------------------------------------------
117 --echo # Crash right after deleting first log file:
118 #--------------------------------------------------------
119 --error 137,3
120 --exec $MYSQLD_CMD $recv_crash=7
121 let SEARCH_PATTERN=innodb_force_recovery_crash=7;
122 --echo # Expect "found"
123 --source include/search_pattern.inc
124
125 --list_files $MYSQLD_DATADIR1 ib_logfile*
126 --remove_file $SEARCH_FILE
127
128 # Server is not able to recover.
129 # This bahaviour is actually wrong!
130 # InnoDB should be able to continue after restart without manual intervention
131 # from the user if one file is missing! But as of now, it doesn't work and this
132 # test demonstrates manual steps are required.
133 --error 1
134 --exec $MYSQLD_CMD $args
135
136 let SEARCH_PATTERN=Missing ib_logfile0 in the directory;
137 --echo # Expect "found"
138 --source include/search_pattern.inc
139
140 # We would have to manually remove the other log file
141 --remove_file $MYSQLD_DATADIR1/ib_logfile1
142 # And also manually create the #innodb_redo directory
143 --mkdir $MYSQLD_DATADIR1/#innodb_redo
144
145 # Let's try to continue the upgrade
146 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
147 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
148 --source include/start_mysqld.inc
149 SHOW TABLES FROM test;
150
151 # Upgraded succeeded, so now let's start again
152 --source include/kill_mysqld.inc
153 --force-rmdir $MYSQLD_DATADIR1
154 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
155
156 #--------------------------------------------------------
157 --echo # Crash right after deleting all log files:
158 #--------------------------------------------------------
159 --error 137,3
160 --exec $MYSQLD_CMD $recv_crash=8
161 let SEARCH_PATTERN=innodb_force_recovery_crash=8;
162 --echo # Expect "found"
163 --source include/search_pattern.inc
164 --remove_file $SEARCH_FILE
165 --list_files $MYSQLD_DATADIR1 ib_logfile*
166 # After restart there are no files, so it should work fine
167 # Also the crash happens after we've already created #innodb_redo directory
168 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
169 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
170 --source include/start_mysqld.inc
171 SHOW TABLES FROM test;
172
173 # Upgraded succeeded, so now let's start again
174 --source include/kill_mysqld.inc
175 --force-rmdir $MYSQLD_DATADIR1
176 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
177
178 #--------------------------------------------------------
179 --echo # Crash after creating #ib_redo0_tmp:
180 #--------------------------------------------------------
181 --error 137,3
182 --exec $MYSQLD_CMD $recv_crash=9
183 let SEARCH_PATTERN=innodb_force_recovery_crash=9;
184 --echo # Expect "found"
185 --source include/search_pattern.inc
186 --remove_file $SEARCH_FILE
187 --list_files $MYSQLD_DATADIR1 ib_logfile*
188 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
189 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
190 --source include/start_mysqld.inc
191 SHOW TABLES FROM test;
192
193 # Upgraded succeeded, so now let's start again
194 --source include/kill_mysqld.inc
195 --force-rmdir $MYSQLD_DATADIR1
196 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
197
198 #--------------------------------------------------------
199 --echo # Crash after renaming #ib_redo0_tmp to #ib_redo0:
200 #--------------------------------------------------------
201 --error 137,3
202 --exec $MYSQLD_CMD $recv_crash=10
203 let SEARCH_PATTERN=innodb_force_recovery_crash=10;
204 --echo # Expect "found"
205 --source include/search_pattern.inc
206 --remove_file $SEARCH_FILE
207 --list_files $MYSQLD_DATADIR1 ib_logfile*
208 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
209 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
210 --source include/start_mysqld.inc
211 SHOW TABLES FROM test;
212
213 # Upgraded succeeded, so now let's start again
214 --source include/kill_mysqld.inc
215 --force-rmdir $MYSQLD_DATADIR1
216 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
217
218 #--------------------------------------------------------
219 --echo # Crash after creating all log files:
220 #--------------------------------------------------------
221 --error 137,3
222 --exec $MYSQLD_CMD $recv_crash=11
223 let SEARCH_PATTERN=innodb_force_recovery_crash=11;
224 --echo # Expect "found"
225 --source include/search_pattern.inc
226 --remove_file $SEARCH_FILE
227 --list_files $MYSQLD_DATADIR1 ib_logfile*
228 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
229 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
230 --source include/start_mysqld.inc
231 SHOW TABLES FROM test;
232
233 # Upgraded succeeded, so now let's start again
234 --source include/kill_mysqld.inc
235 --force-rmdir $MYSQLD_DATADIR1
236 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
237
238 #--------------------------------------------------------
239 --echo # Crash after writing first checkpoint:
240 #--------------------------------------------------------
241 --error 137,3
242 --exec $MYSQLD_CMD $recv_crash=12
243 let SEARCH_PATTERN=innodb_force_recovery_crash=12;
244 --echo # Expect "found"
245 --source include/search_pattern.inc
246 --remove_file $SEARCH_FILE
247 --list_files $MYSQLD_DATADIR1 ib_logfile*
248 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
249 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
250 --source include/start_mysqld.inc
251 SHOW TABLES FROM test;
252
253 # Upgraded succeeded, so now let's start again
254 --source include/kill_mysqld.inc
255 --force-rmdir $MYSQLD_DATADIR1
256 --exec unzip -qo $ZIP_FILE -d $MYSQL_TMP_DIR
257
258 #--------------------------------------------------------
259 --echo # Crash after marking redo files as initialized:
260 #--------------------------------------------------------
261 --error 137,3
262 --exec $MYSQLD_CMD $recv_crash=13
263 let SEARCH_PATTERN=innodb_force_recovery_crash=13;
264 --echo # Expect "found"
265 --source include/search_pattern.inc
266 --remove_file $SEARCH_FILE
267 --list_files $MYSQLD_DATADIR1 ib_logfile*
268 --let $restart_parameters = restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
269 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1
270 --source include/start_mysqld.inc
271 SHOW TABLES FROM test;
272
273 # Upgraded succeeded, so now let's start again
274 --source include/kill_mysqld.inc
275 --force-rmdir $MYSQLD_DATADIR1
276
277 --echo
278
279 --echo #
280 --echo # Start MySQL after upgrade.
281 --echo #
282
283 let $restart_parameters = restart: --innodb-redo-log-capacity=15M;
284 --source include/start_mysqld.inc