Debian Codegraph @

mysql-test/suite/group_replication/t/gr_primary_mode_group_operations_11.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 single 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 --source include/group_replication.inc
20
21 --echo
22 --echo # 1. Enable debug point to block action
23
24 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
25 SET @@GLOBAL.DEBUG= '+d,group_replication_block_group_action';
26
27 --echo
28 --echo # 2. Execute a switch to single primary mode on server1
29
30 --replace_result $server1_uuid MEMBER1_UUID
31 --send_eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
32
33 --echo
34 --echo # 3. Execute parallel group action on server2 that must fail
35 --echo # due to already one operation is being executed
36
37 --let $rpl_connection_name= server2
38 --source include/rpl_connection.inc
39
40 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
41
42 # verify thread THD_group_action_coordinator has started
43 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_group_action_coordinator"
44 --source include/wait_condition.inc
45
46 --echo
47 --echo # Execute a switch to single primary mode that must fail
48 --replace_result $server2_uuid MEMBER2_UUID
49 --error ER_GRP_RPL_UDF_ERROR
50 --eval SELECT group_replication_switch_to_single_primary_mode("$server2_uuid")
51
52 --echo
53 --replace_result $server1_uuid MEMBER1_UUID
54 --error ER_GRP_RPL_UDF_ERROR
55 --eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
56
57 --echo
58 --error ER_GRP_RPL_UDF_ERROR
59 SELECT group_replication_switch_to_single_primary_mode();
60
61 --echo
62 --echo # Execute a switch to multi primary mode that must be no-op
63 SELECT group_replication_switch_to_multi_primary_mode();
64
65 --echo
66 --echo # Execute a set primary that must fail as can't initialize
67 --replace_result $server2_uuid MEMBER2_UUID
68 --error ER_CANT_INITIALIZE_UDF
69 --eval SELECT group_replication_set_as_primary("$server2_uuid")
70
71 --echo
72 --replace_result $server1_uuid MEMBER1_UUID
73 --error ER_CANT_INITIALIZE_UDF
74 --eval SELECT group_replication_set_as_primary("$server1_uuid")
75
76 --echo
77 --echo # Add suppression
78 set session sql_log_bin=0;
79 call mtr.add_suppression("The function 'group_replication_switch_to_single_primary_mode' failed. There is*");
80 set session sql_log_bin=1;
81
82 --echo
83 --echo # 4. Unlock the blocked action on server1
84
85 --let $rpl_connection_name= server_1
86 --source include/rpl_connection.inc
87
88 SET DEBUG_SYNC= "now SIGNAL signal.action_continue";
89
90 --let $rpl_connection_name= server1
91 --source include/rpl_connection.inc
92
93 --echo
94 --echo # 5. Resume the action on server1
95
96 --replace_result $server1_uuid MEMBER1_UUID
97 --reap
98
99 --echo
100 --echo # 6. Cleanup
101
102 SET @@GLOBAL.DEBUG= '-d,group_replication_block_group_action';
103
104 --let $rpl_group_replication_single_primary_mode=1
105 --let $rpl_group_replication_reset_persistent_vars=1
106 --source include/group_replication_end.inc