Debian Codegraph @

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

raw
1 ################################################################################
2 #
3 # Validate that:
4 # - The Automatic Connection failover feature for Receiver works when
5 # asynchronous replication receiver is a Primary member.
6 # - Whenever a running managed channel receiver who is also the Primary on a
7 # Single-Primary mode goes in OFFLINE/ERROR group replication state, then
8 # the new selected PRIMARY of the receiver group MUST establish asynchronous
9 # replication connection with the sender.
10 #
11 # Test:
12 # 0. The test requires 5 servers:
13 # server1: single-primary group A primary
14 # server2: single-primary group A secondary
15 # server3: single-primary group B primary
16 # server4: single-primary group B secondary
17 # server5: stand alone server
18 # 1. Create a replication channel to replicate from server4 to
19 # to server1 on both server1 and 2.
20 # 2. Add group A replication failover managed source into secondary
21 # member in group B, server4.
22 # It will be allowed but the configuration will not be propagated.
23 # 3. Deploy a 2 members receiver group in single primary mode.
24 # 4. Error adding managed group to secondary server2.
25 # 5. Deploy a 2 members sender group in single primary mode.
26 # 6. Error starting a replication channel on secondary member server2.
27 # 7. Add replication connection details of managed channel ch1
28 # to replication_asynchronous_connection_failover_managed table
29 # through asynchronous_connection_failover_add_managed() UDF.
30 # 8. Verify replication_asynchronous_connection_failover on
31 # server1 has two rows and member action configuration version
32 # value for replication_asynchronous_connection_failover
33 # and for replication_asynchronous_connection_failover_managed.
34 # And the channel 'ch1' is connected to server3.
35 # 9. Verify replication_asynchronous_connection_failover on
36 # server2 has two rows and member action configuration version
37 # value for replication_asynchronous_connection_failover
38 # and for replication_asynchronous_connection_failover_managed.
39 # 10. Stop group replication on existing primary (server1), the new
40 # primary will establish asynchronous replication channel (ch1)
41 # connection with sender which is server3.
42 # And the channel 'ch1' is connected to server3.
43 # 11. Delete replication connection details for managed channel ch1
44 # from replication_asynchronous_connection_failover_managed
45 # and replication_asynchronous_connection_failover table
46 # through asynchronous_connection_failover_delete_managed() UDF.
47 # 12. Verify replication_asynchronous_connection_failover on
48 # server2 is empty and member action configuration version
49 # value for replication_asynchronous_connection_failover
50 # and for replication_asynchronous_connection_failover_managed.
51 # And the channel 'ch1' is connected to server3.
52 # 13. Clean up.
53 --source include/big_test.inc
54 --source include/have_group_replication_plugin.inc
55 --let $rpl_skip_group_replication_start= 1
56 --let $rpl_server_count= 4
57 --source include/group_replication.inc
58
59 --let $group_A= `SELECT UUID()`
60 --let $group_B= `SELECT UUID()`
61
62 # Use the appropriate XCom port, that does depend on
63 # `group_replication_communication_stack`.
64 --let $have_xcom_stack= `SELECT @@group_replication_communication_stack LIKE 'XCOM'`
65 --let $group_a_group_seeds= "localhost:$SERVER_GR_PORT_1,localhost:$SERVER_GR_PORT_2"
66 --let $group_b_group_seeds= "localhost:$SERVER_GR_PORT_3,localhost:$SERVER_GR_PORT_4"
67 if (!$have_xcom_stack) {
68 --let $group_a_group_seeds= "localhost:$SERVER_MYPORT_1,localhost:$SERVER_MYPORT_2"
69 --let $group_b_group_seeds= "localhost:$SERVER_MYPORT_3,localhost:$SERVER_MYPORT_4"
70 }
71
72 --let $rpl_connection_name= server2
73 --source include/rpl_connection.inc
74 SET SESSION sql_log_bin = 0;
75 call mtr.add_suppression("Can't start replica IO THREAD of channel 'ch1' when group replication is running with single-primary mode on a secondary member.");
76 call mtr.add_suppression("Can't start replica SQL THREAD of channel 'ch1' when group replication is running with single-primary mode on a secondary member.");
77 call mtr.add_suppression("Run function 'thread_start' in plugin 'group_replication' failed");
78 call mtr.add_suppression("Run function 'applier_start' in plugin 'group_replication' failed");
79 call mtr.add_suppression("Failed to run 'thread_start' hook");
80 call mtr.add_suppression("Failed to run 'applier_start' hook");
81 SET SESSION sql_log_bin = 1;
82
83
84 --echo
85 --echo # 1. Create a replication channel to replicate from server4 to
86 --echo # to server1 on both server1 and 2.
87 --echo
88 --let $rpl_connection_name= server1
89 --source include/rpl_connection.inc
90 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
91 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1'
92
93
94 --let $rpl_connection_name= server2
95 --source include/rpl_connection.inc
96 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
97 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1'
98
99
100 --echo
101 --echo # 2. Add server4 using asynchronous_connection_failover_add_managed
102 --echo # UDF on stand alone server2.
103 --echo # It will be allowed but the configuration will not be propagated.
104 --echo
105 --let $rpl_connection_name= server2
106 --source include/rpl_connection.inc
107
108 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4 $group_A GROUP_NAME_SERVER1
109 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', '$group_A', '127.0.0.1', $SERVER_MYPORT_4, '', 90, 70);
110
111
112 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover'
113 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
114 --source include/assert.inc
115
116 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
117 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
118 --source include/assert.inc
119
120 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover_managed'
121 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_A", count, 1] = 1
122 --source include/assert.inc
123
124 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 1'
125 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', version, 1] = 1
126 --source include/assert.inc
127
128
129 --let $rpl_connection_name= server1
130 --source include/rpl_connection.inc
131
132 --let $assert_text= 'There are no rows in performance_schema.replication_asynchronous_connection_failover'
133 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 0
134 --source include/assert.inc
135
136 --let $assert_text= 'There is no version of replication_asynchronous_connection_failover'
137 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', count, 1] = 0
138 --source include/assert.inc
139
140 --let $assert_text= 'There are no rows in performance_schema.replication_asynchronous_connection_failover_managed'
141 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed, count, 1] = 0
142 --source include/assert.inc
143
144 --let $assert_text= 'There is no version of replication_asynchronous_connection_failover_managed'
145 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', count, 1] = 0
146 --source include/assert.inc
147
148
149 --echo
150 --echo # 3. Deploy a 2 members receiver group in single primary mode.
151 --echo # Since server1 will bootstrap the group, server1 configuration will
152 --echo # be the group configuration, which will override server2
153 --echo # configuration when server2 joins the group.
154 --echo
155 --let $rpl_connection_name= server1
156 --source include/rpl_connection.inc
157 --let $group_replication_group_name = $group_A
158 --disable_query_log
159 --eval SET GLOBAL group_replication_group_seeds= $group_a_group_seeds
160 --enable_query_log
161 --source include/start_and_bootstrap_group_replication.inc
162
163 --let $assert_text= 'The performance_schema.replication_asynchronous_connection_failover table is empty'
164 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = "0"
165 --source include/assert.inc
166
167 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 0'
168 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', count, 1] = 0
169 --source include/assert.inc
170
171 --let $assert_text= 'The performance_schema.replication_asynchronous_connection_failover_managed table is empty'
172 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_A", count, 1] = "0"
173 --source include/assert.inc
174
175 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 0'
176 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', count, 1] = 0
177 --source include/assert.inc
178
179
180 --let $rpl_connection_name= server2
181 --source include/rpl_connection.inc
182 --let $group_replication_group_name = $group_A
183 --disable_query_log
184 --eval SET GLOBAL group_replication_group_seeds= $group_a_group_seeds
185 --enable_query_log
186 --source include/start_group_replication.inc
187
188 --let $assert_text= 'The performance_schema.replication_asynchronous_connection_failover table is empty'
189 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = "0"
190 --source include/assert.inc
191
192 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 0'
193 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', count, 1] = "0"
194 --source include/assert.inc
195
196 --let $assert_text= 'The performance_schema.replication_asynchronous_connection_failover_managed table is empty'
197 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_A", count, 1] = "0"
198 --source include/assert.inc
199
200 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 0'
201 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', count, 1] = "0"
202 --source include/assert.inc
203
204
205 --echo
206 --echo # 4. Error adding managed group to secondary server2.
207 --echo
208 --replace_result $SERVER_MYPORT_5 SERVER_MYPORT_5 $group_A GROUP_A
209 --error ER_CANT_INITIALIZE_UDF
210 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', '$group_A', '127.0.0.1', $SERVER_MYPORT_5, '', 90, 70);
211
212 --replace_result $SERVER_MYPORT_5 SERVER_MYPORT_5
213 --error ER_CANT_INITIALIZE_UDF
214 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_5, '', 50)
215
216 --let $assert_text= 'There are no rows in performance_schema.replication_asynchronous_connection_failover'
217 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 0
218 --source include/assert.inc
219
220 --let $assert_text= 'There is no version of replication_asynchronous_connection_failover'
221 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', count, 1] = 0
222 --source include/assert.inc
223
224 --let $assert_text= 'There are no rows in performance_schema.replication_asynchronous_connection_failover_managed'
225 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_A", count, 1] = 0
226 --source include/assert.inc
227
228 --let $assert_text= 'There is no version of replication_asynchronous_connection_failover_managed'
229 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', count, 1] = 0
230 --source include/assert.inc
231
232
233 --echo #
234 --echo # 5. Deploy a 2 members sender group in single primary mode.
235 --echo #
236 --let $rpl_connection_name= server3
237 --source include/rpl_connection.inc
238 --let $group_replication_group_name = $group_B
239 --disable_query_log
240 --eval SET GLOBAL group_replication_group_seeds= $group_b_group_seeds
241 --enable_query_log
242 --source include/start_and_bootstrap_group_replication.inc
243
244
245 --let $rpl_connection_name= server4
246 --source include/rpl_connection.inc
247 --let $group_replication_group_name = $group_B
248 --disable_query_log
249 --eval SET GLOBAL group_replication_group_seeds= $group_b_group_seeds
250 --enable_query_log
251 --source include/start_group_replication.inc
252
253
254 --echo
255 --echo # 6. Error starting a replication channel on secondary member server2.
256 --echo
257 --let $rpl_connection_name= server2
258 --source include/rpl_connection.inc
259
260 START REPLICA FOR CHANNEL 'ch1';
261
262 --let $slave_sql_errno= 13117
263 --let $rpl_channel_name= 'ch1'
264 --source include/wait_for_slave_sql_error.inc
265
266 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.err
267 --let $assert_count = 1
268 --let $assert_select = Can\'t start replica IO THREAD of channel \'ch1\' when group replication is running with single-primary mode on a secondary member
269 --let $assert_text = Server executed GTID set is logged.
270 --source include/assert_grep.inc
271
272 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.err
273 --let $assert_count = 1
274 --let $assert_select = Can\'t start replica SQL THREAD of channel \'ch1\' when group replication is running with single-primary mode on a secondary member
275 --let $assert_text = Server executed GTID set is logged.
276 --source include/assert_grep.inc
277
278 STOP REPLICA FOR CHANNEL 'ch1';
279
280
281 --echo
282 --echo # 7. Add replication connection details of managed channel ch1
283 --echo # to replication_asynchronous_connection_failover_managed table
284 --echo # through asynchronous_connection_failover_add_managed() UDF.
285 --echo
286 --let $rpl_connection_name= server1
287 --source include/rpl_connection.inc
288 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4 $group_B GROUP_NAME_SERVER2
289 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "$group_B",'127.0.0.1', $SERVER_MYPORT_4, '', 80, 60)
290
291
292 --echo
293 --echo # 8. Verify replication_asynchronous_connection_failover on
294 --echo # server1 has two rows and member action configuration version
295 --echo # value for replication_asynchronous_connection_failover
296 --echo # and for replication_asynchronous_connection_failover_managed.
297 --echo # And the channel 'ch1' is connected to server3.
298 --echo
299 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
300 --source include/wait_condition.inc
301
302 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
303 --source include/wait_condition.inc
304
305 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=2
306 --source include/wait_condition.inc
307 --let $failover_version_step8= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
308
309 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
310 --source include/wait_condition.inc
311
312 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
313 --source include/wait_condition.inc
314
315 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
316 --source include/wait_condition.inc
317
318 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
319 --source include/wait_condition.inc
320
321
322
323
324 --echo
325 --echo # 9. Verify replication_asynchronous_connection_failover on
326 --echo # server2 has two rows and member action configuration version
327 --echo # value for replication_asynchronous_connection_failover
328 --echo # and for replication_asynchronous_connection_failover_managed.
329 --echo
330 --let $rpl_connection_name= server2
331 --source include/rpl_connection.inc
332
333 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
334 --source include/wait_condition.inc
335
336 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
337 --source include/wait_condition.inc
338
339 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step8
340 --source include/wait_condition.inc
341
342 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
343 --source include/wait_condition.inc
344
345
346 --echo
347 --echo # 10. Stop group replication on existing primary (server1), the new
348 --echo # primary will establish asynchronous replication channel (ch1)
349 --echo # connection with sender which is server3.
350 --echo # And the channel 'ch1' is connected to server3.
351 --echo
352 --let $server2_uuid= `SELECT @@server_uuid`
353
354 --let $rpl_connection_name= server1
355 --source include/rpl_connection.inc
356
357 --source include/stop_group_replication.inc
358
359 --let $rpl_connection_name= server2
360 --source include/rpl_connection.inc
361
362 --let $group_replication_expected_uuid= $server2_uuid
363 --source include/gr_wait_primary_member_uuid.inc
364
365 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
366 --source include/wait_condition.inc
367
368 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
369 --source include/wait_condition.inc
370
371 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
372 --source include/wait_condition.inc
373
374 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
375 --source include/wait_condition.inc
376
377
378 --echo
379 --echo # 11. Delete replication connection details for managed channel ch1
380 --echo # from replication_asynchronous_connection_failover_managed
381 --echo # and replication_asynchronous_connection_failover table
382 --echo # through asynchronous_connection_failover_delete_managed() UDF.
383 --echo
384 --let $rpl_connection_name= server2
385 --source include/rpl_connection.inc
386
387 --replace_result $group_B GROUP_NAME_SERVER2
388 --eval SELECT asynchronous_connection_failover_delete_managed('ch1', '$group_B')
389
390
391 --echo
392 --echo # 12. Verify replication_asynchronous_connection_failover on
393 --echo # server2 is empty and member action configuration version
394 --echo # value for replication_asynchronous_connection_failover
395 --echo # and for replication_asynchronous_connection_failover_managed.
396 --echo # And the channel 'ch1' is connected to server3.
397 --echo
398 --let $rpl_connection_name= server2
399 --source include/rpl_connection.inc
400
401 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
402 --source include/wait_condition.inc
403
404 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover_managed
405 --source include/wait_condition.inc
406
407 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=3
408 --source include/wait_condition.inc
409
410 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
411 --source include/wait_condition.inc
412
413 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
414 --source include/wait_condition.inc
415
416 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
417 --source include/wait_condition.inc
418
419
420 --echo #
421 --echo # 13. Clean up.
422 --echo #
423 --let $rpl_connection_name= server1
424 --source include/rpl_connection.inc
425
426 --let $rpl_channel_name='ch1'
427 --let $rpl_reset_slave_all= 1
428 --let $rpl_multi_source= 1
429 --source include/rpl_reset_slave.inc
430 --let $rpl_channel_name=
431 --let $rpl_reset_slave_all=
432 --let $rpl_multi_source=
433
434 --let $rpl_connection_name= server2
435 --source include/rpl_connection.inc
436
437 --let $rpl_channel_name='ch1'
438 --source include/stop_slave.inc
439
440 --let $rpl_reset_slave_all= 1
441 --let $rpl_multi_source= 1
442 --source include/rpl_reset_slave.inc
443 --let $rpl_channel_name=
444 --let $rpl_reset_slave_all=
445 --let $rpl_multi_source=
446
447 --let $rpl_connection_name= server4
448 --source include/rpl_connection.inc
449 --source include/stop_group_replication.inc
450
451 --let $rpl_connection_name= server3
452 --source include/rpl_connection.inc
453 --source include/stop_group_replication.inc
454
455 --let $rpl_connection_name= server2
456 --source include/rpl_connection.inc
457 --source include/stop_group_replication.inc
458
459 --let $rpl_skip_sync = 1
460 --source include/group_replication_end.inc