Debian Codegraph @

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

raw
1 ################################################################################
2 # BUG#21142784 - CRASH ON 'START/STOP SLAVE FOR CHANNEL' AND 'START/STOP
3 # GROUP_REPLICATION'
4 # BUG#21154282 - RSA..CHANNEL 'GROUP_REPLICATION_APPLIER' SHOULD NOT BE ALLOWED
5 # WITHOUT STOP GR
6 #
7 # This test checks to see that user should not be allowed to execute
8 # set of commands for the group_replication_applier channel.
9 #
10 # a). When group_replication is ONLINE.
11 # b). when group_replication is OFFLINE.
12 #
13 # Test:
14 # 0. The test requires two servers: M1 and M2.
15 #
16 # 1. Start GR on member i.e. make M1 ONLINE. Now, check the execution of
17 # following commands on the GR channels.
18 # a) CHANGE MASTER command is blocked for other options than
19 # `PRIVILEGE_CHECKS_USER` for group replication applier channel.
20 # b) START SLAVE IO_THREAD is blocked on group_replication_applier
21 # c) START SLAVE IO_THREAD with UNTIL option is blocked on
22 # group_replication_applier
23 # d) STOP SLAVE IO_THREAD is blocked on group_replication_applier
24 # r) START SLAVE is blocked on group_replication_applier
25 # f) STOP SLAVE is blocked on group_replication_applier
26 # g) SHOW SLAVE STATUS is blocked on group_replication_applier
27 # h) START SLAVE SQL_THREAD is not allowed on group_replication_applier
28 # i) START SLAVE SQL_THREAD with UNTIL option is not allowed on
29 # group_replication_applier
30 # j) STOP SLAVE SQL_THREAD is not allowed on group_replication_applier
31 # k) SHOW RELAYLOG EVENTS is allowed on group_replication_applier
32 #
33 # 2. Stop GR on member i.e. make M1 OFFLINE. Now, check the execution of
34 # following commands on the GR channels.
35 # a) CHM is blocked on group_replication_applier
36 # b) START SLAVE IO_THREAD is blocked on group_replication_applier
37 # c) STOP SLAVE IO_THREAD is blocked on group_replication_applier
38 # d) START SLAVE is blocked on group_replication_applier
39 # e) STOP SLAVE is blocked on group_replication_applier
40 # f) SHOW SLAVE STATUS is blocked on group_replication_applier
41 # g) START SLAVE SQL_THREAD is allowed on group_replication_applier
42 # h) STOP SLAVE SQL_THREAD is allowed on group_replication_applier
43 # i) SHOW RELAYLOG EVENTS is allowed on group_replication_applier
44 #
45 # 3. Start GR on M1. Connect to M2 which is ONLINE.
46 # a) RESET SLAVE ALL is blocked on group_replication_applier
47 # b) RESET SLAVE is blocked on group_replication_applier
48 #
49 # 4. Stop GR on M2 (OFFLINE).
50 # a) RESET SLAVE is allowed on group_replication_applier
51 #
52 # 5. Start GR on M2 (ONLINE).
53 # a) RESET SLAVE is blocked on group_replication_applier
54 #
55 # 6. Stop GR on M2 (OFFLINE).
56 # a) RESET SLAVE ALL is allowed on group_replication_applier
57 #
58 # 7. Start GR on M2 (ONLINE). STOP SLAVE SQL_THREAD on the channel. Then,
59 # a) RESET SLAVE is blocked on group_replication_applier
60 # b) RESET SLAVE ALL is blocked on group_replication_applier
61 #
62 # 8. START SLAVE SQL_THREAD on the channel. Stop GR on M2 (OFFLINE). Then,
63 # a) RESET SLAVE ALL is allowed on group_replication_applier
64 # b) RESET SLAVE - check that channel doesn't exists
65 ################################################################################
66 --source include/big_test.inc
67 --source include/have_group_replication_plugin.inc
68 --source include/group_replication.inc
69
70 --let $rpl_connection_name= server1
71 --source include/rpl_connection.inc
72 # Part 1 - Checking the execution of the command when group_replication is ON.
73
74 --echo
75 --echo # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
76 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
77 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
78
79 --echo
80 --echo # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
81 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
82 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
83
84 --echo
85 --echo # CHANGE MASTER command is blocked for option `PRIVILEGE_CHECKS_USER` when GR is running
86 --error ER_GRP_OPERATION_NOT_ALLOWED_GR_MUST_STOP
87 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='user' FOR CHANNEL "group_replication_applier";
88
89 --echo
90 --echo # error when executing START SLAVE IO_THREAD FOR CHANNEL
91 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
92 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
93
94 --echo
95 --echo # error when executing STOP SLAVE IO_THREAD FOR CHANNEL
96 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
97 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
98
99 --echo
100 --echo # error when executing START SLAVE IO_THREAD FOR CHANNEL with UNTIL option
101 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
102 START SLAVE IO_THREAD UNTIL SOURCE_LOG_FILE = 'server-binary-log.000001', SOURCE_LOG_POS = 781 FOR CHANNEL 'group_replication_applier';
103
104 --echo
105 --echo # error when executing START SLAVE FOR CHANNEL
106 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
107 START SLAVE FOR CHANNEL 'group_replication_applier';
108
109 --echo
110 --echo # error when executing STOP SLAVE FOR CHANNEL
111 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
112 STOP SLAVE FOR CHANNEL 'group_replication_applier';
113
114 --echo
115 --echo # error when executing SHOW SLAVE STATUS FOR CHANNEL
116 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
117 SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
118
119 --echo
120 --echo # START SLAVE SQL_THREAD command will not work for group_replication_applier
121 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
122 START REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
123
124 --echo
125 --echo # STOP SLAVE SQL_THREAD command will not work for group_replication_applier
126 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
127 STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
128
129 --echo # START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
130 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
131 START SLAVE SQL_THREAD UNTIL SQL_BEFORE_GTIDS='11111111-1111-1111-1111-111111111111:1-23' FOR CHANNEL 'group_replication_applier';
132
133 --echo # START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
134 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
135 START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE = 'server-relay-log-group_replication_applier.000002', RELAY_LOG_POS = 10000 FOR CHANNEL 'group_replication_applier';
136
137 --echo
138 --echo # SHOW RELAYLOG EVENTS for channel will work for all channels
139 --let $relay_log_name= query_get_value(SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_applier', Log_name, 1)
140 --let $assert_text= Relay log name should not be empty as the command successfully executed.
141 --let $assert_cond= "$relay_log_name" <> ""
142 --source include/assert.inc
143
144 # Part 2 - Checking the execution of the command when group_replication is OFF
145
146 --let $rpl_connection_name= server1
147 --source include/rpl_connection.inc
148 --source include/stop_group_replication.inc
149
150 --echo
151 --echo # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
152 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
153 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
154
155 --echo
156 --echo # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
157 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
158 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
159
160 --echo
161 --echo # CHANGE MASTER command allows option `PRIVILEGE_CHECKS_USER` when GR is stopped
162 SET SESSION sql_log_bin= 0;
163 CREATE USER gr_applier_slave_user;
164 SET SESSION sql_log_bin= 1;
165
166 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='gr_applier_slave_user' FOR CHANNEL "group_replication_applier";
167 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER=NULL FOR CHANNEL "group_replication_applier";
168
169 SET SESSION sql_log_bin= 0;
170 DROP USER gr_applier_slave_user;
171 SET SESSION sql_log_bin= 1;
172
173 --echo
174 --echo # error when executing START SLAVE IO_THREAD FOR CHANNEL
175 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
176 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
177
178 --echo
179 --echo # error when executing STOP SLAVE IO_THREAD FOR CHANNEL
180 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
181 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
182
183 --echo
184 --echo # error when executing START SLAVE FOR CHANNEL
185 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
186 START SLAVE FOR CHANNEL 'group_replication_applier';
187
188 --echo
189 --echo # error when executing STOP SLAVE FOR CHANNEL
190 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
191 STOP SLAVE FOR CHANNEL 'group_replication_applier';
192
193 --echo
194 --echo # error when executing SHOW SLAVE STATUS FOR CHANNEL
195 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
196 SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
197
198 --echo
199 --echo # START SLAVE SQL_THREAD command will work for group_replication_applier
200 --source include/gr_start_applier_sql_thread.inc
201
202 --echo
203 --echo # STOP SLAVE SQL_THREAD command will work for group_replication_applier
204 --source include/gr_stop_applier_sql_thread.inc
205
206 --echo
207 --echo # SHOW RELAYLOG EVENTS for channel will work for all channels
208 --let $relay_log_name= query_get_value(SHOW RELAYLOG EVENTS FOR CHANNEL 'group_replication_applier', Log_name, 1)
209 --let $assert_text= Relay log name should not be empty as the command successfully executed.
210 --let $assert_cond= "$relay_log_name" <> ""
211 --source include/assert.inc
212
213 --let $rpl_connection_name= server1
214 --source include/rpl_connection.inc
215
216 --source include/start_group_replication.inc
217
218 # Checking the RESET SLAVE [ALL] commands execution.
219
220 --let $rpl_connection_name= server2
221 --source include/rpl_connection.inc
222
223 --echo
224 --echo # RESET SLAVE [ALL] command is blocked only when channel is running.
225 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
226 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
227
228 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
229 RESET SLAVE FOR CHANNEL "group_replication_applier";
230
231 --echo
232 --echo # This is command should work without problem.
233 --source include/stop_group_replication.inc
234 RESET SLAVE FOR CHANNEL "group_replication_applier";
235 --source include/start_group_replication.inc
236
237 --echo
238 --echo # This is command should work without problem.
239 --source include/stop_group_replication.inc
240 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
241
242 # RESET SLAVE should not be allowed when Group_replication is running.
243 --source include/start_group_replication.inc
244 --echo # RESET SLAVE should not be allowed when GR is ONLINE.
245 --echo # So this command will fail.
246 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
247 RESET SLAVE FOR CHANNEL "group_replication_applier";
248
249 --echo # RESET SLAVE ALL should not be allowed when GR is ONLINE.
250 --echo # So this command will fail.
251 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
252 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
253
254 --echo # stop the channel and try reset slave for channel again. It should work.
255 --source include/stop_group_replication.inc
256
257 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
258
259 --error ER_REPLICA_CHANNEL_DOES_NOT_EXIST
260 RESET SLAVE FOR CHANNEL "group_replication_applier";
261
262 --source include/group_replication_end.inc