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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
# Test different redo sys vars provided to the InnoDB on startup.
--source include/have_debug.inc
let MYSQLD_DATADIR = `select @@datadir`;
let $args=--datadir=$MYSQLD_DATADIR --log-error-verbosity=3;
--echo # Scenario 1
--echo # Ensure we do not allow recovery in read-only mode.
--echo #
--echo # Prepare non empty redo log and crash.
SET GLOBAL innodb_redo_log_capacity = 10*1024*1024;
SET GLOBAL innodb_monitor_enable = module_log;
SET GLOBAL innodb_page_cleaner_disabled_debug = 0;
SET GLOBAL innodb_checkpoint_disabled = 1;
CREATE TABLE t (a INT PRIMARY KEY) ENGINE = INNODB;
INSERT INTO t (a) VALUES (1);
--echo Expecting 1 as result of below query:
SELECT COUNT > 0 FROM INFORMATION_SCHEMA.INNODB_METRICS
WHERE NAME = 'log_lsn_checkpoint_age';
--source include/kill_mysqld.inc
--echo # Restart MySQL in read-only mode (the same redo capacity).
let MYSQLD_LOG_1= $MYSQLTEST_VARDIR/log/log_read_only-1.log;
--error 1,42
--exec $MYSQLD_CMD $args --innodb-read-only --innodb-redo-log-capacity=10M --log-error=$MYSQLD_LOG_1
let SEARCH_FILE= $MYSQLD_LOG_1;
let SEARCH_PATTERN= Can.t initiate database recovery, running in read-only-mode;
--source include/search_pattern.inc
--echo # Cleanup...
--source include/start_mysqld.inc
DROP TABLE t;
--echo # Scenario 2
--echo # Ensure we do not allow to resize redo log in read-only mode.
--echo #
--echo # Perform slow shutdown to ensure redo is empty.
SET GLOBAL innodb_fast_shutdown = 0;
--source include/shutdown_mysqld.inc
--echo # Restart MySQL in read-only mode (different redo log capacity).
let MYSQLD_LOG_2= $MYSQLTEST_VARDIR/log/log_read_only-2.log;
--replace_result $MYSQLD_LOG_2 MYSQLD_LOG_2
--let $restart_parameters = restart: --innodb-read-only --innodb-redo-log-capacity=8M --log-error=$MYSQLD_LOG_2
--source include/start_mysqld.inc
# Server had redo log files of 10M. User specified redo log capacity is printed but it has no effect.
--let SEARCH_FILE= $MYSQLD_LOG_2
--let SEARCH_PATTERN=Ignored the innodb-redo-log-capacity option in the Innodb read-only mode
--source include/search_pattern.inc
SELECT @@innodb_redo_log_capacity;
--let $restart_parameters =
SET GLOBAL innodb_fast_shutdown = 0;
--source include/shutdown_mysqld.inc
--echo # Scenario 3
--echo # Ensure to print warning in case --innodb_log_file_size is specified.
--echo #
let MYSQLD_LOG_3= $MYSQLTEST_VARDIR/log/log_read_only-3.log;
--replace_result $MYSQLD_LOG_3 MYSQLD_LOG_3
--let $restart_parameters = restart: --innodb-read-only --innodb_log_file_size=4194304 --log-error=$MYSQLD_LOG_3
--source include/start_mysqld.inc
--let SEARCH_FILE= $MYSQLD_LOG_3
--source include/search_pattern.inc
SET GLOBAL innodb_fast_shutdown = 0;
--source include/shutdown_mysqld.inc
--let $restart_parameters =
--echo # Scenario 4
--echo # Ensure to print warning in case --innodb_log_files_in_group is specified.
--echo #
let MYSQLD_LOG_4= $MYSQLTEST_VARDIR/log/log_read_only-4.log;
--replace_result $MYSQLD_LOG_4 MYSQLD_LOG_4
--let $restart_parameters = restart: --innodb-read-only --innodb_log_files_in_group=4 --log-error=$MYSQLD_LOG_4
--source include/start_mysqld.inc
--let SEARCH_FILE= $MYSQLD_LOG_4
--source include/search_pattern.inc
SET GLOBAL innodb_fast_shutdown = 0;
--source include/shutdown_mysqld.inc
--let $restart_parameters =
--echo # Scenario 5
--echo # Refuse to start in read-only mode without log files.
--echo #
--echo # Remove all redo log files.
--remove_files_wildcard $MYSQLD_DATADIR/#innodb_redo #ib_redo*
let MYSQLD_LOG_5= $MYSQLTEST_VARDIR/log/log_read_only-5.log;
--error 1,42
--exec $MYSQLD_CMD $args --innodb-read-only --log-error=$MYSQLD_LOG_5
let SEARCH_FILE= $MYSQLD_LOG_5;
let SEARCH_PATTERN= Cannot create redo log files in read-only mode;
--source include/search_pattern.inc
--echo # Cleanup...
--source include/start_mysqld.inc
--echo # Scenario 6
--echo # Restart MySQL in read-only mode
--echo # Ensure we do not allow to change the innodb_redo_log_capacity in read-only mode.
let MYSQLD_LOG_6=$MYSQLTEST_VARDIR/log/log_read_only-6.log;
let $restart_parameters = restart: --innodb-read-only=ON --log-error=$MYSQLD_LOG_6;
--source include/restart_mysqld_no_echo.inc
--echo # Try to set some random value to innodb_redo_log_capacity
--error ER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE
set global innodb_redo_log_capacity=60000000;
--echo # Try to set default value to innodb_redo_log_capacity
--error ER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE
set global innodb_redo_log_capacity=10485760;
--echo # Cleanup...
let $restart_parameters = restart;
--source include/restart_mysqld_no_echo.inc
# It might be useful to comment out code below, when debugging test failures
--remove_file $MYSQLD_LOG_1
--remove_file $MYSQLD_LOG_2
--remove_file $MYSQLD_LOG_3
--remove_file $MYSQLD_LOG_4
--remove_file $MYSQLD_LOG_5
--remove_file $MYSQLD_LOG_6
|
