| 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 |
|