Debian Codegraph @

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

raw
1 ###############################################################################
2 # Validate that group_replication_set_as_primary once executed with parameter
3 # `running_transactions_timeout` gracefully fails if there is a running slave
4 # on primary member.
5 # Change of primary fails due to running slave channel on PRIMARY.
6 #
7 # Test:
8 # 0. The test requires three servers:(M1 <> M2) and M3 -> M1
9 # M1(PRIMARY and REPLICA)
10 # M2(SECONDARY)
11 # M3(SOURCE)
12 # 1. Deploy a group in single-primary mode.
13 # Server1(primary) and server2(secondary).
14 # Create and start asynchronous connection with server3 as source and server1 as replica.
15 # 2. Create table t1 on server3 for later operations.
16 # 3. Block all transactions on server1.
17 # Create a new transaction on server3.
18 # Initiate a change of primary on server1, it fails due to slave channel on server1.
19 # Unblock all transactions on server1.
20 # 4. Block all transactions on server1.
21 # Create a new transaction on server3.
22 # Initiate a change of primary on server2, it fails due to slave channel on server1.
23 # Unblock all transactions on server1.
24 # 5. Clean up.
25 ###############################################################################
26
27 --source include/big_test.inc
28 --source include/have_debug_sync.inc
29 --source include/have_group_replication_plugin.inc
30 --let $rpl_group_replication_single_primary_mode=1
31 --let $rpl_skip_group_replication_start= 1
32 --let $rpl_server_count= 3
33 --source include/group_replication.inc
34
35
36 --echo
37 --echo # 1. Deploy a group in single-primary mode.
38 --echo # Server1(primary) and server2(secondary).
39 --echo # Create and start asynchronous connection with server3 as source and server1 as replica.
40
41 --let $rpl_connection_name= server1
42 --source include/rpl_connection.inc
43
44 set session sql_log_bin=0;
45 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.");
46 set session sql_log_bin=1;
47 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
48
49 --source include/start_and_bootstrap_group_replication.inc
50
51 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
52 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=$SERVER_MYPORT_3 FOR CHANNEL 'gr_channel'
53 --let $rpl_channel_name='gr_channel'
54 --source include/start_slave.inc
55
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58
59 set session sql_log_bin=0;
60 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.");
61 set session sql_log_bin=1;
62 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
63
64 --source include/start_group_replication.inc
65
66 --echo
67 --echo # 2. Create table t1 on server3 for later operations.
68
69 --let $rpl_connection_name= server3
70 --source include/rpl_connection.inc
71
72 CREATE TABLE t1(c1 int primary key);
73 --source include/rpl_sync.inc
74
75 --echo
76 --echo # 3. Block all transactions on server1.
77 --echo # Create a new transaction on server3.
78 --echo # Initiate a change of primary on server1, it fails due to slave channel on server1.
79 --echo # Unblock all transactions on server1.
80
81 --let $rpl_connection_name= server1
82 --source include/rpl_connection.inc
83
84 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_on_observer_trans';
85
86 --let $rpl_connection_name= server3
87 --source include/rpl_connection.inc
88
89 INSERT INTO t1 values(1);
90
91 --let $rpl_connection_name= server1
92 --source include/rpl_connection.inc
93
94 SET DEBUG_SYNC= "now wait_for signal.group_replication_wait_on_observer_trans_waiting";
95
96 # NOTE: Now we have to unblock begin otherwise UDF will also block
97 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_on_observer_trans';
98
99 --replace_result $server2_uuid SERVER2_UUID
100 --error ER_GRP_RPL_UDF_ERROR
101 --eval SELECT group_replication_set_as_primary("$server2_uuid", 0);
102
103 --let $rpl_connection_name= server1
104 --source include/rpl_connection.inc
105
106 SET DEBUG_SYNC= "now SIGNAL signal.group_replication_wait_on_observer_trans_continue";
107
108 --source include/gr_assert_primary_member.inc
109
110 --let $rpl_connection_name= server2
111 --source include/rpl_connection.inc
112
113 --source include/gr_assert_secondary_member.inc
114
115
116 --echo
117 --echo # 4. Block all transactions on server1.
118 --echo # Create a new transaction on server3.
119 --echo # Initiate a change of primary on server2, it fails due to slave channel on server1.
120 --echo # Unblock all transactions on server1.
121
122 --let $rpl_connection_name= server1
123 --source include/rpl_connection.inc
124
125 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_on_observer_trans';
126
127 --let $rpl_connection_name= server3
128 --source include/rpl_connection.inc
129
130 INSERT INTO t1 values(2);
131
132 --let $rpl_connection_name= server1
133 --source include/rpl_connection.inc
134
135 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
136
137 --let $rpl_connection_name= server2
138 --source include/rpl_connection.inc
139
140 --replace_result $server2_uuid SERVER2_UUID
141 --error ER_GRP_RPL_UDF_ERROR
142 --eval SELECT group_replication_set_as_primary("$server2_uuid", 0);
143
144 --let $rpl_connection_name= server1
145 --source include/rpl_connection.inc
146
147 SET DEBUG_SYNC= "now SIGNAL signal.group_replication_wait_on_observer_trans_continue";
148 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_on_observer_trans';
149
150 --source include/gr_assert_primary_member.inc
151
152 --let $rpl_connection_name= server2
153 --source include/rpl_connection.inc
154
155 --source include/gr_assert_secondary_member.inc
156
157 --echo
158 --echo # 5. Clean up.
159
160 --let $rpl_connection_name= server3
161 --source include/rpl_connection.inc
162 DROP TABLE t1;
163 --source include/rpl_sync.inc
164
165 --let $rpl_connection_name= server1
166 --source include/rpl_connection.inc
167
168 --let $rpl_channel_name='gr_channel'
169 --source include/stop_slave.inc
170
171 --let $rpl_channel_name='gr_channel'
172 --let $rpl_multi_source= 1
173 --let $rpl_reset_slave_all= 1
174 --source include/rpl_reset_slave.inc
175 --let $rpl_channel_name=
176 --let $rpl_multi_source=
177
178 --source include/group_replication_end.inc