Debian Codegraph @

mysql-test/suite/innodb/include/log_pre_8_0_30_case2.inc

raw
1 --source log_pre_8_0_30_case_begin.inc
2
3 --echo ############################################################################################
4 --echo # Case 2: Attempt to start with invalid set of redo log files.
5 --echo # 2A: InnoDB refuses to start if ib_logfile1 was removed
6 --echo # 2B: InnoDB refuses to start if ib_logfile0 was removed
7 --echo # 2C: InnoDB refuses to start if both redo files were removed
8 --echo # NOTE: Ensure there was no attempt to check if redo is empty.
9 --echo ############################################################################################
10
11 --remove_file $SEARCH_FILE
12
13 --echo # Hide the ib_logfile1...
14 --move_file $MYSQLD_DATADIR/ib_logfile1 $MYSQLD_DATADIR/tmp_ib_logfile1
15
16 --echo # Case 2A: Start MySQL...
17 --error 1,42
18 --exec $MYSQLD_CMD $MYSQLD_ARGS --$UNKNOWN_PARAM
19
20 --echo # Verify...
21
22 let SEARCH_PATTERN = Only one redo log file found;
23 # Expected: found
24 --source include/search_pattern.inc
25
26 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
27 # Expected: not found
28 --source include/search_pattern.inc
29
30 --echo # Restore the ib_logfile1...
31 --move_file $MYSQLD_DATADIR/tmp_ib_logfile1 $MYSQLD_DATADIR/ib_logfile1
32
33 --echo ############################################################################################
34
35 --remove_file $SEARCH_FILE
36
37 --echo # Hide the ib_logfile0...
38 --move_file $MYSQLD_DATADIR/ib_logfile0 $MYSQLD_DATADIR/tmp_ib_logfile0
39
40 --echo # Case 2B: Start MySQL...
41 --error 1,42
42 --exec $MYSQLD_CMD $MYSQLD_ARGS --$UNKNOWN_PARAM
43
44 --echo # Verify...
45
46 let SEARCH_PATTERN = Missing ib_logfile0 in the directory;
47 # Expected: found
48 --source include/search_pattern.inc
49
50 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
51 # Expected: not found
52 --source include/search_pattern.inc
53
54 --echo # Restore the ib_logfile0...
55 --move_file $MYSQLD_DATADIR/tmp_ib_logfile0 $MYSQLD_DATADIR/ib_logfile0
56
57 --echo ############################################################################################
58
59 --remove_file $SEARCH_FILE
60
61 --echo # Hide both redo log files (ib_logfile0 and ib_logfile1)...
62
63 --move_file $MYSQLD_DATADIR/ib_logfile0 $MYSQLD_DATADIR/tmp_ib_logfile0
64 --move_file $MYSQLD_DATADIR/ib_logfile1 $MYSQLD_DATADIR/tmp_ib_logfile1
65
66 --echo # Case 2C: Start MySQL...
67 --error 1,42
68 --exec $MYSQLD_CMD $MYSQLD_ARGS --$UNKNOWN_PARAM
69
70 --echo # Verify...
71
72 let SEARCH_PATTERN = Neither found .* subdirectory, nor .* files;
73 # Expected: found
74 --source include/search_pattern.inc
75
76 # Expected: not found
77 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
78 --source include/search_pattern.inc
79
80 --echo # Restore both redo log files (ib_logfile0 and ib_logfile1)...
81
82 --move_file $MYSQLD_DATADIR/tmp_ib_logfile1 $MYSQLD_DATADIR/ib_logfile1
83 --move_file $MYSQLD_DATADIR/tmp_ib_logfile0 $MYSQLD_DATADIR/ib_logfile0
84
85 --echo ############################################################################################
86 --source log_pre_8_0_30_case_end.inc