Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # No more than one configuration change can happen at the same time.
4 #
5 # Test:
6 # 0. This test requires two servers
7 # 1. Enable debug point to block action
8 # 2. Execute a switch to multi primary mode on server1
9 # 3. Execute parallel group action on server2 that must fail
10 # due to already one operation is being executed
11 # 4. Unlock the blocked action on server1
12 # 5. Resume the action on server1
13 # 6. Cleanup
14 #
15 ###############################################################################
16
17 --source include/have_debug_sync.inc
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_group_replication_single_primary_mode=1
21 --source include/group_replication.inc
22
23 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
24 --source include/start_and_bootstrap_group_replication.inc
25
26 --let $rpl_connection_name= server2
27 --source include/rpl_connection.inc
28
29 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
30 --source include/start_group_replication.inc
31
32 --echo
33 --echo # 1. Enable debug point to block action
34
35 --let $rpl_connection_name= server1
36 --source include/rpl_connection.inc
37
38 SET @@GLOBAL.DEBUG= '+d,group_replication_block_group_action';
39
40 --echo
41 --echo # 2. Execute a switch to single primary mode on server1
42
43 --send SELECT group_replication_switch_to_multi_primary_mode()
44
45 --echo
46 --echo # 3. Execute parallel group action on server2 that must fail
47 --echo # due to already one operation is being executed
48
49 --let $rpl_connection_name= server2
50 --source include/rpl_connection.inc
51
52 # verify thread THD_group_action_coordinator has started
53 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_group_action_coordinator"
54 --source include/wait_condition.inc
55
56 --echo
57 --echo # Execute a switch to multi primary mode that must fail
58 --replace_result $server2_uuid MEMBER2_UUID
59 --error ER_GRP_RPL_UDF_ERROR
60 SELECT group_replication_switch_to_multi_primary_mode();
61
62 --echo
63 --echo # Execute a set primary to new member that must fail
64 --replace_result $server2_uuid MEMBER2_UUID
65 --error ER_GRP_RPL_UDF_ERROR
66 --eval SELECT group_replication_set_as_primary("$server2_uuid")
67
68 --echo
69 --echo # Execute a set primary to itself that must be a no-op
70 --replace_result $server1_uuid MEMBER1_UUID
71 --eval SELECT group_replication_set_as_primary("$server1_uuid")
72
73 --echo
74 --echo # Execute a switch to single primary mode that must be a no-op
75 --replace_result $server1_uuid MEMBER1_UUID
76 --eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
77
78 --echo
79 --replace_result $server2_uuid MEMBER2_UUID
80 --eval SELECT group_replication_switch_to_single_primary_mode("$server2_uuid")
81
82 --echo
83 SELECT group_replication_switch_to_single_primary_mode();
84
85 --echo
86 --echo # 4. Unlock the blocked action on server1
87
88 --let $rpl_connection_name= server_1
89 --source include/rpl_connection.inc
90
91 SET DEBUG_SYNC= "now SIGNAL signal.action_continue";
92
93 --let $rpl_connection_name= server1
94 --source include/rpl_connection.inc
95
96 --echo
97 --echo # 5. Resume the action on server1
98
99 --reap
100
101 --echo
102 --echo # 6. Cleanup
103
104 SET @@GLOBAL.DEBUG= '-d,group_replication_block_group_action';
105
106 --let $rpl_connection_name= server2
107 --source include/rpl_connection.inc
108
109 set session sql_log_bin=0;
110 call mtr.add_suppression("The function 'group_replication_switch_to_multi_primary_mode' failed. There is*");
111 call mtr.add_suppression("The function 'group_replication_set_as_primary' failed. There is*");
112 set session sql_log_bin=1;
113
114 --let $rpl_group_replication_single_primary_mode=1
115 --let $rpl_group_replication_reset_persistent_vars=1
116 --source include/group_replication_end.inc