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