Debian Codegraph @

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

raw
1 # Test different redo sys vars provided to the InnoDB on startup.
2
3 --source include/have_debug.inc
4
5 let MYSQLD_DATADIR = `select @@datadir`;
6 let $args=--datadir=$MYSQLD_DATADIR --log-error-verbosity=3;
7
8 --echo # Scenario 1
9 --echo # Ensure we do not allow recovery in read-only mode.
10 --echo #
11 --echo # Prepare non empty redo log and crash.
12
13 SET GLOBAL innodb_redo_log_capacity = 10*1024*1024;
14
15 SET GLOBAL innodb_monitor_enable = module_log;
16 SET GLOBAL innodb_page_cleaner_disabled_debug = 0;
17 SET GLOBAL innodb_checkpoint_disabled = 1;
18
19 CREATE TABLE t (a INT PRIMARY KEY) ENGINE = INNODB;
20 INSERT INTO t (a) VALUES (1);
21
22 --echo Expecting 1 as result of below query:
23 SELECT COUNT > 0 FROM INFORMATION_SCHEMA.INNODB_METRICS
24 WHERE NAME = 'log_lsn_checkpoint_age';
25
26 --source include/kill_mysqld.inc
27
28 --echo # Restart MySQL in read-only mode (the same redo capacity).
29 let MYSQLD_LOG_1= $MYSQLTEST_VARDIR/log/log_read_only-1.log;
30 --error 1,42
31 --exec $MYSQLD_CMD $args --innodb-read-only --innodb-redo-log-capacity=10M --log-error=$MYSQLD_LOG_1
32 let SEARCH_FILE= $MYSQLD_LOG_1;
33 let SEARCH_PATTERN= Can.t initiate database recovery, running in read-only-mode;
34 --source include/search_pattern.inc
35
36 --echo # Cleanup...
37 --source include/start_mysqld.inc
38 DROP TABLE t;
39
40 --echo # Scenario 2
41 --echo # Ensure we do not allow to resize redo log in read-only mode.
42 --echo #
43 --echo # Perform slow shutdown to ensure redo is empty.
44
45 SET GLOBAL innodb_fast_shutdown = 0;
46 --source include/shutdown_mysqld.inc
47
48 --echo # Restart MySQL in read-only mode (different redo log capacity).
49 let MYSQLD_LOG_2= $MYSQLTEST_VARDIR/log/log_read_only-2.log;
50 --replace_result $MYSQLD_LOG_2 MYSQLD_LOG_2
51 --let $restart_parameters = restart: --innodb-read-only --innodb-redo-log-capacity=8M --log-error=$MYSQLD_LOG_2
52 --source include/start_mysqld.inc
53 # Server had redo log files of 10M. User specified redo log capacity is printed but it has no effect.
54 --let SEARCH_FILE= $MYSQLD_LOG_2
55 --let SEARCH_PATTERN=Ignored the innodb-redo-log-capacity option in the Innodb read-only mode
56 --source include/search_pattern.inc
57 SELECT @@innodb_redo_log_capacity;
58 --let $restart_parameters =
59 SET GLOBAL innodb_fast_shutdown = 0;
60 --source include/shutdown_mysqld.inc
61
62 --echo # Scenario 3
63 --echo # Ensure to print warning in case --innodb_log_file_size is specified.
64 --echo #
65 let MYSQLD_LOG_3= $MYSQLTEST_VARDIR/log/log_read_only-3.log;
66 --replace_result $MYSQLD_LOG_3 MYSQLD_LOG_3
67 --let $restart_parameters = restart: --innodb-read-only --innodb_log_file_size=4194304 --log-error=$MYSQLD_LOG_3
68 --source include/start_mysqld.inc
69 --let SEARCH_FILE= $MYSQLD_LOG_3
70 --source include/search_pattern.inc
71 SET GLOBAL innodb_fast_shutdown = 0;
72 --source include/shutdown_mysqld.inc
73 --let $restart_parameters =
74
75 --echo # Scenario 4
76 --echo # Ensure to print warning in case --innodb_log_files_in_group is specified.
77 --echo #
78 let MYSQLD_LOG_4= $MYSQLTEST_VARDIR/log/log_read_only-4.log;
79 --replace_result $MYSQLD_LOG_4 MYSQLD_LOG_4
80 --let $restart_parameters = restart: --innodb-read-only --innodb_log_files_in_group=4 --log-error=$MYSQLD_LOG_4
81 --source include/start_mysqld.inc
82 --let SEARCH_FILE= $MYSQLD_LOG_4
83 --source include/search_pattern.inc
84 SET GLOBAL innodb_fast_shutdown = 0;
85 --source include/shutdown_mysqld.inc
86 --let $restart_parameters =
87
88 --echo # Scenario 5
89 --echo # Refuse to start in read-only mode without log files.
90 --echo #
91 --echo # Remove all redo log files.
92 --remove_files_wildcard $MYSQLD_DATADIR/#innodb_redo #ib_redo*
93 let MYSQLD_LOG_5= $MYSQLTEST_VARDIR/log/log_read_only-5.log;
94 --error 1,42
95 --exec $MYSQLD_CMD $args --innodb-read-only --log-error=$MYSQLD_LOG_5
96 let SEARCH_FILE= $MYSQLD_LOG_5;
97 let SEARCH_PATTERN= Cannot create redo log files in read-only mode;
98 --source include/search_pattern.inc
99
100 --echo # Cleanup...
101 --source include/start_mysqld.inc
102
103 --echo # Scenario 6
104 --echo # Restart MySQL in read-only mode
105 --echo # Ensure we do not allow to change the innodb_redo_log_capacity in read-only mode.
106 let MYSQLD_LOG_6=$MYSQLTEST_VARDIR/log/log_read_only-6.log;
107 let $restart_parameters = restart: --innodb-read-only=ON --log-error=$MYSQLD_LOG_6;
108 --source include/restart_mysqld_no_echo.inc
109 --echo # Try to set some random value to innodb_redo_log_capacity
110 --error ER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE
111 set global innodb_redo_log_capacity=60000000;
112 --echo # Try to set default value to innodb_redo_log_capacity
113 --error ER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE
114 set global innodb_redo_log_capacity=10485760;
115
116 --echo # Cleanup...
117 let $restart_parameters = restart;
118 --source include/restart_mysqld_no_echo.inc
119
120 # It might be useful to comment out code below, when debugging test failures
121 --remove_file $MYSQLD_LOG_1
122 --remove_file $MYSQLD_LOG_2
123 --remove_file $MYSQLD_LOG_3
124 --remove_file $MYSQLD_LOG_4
125 --remove_file $MYSQLD_LOG_5
126 --remove_file $MYSQLD_LOG_6
127