Debian Codegraph @

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

raw
1 # Test Enable and Disable redo logging
2
3 --disable_query_log
4 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
5 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
6 --enable_query_log
7
8 --echo #1. Check Redo logging syntax and status
9 SHOW STATUS LIKE 'Innodb_redo_log_enabled';
10 --echo
11 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
12 --echo
13
14 ALTER INSTANCE DISABLE INNODB REDO_LOG;
15 --echo
16
17 SHOW STATUS LIKE 'Innodb_redo_log_enabled';
18 --echo
19 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
20 --echo
21
22 ALTER INSTANCE ENABLE INNODB REDO_LOG;
23 --echo
24
25 SHOW STATUS LIKE 'Innodb_redo_log_enabled';
26 --echo
27 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
28 --echo
29
30 --echo #2. Check privilege
31 CREATE USER 'user_redo'@'localhost' IDENTIFIED BY '123';
32 --echo
33 GRANT SELECT ON performance_schema.* to 'user_redo'@'localhost';
34 --echo
35
36 --connect (con1,'localhost','user_redo','123',)
37
38 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
39 ALTER INSTANCE DISABLE INNODB REDO_LOG;
40 --echo
41 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
42 --echo
43
44 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
45 ALTER INSTANCE ENABLE INNODB REDO_LOG;
46 --echo
47
48 --connection default
49 GRANT INNODB_REDO_LOG_ENABLE ON *.* TO 'user_redo'@'localhost';
50 --echo
51
52 --connection con1
53
54 ALTER INSTANCE DISABLE INNODB REDO_LOG;
55 --echo
56 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
57 --echo
58
59 ALTER INSTANCE ENABLE INNODB REDO_LOG;
60 --echo
61 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
62 --echo
63
64 --connection default
65 --disconnect con1
66 DROP USER 'user_redo'@'localhost';
67 --echo
68
69 --echo #3. Check basic DDL and DML when redo logging is disabled
70 ALTER INSTANCE DISABLE INNODB REDO_LOG;
71 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
72
73 --let check_dd = 0
74 --let NO_EXT_PATH = 1
75
76 --let $check_option = CREATE
77 --source suite/innodb/include/partition_upgrade_check.inc
78
79 ALTER INSTANCE ENABLE INNODB REDO_LOG;
80 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
81 --let $check_option = DML
82 --source suite/innodb/include/partition_upgrade_check.inc
83
84 ALTER INSTANCE DISABLE INNODB REDO_LOG;
85 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
86
87 --let $check_option = DROP
88 --source suite/innodb/include/partition_upgrade_check.inc
89
90 --let $check_option = CREATE
91 --source suite/innodb/include/partition_upgrade_check.inc
92
93 --let $check_option = DML
94 --source suite/innodb/include/partition_upgrade_check.inc
95
96 --echo #3A. Check shutdown and restart
97 let SEARCH_FILE = $MYSQLTEST_VARDIR/log/my_restart.err;
98 --echo # Restart the server with --log-error
99 --replace_result $SEARCH_FILE SEARCH_FILE
100 --let $restart_parameters = restart: --log-error=$SEARCH_FILE --no-console
101 --source include/restart_mysqld.inc
102
103 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
104
105 --let $check_option = DROP
106 --source suite/innodb/include/partition_upgrade_check.inc
107
108 --let $check_option = CREATE
109 --source suite/innodb/include/partition_upgrade_check.inc
110
111 --let $check_option = DML
112 --source suite/innodb/include/partition_upgrade_check.inc
113
114 --let $check_option = DDL
115 --source suite/innodb/include/partition_upgrade_check.inc
116
117 --echo #3B. Check shutdown and restart with innodb_fast_shutdown = 2
118 SET GLOBAL innodb_fast_shutdown = 2;
119 --let $restart_parameters = restart:
120 --source include/restart_mysqld.inc
121
122 --let SEARCH_PATTERN=\\[Warning\\] .*MY-\\d+.* InnoDB cannot do cold shutdown 'innodb_fast_shutdown = 2' and is forcing 'innodb_fast_shutdown = 1' as redo logging is disabled. InnoDB would flush all dirty pages to ensure physical data consistency.
123 --source include/search_pattern.inc
124 --remove_file $SEARCH_FILE
125
126 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
127
128 --echo #3C. Check shutdown and restart with innodb-read-only
129 --source include/add_mtr_suppression_for_innodb_readonly.inc
130 --let $restart_parameters = restart: --innodb-read-only
131 --source include/restart_mysqld.inc
132
133 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';
134
135 --let $restart_parameters = restart:
136 --source include/restart_mysqld.inc
137
138 # Avoid printing tables names in capital letters for case insensitive platforms
139 --let $check_option = CHECK
140 --source suite/innodb/include/partition_upgrade_check.inc
141
142 --let $check_option = DROP
143 --source suite/innodb/include/partition_upgrade_check.inc
144
145 ALTER INSTANCE ENABLE INNODB REDO_LOG;
146
147 SELECT * FROM performance_schema.global_status WHERE variable_name like 'Innodb_redo_log_enabled';