Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # When electing a primary server, P, if any other member than P
4 # contains running slave channels, the configuration change shall abort.
5 #
6 # Test:
7 # 0. This test need 3 servers
8 # 1. server1 start group replication and server2 join
9 # 2. server1 has a slave connection to server3
10 # 3. Execute action to single primary mode with server2 as the primary.
11 # It shall fail as server1 has slave connections
12 # 4. Execute action switch to single primary mode with server1 as primary
13 # 5. Execute action set as primary to server2. It shall fail due to server1
14 # slave connections
15 # 6. Cleanup
16 #
17 ###############################################################################
18
19 --source include/have_group_replication_plugin.inc
20 --let $rpl_skip_group_replication_start= 1
21 --let $rpl_server_count= 3
22 --source include/group_replication.inc
23
24 --echo
25 --echo # 1. server1 start group replication and server2 join
26
27 --source include/start_and_bootstrap_group_replication.inc
28
29 --let $rpl_connection_name= server2
30 --source include/rpl_connection.inc
31 --source include/start_group_replication.inc
32
33 --echo
34 --echo # 2. server1 has a slave connection to server3
35
36 --let $rpl_connection_name= server1
37 --source include/rpl_connection.inc
38
39 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
40
41 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
42 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_3 for channel 'ch3_1'
43
44 --let $rpl_channel_name='ch3_1'
45 --source include/start_slave.inc
46 --let $rpl_channel_name=
47
48 --echo
49 --echo # 3. Execute action to single primary mode with server2 as the primary.
50 --echo # It shall fail as server1 has slave connections
51
52 --let $rpl_connection_name= server2
53 --source include/rpl_connection.inc
54
55 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
56
57 --replace_result $server2_uuid MEMBER2_UUID $server1_uuid MEMBER1_UUID
58 --error ER_GRP_RPL_UDF_ERROR
59 --eval SELECT group_replication_switch_to_single_primary_mode("$server2_uuid")
60
61 --echo
62 --echo # 4. Execute action switch to single primary mode with server1 as primary
63
64 --replace_result $server1_uuid MEMBER1_UUID
65 --eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
66
67 --echo
68 --echo # 5. Execute action set as primary to server2.
69 --echo # It shall fail due to server1 slave connections
70
71 --replace_result $server2_uuid MEMBER2_UUID
72 --error ER_GRP_RPL_UDF_ERROR
73 --eval SELECT group_replication_set_as_primary("$server2_uuid")
74
75 --echo
76 --echo # 6. Cleanup
77
78 --let $rpl_connection_name= server1
79 --source include/rpl_connection.inc
80 STOP SLAVE FOR CHANNEL 'ch3_1';
81 RESET SLAVE ALL FOR CHANNEL 'ch3_1';
82
83 set session sql_log_bin=0;
84 call mtr.add_suppression("Error while executing a group configuration operation: The requested primary is not valid as a replica channel is running on member*");
85 call mtr.add_suppression("Error while executing a group configuration operation: There is a replica channel running in the group's current primary member.");
86 set session sql_log_bin=1;
87
88 --let $rpl_connection_name= server2
89 --source include/rpl_connection.inc
90
91 SET GLOBAL read_only= 0;
92 set session sql_log_bin=0;
93 call mtr.add_suppression("The function 'group_replication_switch_to_single_primary_mode' failed. The requested primary is not valid as a replica channel is running on member*");
94 call mtr.add_suppression("The function 'group_replication_set_as_primary' failed. There is a replica channel running in the group's current primary member.");
95 set session sql_log_bin=1;
96
97 --let $rpl_group_replication_single_primary_mode=1
98 --let $rpl_group_replication_reset_persistent_vars=1
99 --source include/group_replication_end.inc