Debian Codegraph @

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

raw
1 #
2 # Test the Redo-Log Archiving feature. Failure cases.
3 #
4
5 --disable_query_log
6 # When log-bin, skip-log-bin and binlog-format options are specified, mask the warning
7 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* You need to use --log-bin to make --binlog-format work.");
8 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
9 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
10 --enable_query_log
11
12 --let $saved_dirs = `SELECT @@global.innodb_redo_log_archive_dirs`
13 --let $MYSQLD_DATADIR = `SELECT @@datadir`
14 --let $SECURE_FILE_PRIV = `SELECT @@secure_file_priv`
15 --let $SERVER_UUID = `SELECT @@global.server_uuid`
16 --let $IRLA_FILENAME = archive.$SERVER_UUID.000001.log
17 --let $IRLA_DIRECTORY_1 = $MYSQLTEST_VARDIR/log/redo_log_archive_1
18 --let $IRLA_DIRECTORY_2 = $MYSQLTEST_VARDIR/log/redo_log_archive_2
19 --let $IRLA_PATHNAME_1 = $IRLA_DIRECTORY_1/$IRLA_FILENAME
20 --let $IRLA_PATHNAME_2 = $IRLA_DIRECTORY_2/$IRLA_FILENAME
21 --let $EXT_DIR = $MYSQLTEST_VARDIR/log
22
23 --echo #
24 --echo # Call innodb_redo_log_archive_start() and -stop() with wrong parameters.
25 --echo #
26 --error ER_CANT_INITIALIZE_UDF
27 DO innodb_redo_log_archive_start();
28 --error ER_CANT_INITIALIZE_UDF
29 DO innodb_redo_log_archive_start(NULL);
30 --error ER_CANT_INITIALIZE_UDF
31 DO innodb_redo_log_archive_start(1);
32 --error ER_CANT_INITIALIZE_UDF
33 DO innodb_redo_log_archive_start('', 1);
34 --error ER_CANT_INITIALIZE_UDF
35 DO innodb_redo_log_archive_start('', '', '');
36 --error ER_CANT_INITIALIZE_UDF
37 DO innodb_redo_log_archive_stop(NULL);
38 --error ER_CANT_INITIALIZE_UDF
39 DO innodb_redo_log_archive_stop(1);
40 --error ER_CANT_INITIALIZE_UDF
41 DO innodb_redo_log_archive_stop('');
42 --echo
43
44 --echo #
45 --echo # Unprivileged user cannot start nor stop redo log archiving.
46 --echo #
47 CREATE USER mysqltest_u1@localhost;
48 --echo [connection mysqltest_u1]
49 --connect (mysqltest_u1, localhost, mysqltest_u1,,)
50 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
51 DO innodb_redo_log_archive_start('label1');
52 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
53 DO innodb_redo_log_archive_stop();
54 --echo [connection default]
55 --connection default
56 --disconnect mysqltest_u1
57 DROP USER mysqltest_u1@localhost;
58 --echo
59
60 --echo #
61 --echo # NULL innodb_redo_log_archive_dirs.
62 --echo #
63 SET @@global.innodb_redo_log_archive_dirs = NULL;
64 --error ER_INNODB_REDO_LOG_ARCHIVE_DIRS_INVALID
65 DO innodb_redo_log_archive_start('label1');
66 --echo
67
68 --echo #
69 --echo # Empty innodb_redo_log_archive_dirs.
70 --echo #
71 SET @@global.innodb_redo_log_archive_dirs = '';
72 --error ER_INNODB_REDO_LOG_ARCHIVE_DIRS_INVALID
73 DO innodb_redo_log_archive_start('label1');
74 --echo
75
76 --echo #
77 --echo # Non-existen label.
78 --echo #
79 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
80 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
81 --error ER_INNODB_REDO_LOG_ARCHIVE_LABEL_NOT_FOUND
82 DO innodb_redo_log_archive_start('no-such-label');
83 --echo
84
85 --echo #
86 --echo # Subdir with path separator.
87 --echo #
88 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
89 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
90 --error ER_INNODB_REDO_LOG_ARCHIVE_START_SUBDIR_PATH
91 DO innodb_redo_log_archive_start('label1', 'tmp/tmp');
92 --echo
93
94 --echo #
95 --echo # Directory does not exist.
96 --echo #
97 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
98 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
99 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
100 --error ER_INNODB_REDO_LOG_ARCHIVE_NO_SUCH_DIR
101 DO innodb_redo_log_archive_start('label1');
102 --echo
103
104 --echo #
105 --echo # Directory is a file.
106 --echo #
107 --write_file $IRLA_DIRECTORY_1
108 EOF
109 # It is a file
110 --file_exists $IRLA_DIRECTORY_1
111 # It is not a directory
112 --error 1
113 --rmdir $IRLA_DIRECTORY_1
114 # Use it
115 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
116 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1';
117 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1
118 --error ER_INNODB_REDO_LOG_ARCHIVE_NO_SUCH_DIR
119 DO innodb_redo_log_archive_start('label1');
120 --remove_file $IRLA_DIRECTORY_1
121 --echo
122
123 --echo #
124 --echo # Directory clashes with server directories.
125 --echo #
126 --echo # Stop server
127 --echo #
128 --source include/shutdown_mysqld.inc
129 --echo #
130 --echo # Select unique path names for the server directories
131 --echo #
132 --let $INNODB_DATA_HOME_DIR = $EXT_DIR/innodb_data_home_dir
133 --let $INNODB_DIRECTORIES = $EXT_DIR/innodb_directories
134 --let $INNODB_LOG_GROUP_HOME_DIR = $EXT_DIR/innodb_log_group_home_dir
135 --let $INNODB_TEMP_TABLESPACES_DIR = $EXT_DIR/innodb_temp_tablespaces_dir
136 --let $INNODB_TMPDIR = $EXT_DIR/tmp/innodb_tmpdir
137 --let $INNODB_UNDO_DIRECTORY = $EXT_DIR/innodb_undo_directory
138 --echo #
139 --echo # Precautionary cleanup of the new server directories
140 --echo #
141 --error 0, 1
142 --force-rmdir $MYSQLD_DATADIR/xxx
143 --error 0, 1
144 --force-rmdir $INNODB_DATA_HOME_DIR
145 --error 0, 1
146 --force-rmdir $INNODB_DIRECTORIES
147 --error 0, 1
148 --force-rmdir $INNODB_LOG_GROUP_HOME_DIR/#innodb_redo
149 --error 0, 1
150 --force-rmdir $INNODB_LOG_GROUP_HOME_DIR
151 --error 0, 1
152 --force-rmdir $INNODB_TEMP_TABLESPACES_DIR
153 --error 0, 1
154 --force-rmdir $EXT_DIR/tmp
155 --error 0, 1
156 --force-rmdir $INNODB_UNDO_DIRECTORY
157 --error 0, 1
158 --force-rmdir $SECURE_FILE_PRIV/xxx
159 --echo #
160 --echo # Create the new server directories
161 --echo #
162 --mkdir $MYSQLD_DATADIR/xxx
163 --mkdir $INNODB_DATA_HOME_DIR
164 --mkdir $INNODB_DATA_HOME_DIR/xxx
165 --mkdir $INNODB_DIRECTORIES
166 --mkdir $INNODB_LOG_GROUP_HOME_DIR
167 --mkdir $INNODB_LOG_GROUP_HOME_DIR/#innodb_redo
168 --mkdir $INNODB_TEMP_TABLESPACES_DIR
169 --mkdir $EXT_DIR/tmp
170 --mkdir $INNODB_TMPDIR
171 --mkdir $INNODB_TMPDIR/xxx
172 --mkdir $INNODB_UNDO_DIRECTORY
173 --mkdir $SECURE_FILE_PRIV/xxx
174 --echo #
175 --echo # Move files from the default directories to the new server directories
176 --echo #
177 --move_file $MYSQLD_DATADIR/ibdata1 $INNODB_DATA_HOME_DIR/ibdata1
178 --move_file $MYSQLD_DATADIR/ib_buffer_pool $INNODB_DATA_HOME_DIR/ib_buffer_pool
179
180 --let MOVE_FILES_FROM = $MYSQLD_DATADIR/#innodb_redo/#ib_redo*
181 --let MOVE_FILES_TO = $INNODB_LOG_GROUP_HOME_DIR/#innodb_redo/
182 --source include/move_files.inc
183
184 --move_file $MYSQLD_DATADIR/undo_001 $INNODB_UNDO_DIRECTORY/undo_001
185 --move_file $MYSQLD_DATADIR/undo_002 $INNODB_UNDO_DIRECTORY/undo_002
186 --echo #
187 --echo # Restart the server with the new server directories
188 --echo #
189 --let $restart_parameters="restart: --innodb_data_home_dir=$INNODB_DATA_HOME_DIR --innodb_directories=$INNODB_DIRECTORIES --innodb_log_group_home_dir=$INNODB_LOG_GROUP_HOME_DIR --innodb_temp_tablespaces_dir=$INNODB_TEMP_TABLESPACES_DIR --innodb_tmpdir=$INNODB_TMPDIR --innodb_undo_directory=$INNODB_UNDO_DIRECTORY"
190 --source include/start_mysqld_no_echo.inc
191 --echo #
192 --echo # Set innodb_redo_log_archive_dirs to the server directories
193 --echo #
194 --echo
195 --echo
196 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $SECURE_FILE_PRIV SECURE_FILE_PRIV
197 eval SET @@global.innodb_redo_log_archive_dirs = '1:$MYSQLD_DATADIR/xxx;2:$INNODB_DATA_HOME_DIR/xxx;3:$INNODB_DIRECTORIES;4:$INNODB_LOG_GROUP_HOME_DIR;5:$INNODB_TEMP_TABLESPACES_DIR;6:$EXT_DIR/tmp;7:$INNODB_TMPDIR/xxx;8:$INNODB_UNDO_DIRECTORY;9:$SECURE_FILE_PRIV/xxx';
198 --echo #
199 --echo # Try to start redo log archiving with each of the server directories
200 --echo #
201 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
202 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
203 DO innodb_redo_log_archive_start('1');
204 #
205 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
206 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
207 DO innodb_redo_log_archive_start('2');
208 #
209 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
210 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
211 DO innodb_redo_log_archive_start('3');
212 #
213 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
214 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
215 DO innodb_redo_log_archive_start('4');
216 #
217 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
218 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
219 DO innodb_redo_log_archive_start('5');
220 #
221 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
222 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
223 DO innodb_redo_log_archive_start('6');
224 #
225 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
226 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
227 DO innodb_redo_log_archive_start('7');
228 #
229 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
230 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
231 DO innodb_redo_log_archive_start('8');
232 #
233 --replace_result $SECURE_FILE_PRIV SECURE_FILE_PRIV
234 --error ER_INNODB_REDO_LOG_ARCHIVE_DIR_CLASH
235 DO innodb_redo_log_archive_start('9');
236 --echo #
237 --echo # Stop server
238 --echo #
239 --source include/shutdown_mysqld.inc
240 --echo #
241 --echo # Move files back to the default directories
242 --echo #
243 --move_file $INNODB_DATA_HOME_DIR/ibdata1 $MYSQLD_DATADIR/ibdata1
244 --move_file $INNODB_DATA_HOME_DIR/ib_buffer_pool $MYSQLD_DATADIR/ib_buffer_pool
245
246 --let MOVE_FILES_FROM = $INNODB_LOG_GROUP_HOME_DIR/#innodb_redo/#ib_redo*
247 --let MOVE_FILES_TO = $MYSQLD_DATADIR/#innodb_redo/
248 --source include/move_files.inc
249
250 --move_file $INNODB_UNDO_DIRECTORY/undo_001 $MYSQLD_DATADIR/undo_001
251 --move_file $INNODB_UNDO_DIRECTORY/undo_002 $MYSQLD_DATADIR/undo_002
252 --echo #
253 --echo # Remove the new server directories
254 --echo #
255 --rmdir $SECURE_FILE_PRIV/xxx
256 --rmdir $INNODB_UNDO_DIRECTORY
257 --rmdir $INNODB_TMPDIR/xxx
258 --rmdir $INNODB_TMPDIR
259 --rmdir $EXT_DIR/tmp
260 --rmdir $INNODB_TEMP_TABLESPACES_DIR
261 --rmdir $INNODB_LOG_GROUP_HOME_DIR/#innodb_redo
262 --rmdir $INNODB_LOG_GROUP_HOME_DIR
263 --rmdir $INNODB_DIRECTORIES
264 --rmdir $INNODB_DATA_HOME_DIR/xxx
265 --rmdir $INNODB_DATA_HOME_DIR
266 --rmdir $MYSQLD_DATADIR/xxx
267 --echo #
268 --echo # Restart the server with default directories
269 --echo #
270 --let $restart_parameters="restart:"
271 --source include/start_mysqld_no_echo.inc
272 --echo
273
274 --echo #
275 --echo # Set innodb_redo_log_archive_dirs for the following tests.
276 --echo #
277 --replace_result $IRLA_DIRECTORY_1 IRLA_DIRECTORY_1 $IRLA_DIRECTORY_2 IRLA_DIRECTORY_2
278 eval SET @@global.innodb_redo_log_archive_dirs = 'label1:$IRLA_DIRECTORY_1;label2:$IRLA_DIRECTORY_2';
279 --echo
280
281 --echo #
282 --echo # Create the redo log archive directory for the following tests.
283 --echo #
284 --mkdir $IRLA_DIRECTORY_1
285 --mkdir $IRLA_DIRECTORY_2
286 --echo
287
288 --echo #
289 --echo # Create connection con1 for the following tests.
290 --echo #
291 --connect(con1,localhost,root,,)
292 --connection default
293 --echo
294
295 --echo #
296 --echo # Start with active logging.
297 --echo #
298 DO innodb_redo_log_archive_start('label1');
299 --replace_result $IRLA_PATHNAME_1 IRLA_PATHNAME_1
300 --replace_regex /[\\]/\//
301 --error ER_INNODB_REDO_LOG_ARCHIVE_ACTIVE
302 DO innodb_redo_log_archive_start('label1');
303 DO innodb_redo_log_archive_stop();
304 --remove_file $IRLA_PATHNAME_1
305 --echo
306
307 --echo #
308 --echo # Stop with inactive logging.
309 --echo #
310 --error ER_INNODB_REDO_LOG_ARCHIVE_INACTIVE
311 DO innodb_redo_log_archive_stop();
312 --echo
313
314 --echo #
315 --echo # Start with active logging from other session.
316 --echo #
317 DO innodb_redo_log_archive_start('label1');
318 --echo [connection con1]
319 --connection con1
320 --replace_result $IRLA_PATHNAME_1 IRLA_PATHNAME_1
321 --replace_regex /[\\]/\//
322 --error ER_INNODB_REDO_LOG_ARCHIVE_ACTIVE
323 DO innodb_redo_log_archive_start('label2');
324 --echo [connection default]
325 --connection default
326 DO innodb_redo_log_archive_stop();
327 --remove_file $IRLA_PATHNAME_1
328 --echo
329
330 --echo #
331 --echo # Stop from wrong session
332 --echo #
333 DO innodb_redo_log_archive_start('label1');
334 --echo [connection con1]
335 --connection con1
336 --error ER_INNODB_REDO_LOG_ARCHIVE_SESSION
337 DO innodb_redo_log_archive_stop();
338 --echo [connection default]
339 --connection default
340 DO innodb_redo_log_archive_stop();
341 --remove_file $IRLA_PATHNAME_1
342 --echo
343
344 --echo #
345 --echo # Session ends without stop
346 --echo #
347 --echo [connection con1]
348 --connection con1
349 DO innodb_redo_log_archive_start('label1');
350 --echo # Redo log archive file exists
351 --file_exists $IRLA_PATHNAME_1
352 --echo #
353 --echo # Disconnect con1
354 --echo #
355 --disconnect con1
356 --source include/wait_until_disconnected.inc
357 --echo [connection default]
358 --connection default
359 --echo # Redo log archive file does not exist any more
360 --error 1
361 --file_exists $IRLA_PATHNAME_1
362 --echo
363
364 --echo #
365 --echo # Stop after error - reports the previous error
366 --echo #
367 --error ER_INNODB_REDO_LOG_ARCHIVE_FAILED
368 DO innodb_redo_log_archive_stop();
369 --echo
370
371 --echo #
372 --echo # File exists
373 --echo #
374 --echo # Create a file with the name of the redo log archive file
375 --echo #
376 --write_file $IRLA_PATHNAME_1
377 EOF
378 --replace_result $IRLA_PATHNAME_1 IRLA_PATHNAME_1
379 --replace_regex /[\\]/\// /OS errno: .*/OS errno: ## - ###)/
380 --error ER_INNODB_REDO_LOG_ARCHIVE_FILE_CREATE
381 DO innodb_redo_log_archive_start('label1');
382 --remove_file $IRLA_PATHNAME_1
383 --echo
384
385 --echo #
386 --echo # Call redo log archiving start & stop repeatedly
387 --echo # This could catch race conditions between start and stop.
388 --echo #
389 --LET $i = 20
390 WHILE($i > 0) {
391 DO innodb_redo_log_archive_start("label1");
392 DO innodb_redo_log_archive_stop();
393 --remove_file $IRLA_PATHNAME_1
394 --dec $i
395 }
396 --echo
397
398 --echo #
399 --echo # Try to disable redo logging from other session.
400 --echo #
401 DO innodb_redo_log_archive_start('label1');
402 --echo
403 --error ER_INNODB_REDO_ARCHIVING_ENABLED
404 ALTER INSTANCE DISABLE INNODB REDO_LOG;
405 --echo
406 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
407 --echo
408 DO innodb_redo_log_archive_stop();
409 --remove_file $IRLA_PATHNAME_1
410 --echo
411
412 --echo #
413 --echo # Try to start redo archiving when Innodb redo logging is diabled
414 --echo #
415 ALTER INSTANCE DISABLE INNODB REDO_LOG;
416 --echo
417 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
418 --echo
419 --error ER_INNODB_REDO_DISABLED
420 DO innodb_redo_log_archive_start('label1');
421 --echo
422 ALTER INSTANCE ENABLE INNODB REDO_LOG;
423 --echo
424 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
425 --echo
426
427 --echo #
428 --echo # Cleanup
429 --echo #
430 --rmdir $IRLA_DIRECTORY_2
431 --rmdir $IRLA_DIRECTORY_1
432 eval SET @@global.innodb_redo_log_archive_dirs = '$saved_dirs';