Debian Codegraph @

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

raw
1 ################################################################################
2 # Verify that group_replication_force_members does behave as expected
3 # when:
4 # DBA tries to set group_replication_force_members
5 # in parallel on the same server.
6 #
7 # Test:
8 # 0. The test requires one server: M1.
9 # 1. Block during set value to group_replication_force_members using
10 # DEBUG point.
11 # 2. Try set group_replication_force_members in a parallel session, it
12 # will fail.
13 # 3. Resume set value to group_replication_force_members.
14 # 4. Try set group_replication_force_members on M1 again, it will
15 # succeed.
16 # 5. Clean up.
17 ################################################################################
18 --source include/have_debug_sync.inc
19 --source include/have_group_replication_plugin.inc
20 --let $rpl_skip_group_replication_start= 1
21 --source include/group_replication.inc
22
23 SET SESSION sql_log_bin= 0;
24 call mtr.add_suppression("There is one group_replication_force_members operation already ongoing");
25 SET SESSION sql_log_bin= 1;
26
27
28 --echo
29 --echo ############################################################
30 --echo # 1. Block during set value to
31 --echo # group_replication_force_members (server_1).
32 --let $rpl_connection_name= server_1
33 --source include/rpl_connection.inc
34 SET @debug_save= @@GLOBAL.DEBUG;
35 SET @@GLOBAL.DEBUG='d,group_replication_wait_on_check_force_members';
36 --send SET GLOBAL group_replication_force_members= ""
37
38 # Wait until server_1 connection reaches the debug sync point.
39 --let $rpl_connection_name= server1
40 --source include/rpl_connection.inc
41 --let $wait_condition=SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE State = 'debug sync point: now'
42 --source include/wait_condition.inc
43
44 --echo
45 --echo ############################################################
46 --echo # 2. Try set group_replication_force_members in a
47 --echo # parallel session (server1), it will fail.
48 --let $rpl_connection_name= server1
49 --source include/rpl_connection.inc
50 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
51 SET GLOBAL group_replication_force_members= "";
52
53
54 --echo
55 --echo ############################################################
56 --echo # 3. Resume set value to
57 --echo # group_replication_force_members on server_1.
58 --let $rpl_connection_name= server1
59 --source include/rpl_connection.inc
60 SET DEBUG_SYNC='now SIGNAL waiting';
61 SET @@GLOBAL.DEBUG= @debug_save;
62
63 --let $rpl_connection_name= server_1
64 --source include/rpl_connection.inc
65 --reap
66
67 --let $assert_text= group_replication_force_members is empty
68 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
69 --source include/assert.inc
70
71
72 --echo
73 --echo ############################################################
74 --echo # 4. Try set group_replication_force_members on
75 --echo # server1 again, it will succeed.
76 --let $rpl_connection_name= server1
77 --source include/rpl_connection.inc
78 SET GLOBAL group_replication_force_members= "";
79
80 --let $assert_text= group_replication_force_members is empty
81 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
82 --source include/assert.inc
83
84
85 --echo
86 --echo ############################################################
87 --echo # 5. Clean up.
88 --source include/group_replication_end.inc