Debian Codegraph @

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

raw
1 --source log_pre_8_0_30_case_begin.inc
2
3 --echo ############################################################################################
4 --echo # Case 1: Attempt to start after clean shutdown on mysql-$TESTED_DATADIR_VERSION.
5 --echo # Pre-conditions: logically empty redo files from mysql-$TESTED_DATADIR_VERSION.
6 if ($LOG_ALLOW_UPGRADE == 0) {
7 --echo # 1A: InnoDB refuses to start because of the too old redo log format.
8 }
9 if ($LOG_ALLOW_UPGRADE == 1) {
10 --echo # 1A: InnoDB successfully upgrades and starts.
11 }
12 --echo # 1B: InnoDB refuses to start with innodb-force-recovery = 1 or 6.
13 --echo # 1C: InnoDB refuses to start with innodb-read-only = ON.
14 --echo ############################################################################################
15
16 let $i = 1;
17 while ($i <= 2) {
18 --remove_file $SEARCH_FILE
19
20 --echo # Case 1A: Start MySQL... (attempt $i)
21 --error 1,42
22 --exec $MYSQLD_CMD $MYSQLD_ARGS --$UNKNOWN_PARAM
23
24 --echo # Verify...
25
26 let SEARCH_PATTERN = $LOG_FORMAT_MESSAGE;
27 # Expected: found unless upgraded
28 --source include/search_pattern.inc
29
30 let SEARCH_PATTERN = Redo log is from an earlier version;
31 # Expected: found unless upgraded
32 --source include/search_pattern.inc
33
34 let SEARCH_PATTERN = The latest found checkpoint is at lsn =;
35 # Expected: not found, unless $LOG_ALLOW_UPGRADE == 1
36 --source include/search_pattern.inc
37
38 let SEARCH_PATTERN = Upgrading redo log: .*, LSN=;
39 # Expected: not found, unless $LOG_ALLOW_UPGRADE == 1
40 --source include/search_pattern.inc
41
42 let SEARCH_PATTERN = $PATTERN_UNKNOWN_PARAM;
43 # Expected: not found, unless $LOG_ALLOW_UPGRADE == 1
44 --source include/search_pattern.inc
45
46 inc $i;
47 }
48
49 if ($LOG_ALLOW_UPGRADE == 1) {
50 --echo # Redo log has become upgraded - replacing with older (from before upgrade)...
51 --source log_pre_8_0_30_case_end.inc
52 --source log_pre_8_0_30_case_begin.inc
53 }
54
55 --echo ############################################################################################
56
57 let $i = 1;
58 while ($i <= 2) {
59 --remove_file $SEARCH_FILE
60
61 if ($i == 1) {
62 let $force_recovery = 1;
63 }
64 if ($i == 2) {
65 let $force_recovery = 6;
66 }
67
68 --echo # Case 1B-$i: Start MySQL with --innodb-force-recovery=$force_recovery...
69 --error 1,42
70 --exec $MYSQLD_CMD $MYSQLD_ARGS --innodb-force-recovery=$force_recovery --$UNKNOWN_PARAM
71
72 --echo # Verify...
73
74 let SEARCH_PATTERN = Database upgrade cannot be accomplished with innodb_force_recovery > 0;
75 # Expected: found
76 --source include/search_pattern.inc
77
78 let SEARCH_PATTERN = Cannot upgrade format .* of redo log files when innodb-force-recovery > 0;
79 --source include/search_pattern.inc
80
81 let SEARCH_PATTERN = The latest found checkpoint is at lsn =;
82 # Expected: not found
83 --source include/search_pattern.inc
84
85 inc $i;
86 }
87
88 --echo ############################################################################################
89
90 --remove_file $SEARCH_FILE
91
92 --echo # Case 1C: Start MySQL with innodb-read-only=ON...
93 --error 1,42
94 --exec $MYSQLD_CMD $MYSQLD_ARGS --innodb-read-only=ON
95
96 --echo # Verify...
97
98 let SEARCH_PATTERN = Database upgrade cannot be accomplished in read-only mode;
99 # Expected: found
100 --source include/search_pattern.inc
101
102 let SEARCH_PATTERN = The latest found checkpoint is at lsn =;
103 # Expected: not found
104 --source include/search_pattern.inc
105
106 --echo ############################################################################################
107 --source log_pre_8_0_30_case_end.inc