Debian Codegraph @

mysql-test/suite/group_replication/t/gr_recovery_slave_commands.test

raw
1 ###############################################################################
2 # BUG 21626827 - SOME COMMAND SHOULD NOT BE ALLOWED FOR CHANNEL
3 # 'GROUP_REPLICATION_RECOVERY'
4 #
5 # This test checks to see that user should not be allowed to execute
6 # set of commands for the group_replication_recovery channel.
7 #
8 # Bug 23591186 - WL#9053 : MODIFY MTR TESTS TO VERIFY BEHAVIOR OF
9 # 'GROUP_REPLICATION_RECOVERY'
10 # The test is extended to check the behavior when MEMBER is in RECOVERING,
11 # ONLINE, OFFLINE states.
12 #
13 # The commands being checked here are :
14 # 1. START SLAVE IO_THREAD
15 # 2. STOP SLAVE IO_THREAD
16 # 3. START SLAVE FOR CHANNEL
17 # 4. STOP SLAVE FOR CHANNEL
18 # 5. START SLAVE SQL_THREAD
19 # 6. STOP SLAVE SQL_THREAD
20 # 7. SHOW SLAVE STATUS
21 # 8. SHOW RELAYLOG EVENTS
22 # 9. FLUSH RELAY LOGS
23 # 10. RESET SLAVE
24 # 11. RESET SLAVE ALL
25 #
26 # Test:
27 # 0. The test requires two servers: M1 and M2.
28 #
29 # 1. Bootstrap start GR on M1. Test above mentioned 11 RPL(slave) commands
30 # for recovery channel:-
31 # - MEMBER_STATE: ONLINE and recovery channel is ABSENT.
32 # - Expect ER_REPLICA_CHANNEL_DOES_NOT_EXIST.
33 #
34 # 2. Add some data for recovery on M1. Start GR on M2. Test above mentioned
35 # 11 RPL(slave) commands for recovery channel:-
36 # - MEMBER_STATE: ONLINE and recovery channel is PRESENT but INACTIVE.
37 # - Expect ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED in most of the cases.
38 #
39 # 3. Stop GR on M2. Add data on M1. Lock table on M2 to block recovery.
40 # Start GR on M2.
41 #
42 # 4. Now when M2 is in RECOVERING state, test above mentioned 11 RPL(slave)
43 # commands on recovery channel:-
44 # - MEMBER_STATE: RECOVERING and recovery channel is ACTIVE.
45 # - Expect ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED in most of the cases.
46 #
47 # 5. Unlock tables on M2 and drop table t1 on M1. Stop GR on M2. Test above
48 # mentioned 11 RPL(slave) commands:-
49 # - MEMBER_STATE: OFFLINE and recovery channel is PRESENT but INACTIVE.
50 # - Expect ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED in most of the cases.
51 ###############################################################################
52
53 # Skip configuration of recovery channel
54
55 --source include/big_test.inc
56 --source include/have_group_replication_xcom_communication_stack.inc
57 --let $skip_recovery_configuration = 1
58 --source include/have_group_replication_plugin.inc
59 --let $rpl_skip_group_replication_start= 1
60 --source include/group_replication.inc
61
62 # Phase 1
63 --echo
64 --echo # Bootstrap start GR on M1 and test commands for recovery channel
65 --echo # when MEMBER_STATE: ONLINE and recovery channel is ABSENT
66
67 --let $rpl_connection_name= server1
68 --source include/rpl_connection.inc
69 set session sql_log_bin=0;
70 call mtr.add_suppression("Replica channel 'group_replication_recovery' does not exist.*");
71 set session sql_log_bin=1;
72
73 --source include/start_and_bootstrap_group_replication.inc
74
75 --echo
76 --echo # CHM for 'group_replication_recovery' channel won't accept parameters other than
77 --echo # MASTER_USER and MASTER_PASSWORD
78 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
79 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_recovery";
80
81 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
82 CHANGE REPLICATION SOURCE TO SOURCE_TLS_CIPHERSUITES="foo" FOR CHANNEL "group_replication_recovery";
83
84 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
85 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_recovery";
86
87 --echo
88 --echo # ERROR when executing STOP SLAVE on GR recovery channel
89 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
90 STOP SLAVE FOR CHANNEL 'group_replication_recovery';
91
92 --echo
93 --echo # ERROR when executing START SLAVE on GR recovery channel
94 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
95 START SLAVE FOR CHANNEL 'group_replication_recovery';
96
97 --echo
98 --echo # ERROR when executing STOP SLAVE IO_THREAD on GR recovery channel
99 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
100 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
101
102 --echo
103 --echo # ERROR when executing START SLAVE IO_THREAD on GR recovery channel
104 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
105 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
106
107 --echo
108 --echo # ERROR when executing STOP SLAVE SQL_THREAD on GR recovery channel
109 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
110 STOP SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
111
112 --echo
113 --echo # ERROR when executing START SLAVE SQL_THREAD on GR recovery channel
114 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
115 START SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
116
117 --echo
118 --echo # ERROR when executing SHOW SLAVE STATUS on GR recovery channel
119 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
120 --query_vertical SHOW SLAVE STATUS FOR CHANNEL 'group_replication_recovery'
121
122 --echo
123 --echo # ERROR when executing SHOW RELAYLOG EVENTS on GR recovery channel
124 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
125 SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_recovery';
126
127 --echo
128 --echo # ERROR when executing FLUSH RELAY LOGS on GR recovery channel
129 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
130 FLUSH RELAY LOGS FOR CHANNEL 'group_replication_recovery';
131
132 --echo
133 --echo # ERROR when executing RESET SLAVE command on GR recovery channel
134 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
135 RESET SLAVE FOR CHANNEL "group_replication_recovery";
136
137 --echo
138 --echo # ERROR when executing RESET SLAVE ALL command on GR recovery channel
139 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
140 RESET SLAVE ALL FOR CHANNEL "group_replication_recovery";
141
142 # Phase 2
143 --echo
144 --echo # Add some data for recovery on M1. Start GR on M2.
145
146 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
147 INSERT INTO t1 VALUES (1);
148
149 --let $rpl_connection_name= server2
150 --source include/rpl_connection.inc
151
152 set session sql_log_bin=0;
153 call mtr.add_suppression("Transaction cannot be executed while Group Replication is recovering.*");
154 call mtr.add_suppression("Run function 'before_commit' in plugin 'group_replication' failed");
155 set session sql_log_bin=1;
156
157 --disable_warnings
158 CHANGE REPLICATION SOURCE TO SOURCE_USER="root" FOR CHANNEL "group_replication_recovery";
159 --enable_warnings
160 --source include/start_group_replication.inc
161
162 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME="group_replication_recovery" and SERVICE_STATE="OFF"
163 --source include/wait_condition.inc
164
165 --echo
166 --echo # Test commands for recovery channel when MEMBER_STATE: ONLINE and
167 --echo # recovery channel is PRESENT but INACTIVE.
168
169 --echo
170 --echo # STOP SLAVE is blocked on GR recovery channel
171 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
172 STOP SLAVE FOR CHANNEL "group_replication_recovery";
173
174 --echo
175 --echo # START SLAVE is blocked on GR recovery channel
176 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
177 START SLAVE FOR CHANNEL 'group_replication_recovery';
178
179 --echo
180 --echo # STOP SLAVE IO_THREAD is blocked on GR recovery channel
181 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
182 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
183
184 --echo
185 --echo # START SLAVE IO_THREAD is blocked on GR recovery channel
186 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
187 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
188
189 --echo
190 --echo # STOP SLAVE SQL_THREAD is blocked on GR recovery channel
191 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
192 STOP SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
193
194 --echo
195 --echo # START SLAVE SQL_THREAD is blocked on GR recovery channel
196 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
197 START SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
198
199 --echo
200 --echo # SHOW SLAVE STATUS - check that recovery channel is inactive
201 --let $io_thread = query_get_value(SHOW SLAVE STATUS FOR CHANNEL 'group_replication_recovery', Slave_IO_Running, 1)
202 --let $assert_text= recovery channel is inactive
203 --let $assert_cond= "$io_thread" = "No"
204 --source include/assert.inc
205
206 --echo
207 --echo # SHOW RELAYLOG EVENTS - check that relaylogs are created
208 --let $relay_log_name= query_get_value(SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_recovery', Log_name, 1)
209 --let $assert_text= Relay logs are created
210 --let $assert_cond= "$relay_log_name" <> ""
211 --source include/assert.inc
212
213 --echo
214 --echo # SUCCESS when executing FLUSH RELAY LOGS on GR recovery channel
215 FLUSH RELAY LOGS FOR CHANNEL 'group_replication_recovery';
216
217 --echo
218 --echo # SUCCESS when executing RESET SLAVE on GR recovery channel
219 RESET SLAVE FOR CHANNEL "group_replication_recovery";
220
221 --echo
222 --echo # Execute RESET SLAVE ALL FOR CHANNEL to delete the recovery channel
223 --echo # and related files
224 RESET SLAVE ALL FOR CHANNEL "group_replication_recovery";
225
226 # Phase 3
227 --echo
228 --echo # Stop GR on M2. Add data on M1. Lock table on M2 to block recovery.
229 --echo # Start GR on M2.
230
231 # Stop group replication and lock table t1 on server 2 to block recovery.
232 --let $rpl_connection_name= server2
233 --source include/rpl_connection.inc
234 --source include/stop_group_replication.inc
235
236 --let $rpl_connection_name= server1
237 --source include/rpl_connection.inc
238 INSERT INTO t1 VALUES (2);
239 INSERT INTO t1 VALUES (3);
240
241 # Lock the table in a different connection
242 --let $rpl_connection_name= server_2
243 --source include/rpl_connection.inc
244 LOCK TABLE t1 READ;
245
246 --let $rpl_connection_name= server2
247 --source include/rpl_connection.inc
248 --disable_warnings
249 CHANGE REPLICATION SOURCE TO SOURCE_USER="root" FOR CHANNEL "group_replication_recovery";
250 --enable_warnings
251
252 --echo
253 --echo # Ensure that M2 is blocked in recovery stage so channel exists
254
255 --let $group_replication_start_member_state= RECOVERING
256 --source include/start_group_replication.inc
257
258 --let $wait_timeout= 60
259 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME="group_replication_recovery" and SERVICE_STATE="ON"
260 --source include/wait_condition.inc
261
262 # Phase 4
263 --echo
264 --echo # Now when M2 is in RECOVERING state, test commands for recovery channel
265 --echo # when MEMBER_STATE: RECOVERING and recovery channel is ACTIVE.
266
267 --echo
268 --echo # STOP SLAVE is blocked on GR recovery channel
269 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
270 STOP SLAVE FOR CHANNEL "group_replication_recovery";
271
272 --echo
273 --echo # START SLAVE is blocked on GR recovery channel
274 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
275 START SLAVE FOR CHANNEL 'group_replication_recovery';
276
277 --echo
278 --echo # STOP SLAVE IO_THREAD is blocked on GR recovery channel
279 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
280 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
281
282 --echo
283 --echo # START SLAVE IO_THREAD is blocked on GR recovery channel
284 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
285 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
286
287 --echo
288 --echo # START SLAVE IO_THREAD with UNTIL option is blocked on GR recovery channel
289 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
290 START SLAVE IO_THREAD UNTIL SOURCE_LOG_FILE = 'server-binary-log.000001', SOURCE_LOG_POS = 754 FOR CHANNEL 'group_replication_recovery';
291
292 --echo
293 --echo # STOP SLAVE SQL_THREAD is blocked on GR recovery channel
294 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
295 STOP SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
296
297 --echo
298 --echo # START SLAVE SQL_THREAD is blocked on GR recovery channel
299 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
300 START SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
301
302 --echo
303 --echo # START SLAVE SQL_THREAD with UNTIL option is blocked on GR recovery channel
304 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
305 START SLAVE SQL_THREAD UNTIL SQL_AFTER_GTIDS='11111111-1111-1111-1111-111111111111:1-23' FOR CHANNEL 'group_replication_recovery';
306
307 --echo
308 --echo # START SLAVE SQL_THREAD with UNTIL option is blocked on GR recovery channel
309 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
310 START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE = 'server-relay-log-group_replication_recovery.000001', RELAY_LOG_POS = 854 FOR CHANNEL 'group_replication_recovery';
311
312 --echo
313 --echo # SHOW SLAVE STATUS - check that recovery channel is active
314 --let $io_thread = query_get_value(SHOW SLAVE STATUS FOR CHANNEL 'group_replication_recovery', Slave_IO_Running, 1)
315 --let $assert_text= recovery channel is active
316 --let $assert_cond= "$io_thread" = "Yes"
317 --source include/assert.inc
318
319 --echo
320 --echo # SHOW RELAYLOG EVENTS - Relay log files should exists
321 --let $relay_log_name= query_get_value(SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_recovery', Log_name, 1)
322 --let $assert_text= Relay log name should not be empty as the command successfully executed.
323 --let $assert_cond= "$relay_log_name" <> ""
324 --source include/assert.inc
325
326 # Bug#23575646 : FLUSH RELAY LOGS SHOULD HIT ERROR 3139 WHEN SERVER STATE IS RECOVERING
327 --echo
328 --echo # ERROR when executing FLUSH RELAY LOGS on GR recovery channel
329 --error ER_RUN_HOOK_ERROR
330 FLUSH RELAY LOGS FOR CHANNEL 'group_replication_recovery';
331
332 --echo
333 --echo # RESET SLAVE command is blocked only when recovery channel is active.
334 --error ER_REPLICA_CHANNEL_MUST_STOP
335 RESET SLAVE FOR CHANNEL "group_replication_recovery";
336
337 --echo
338 --echo # RESET SLAVE [ALL] command is blocked only when recovery channel is active.
339 --error ER_REPLICA_CHANNEL_MUST_STOP
340 RESET SLAVE ALL FOR CHANNEL "group_replication_recovery";
341
342
343 # Phase 5
344 --echo
345 --echo # Unlock tables on M2 and drop table t1 on M1. Stop GR on M2. Test
346 --echo # for recovery channel when MEMBER_STATE: OFFLINE and recovery channel
347 --echo # is PRESENT but INACTIVE.
348
349 --let $rpl_connection_name= server_2
350 --source include/rpl_connection.inc
351 UNLOCK TABLES;
352
353 --let $rpl_connection_name= server1
354 --source include/rpl_connection.inc
355 DROP TABLE t1;
356
357 --source include/rpl_sync.inc
358
359 --let $rpl_connection_name= server2
360 --source include/rpl_connection.inc
361 --source include/stop_group_replication.inc
362
363 --echo
364 --echo # STOP SLAVE is blocked on GR recovery channel
365 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
366 STOP SLAVE FOR CHANNEL "group_replication_recovery";
367
368 --echo
369 --echo # START SLAVE is blocked on GR recovery channel
370 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
371 START SLAVE FOR CHANNEL 'group_replication_recovery';
372
373 --echo
374 --echo # STOP SLAVE IO_THREAD is blocked on GR recovery channel
375 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
376 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
377
378 --echo
379 --echo # START SLAVE IO_THREAD is blocked on GR recovery channel
380 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
381 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_recovery';
382
383 --echo
384 --echo # STOP SLAVE SQL_THREAD is blocked on GR recovery channel
385 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
386 STOP SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
387
388 --echo
389 --echo # START SLAVE SQL_THREAD is blocked on GR recovery channel
390 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
391 START SLAVE SQL_THREAD FOR CHANNEL 'group_replication_recovery';
392
393 --echo
394 --echo # SHOW SLAVE STATUS - check that recovery channel is inactive
395 --let $io_thread = query_get_value(SHOW SLAVE STATUS FOR CHANNEL 'group_replication_recovery', Slave_IO_Running, 1)
396 --let $assert_text= recovery channel is inactive
397 --let $assert_cond= "$io_thread" = "No"
398 --source include/assert.inc
399
400 --echo
401 --echo # SHOW RELAYLOG EVENTS - check that relaylogs are not deleted
402 --let $relay_log_name= query_get_value(SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_recovery', Log_name, 1)
403 --let $assert_text= Relay logs are not deleted
404 --let $assert_cond= "$relay_log_name" <> ""
405 --source include/assert.inc
406
407 --echo
408 --echo # Execute RESET SLAVE ALL FOR CHANNEL to delete the recovery channel
409 --echo # and related files
410 RESET SLAVE ALL FOR CHANNEL "group_replication_recovery";
411
412 --echo
413 --echo # ERROR when executing RESET SLAVE on GR recovery channel
414 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
415 RESET SLAVE FOR CHANNEL "group_replication_recovery";
416
417 --echo
418 --echo # ERROR when executing FLUSH RELAY LOGS on GR recovery channel
419 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
420 FLUSH RELAY LOGS FOR CHANNEL 'group_replication_recovery';
421
422 --source include/group_replication_end.inc