Debian Codegraph @

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

raw
1 ################################################################################
2 # This test validates UDF group_replication_set_as_primary and confirms
3 # that connection running a START TRANSACTION that did not reach commit stage
4 # is disconnected when UDF group_replication_set_as_primary is executed.
5 # UDF group_replication_set_as_primary runs successfully and primary is changed.
6 #
7 # Test:
8 # 0. The test requires two servers: M1 and M2.
9 # 1. Start group in single primary mode.
10 # Server1 will be primary and server2 secondary.
11 # 2. Execute "START TRANSACTION" on server1.
12 # 3. Begin change of primary from server2(secondary).
13 # 4. Assert primary changed.
14 # 5. Transaction on server1 should fail, since it blocks the UDF.
15 # Client connection is dropped.
16 # 6. Execute "START TRANSACTION" on server2.
17 # 7. Begin change of primary from server2(primary).
18 # 8. Assert primary changed.
19 # 9. Transaction on server2 should fail, since it blocks the UDF.
20 # Client connection is dropped.
21 # 10. Execute "BEGIN WORK" on server1.
22 # 11. Begin change of primary from server2(secondary).
23 # 12. Assert primary changed.
24 # 13. Transaction on server1 should fail, since it blocks the UDF.
25 # Client connection is dropped.
26 # 14. Execute "BEGIN WORK" on server2.
27 # 15. Begin change of primary from server2(primary).
28 # 16. Assert primary changed.
29 # 17. Transaction on server2 should fail, since it blocks the UDF.
30 # Client connection is dropped.
31 # 18. Cleanup.
32 ################################################################################
33 --source include/have_group_replication_plugin.inc
34 --let $rpl_skip_group_replication_start= 1
35 --let $rpl_group_replication_single_primary_mode=1
36 --source include/group_replication.inc
37
38 --echo
39 --echo # 1. Start group in single primary mode.
40 --echo # Server1 will be primary and server2 secondary.
41
42 --let $rpl_connection_name= server1
43 --source include/rpl_connection.inc
44
45 CREATE TABLE test.t1(c1 int primary key);
46 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
47 --source include/start_and_bootstrap_group_replication.inc
48
49 --let $rpl_connection_name= server2
50 --source include/rpl_connection.inc
51
52 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
53 --source include/start_group_replication.inc
54
55 --echo
56 --echo # 2. Execute "START TRANSACTION" on server1.
57
58 --let $rpl_connection_name= server1
59 --source include/rpl_connection.inc
60
61 START TRANSACTION;
62
63 --echo
64 --echo # 3. Begin change of primary from server2(secondary).
65
66 --let $rpl_connection_name= server2
67 --source include/rpl_connection.inc
68
69 --replace_result $server2_uuid MEMBER2_UUID
70 --eval SELECT group_replication_set_as_primary("$server2_uuid",3)
71
72 --echo
73 --echo # 4. Assert primary changed.
74
75 --let $rpl_connection_name= server2
76 --source include/rpl_connection.inc
77
78 --source include/gr_assert_primary_member.inc
79
80 --let $rpl_connection_name= server_1
81 --source include/rpl_connection.inc
82
83 --source include/gr_assert_secondary_member.inc
84
85 --echo
86 --echo # 5. Transaction on server1 should fail, since it blocks the UDF.
87 --echo # Client connection is dropped.
88
89 --let $rpl_connection_name= server1
90 --source include/rpl_connection.inc
91
92 --error CR_SERVER_LOST
93 --enable_reconnect
94 --source include/wait_until_connected_again.inc
95 --disable_reconnect
96
97 --echo
98 --echo # 6. Execute "START TRANSACTION" on server2.
99
100 --let $rpl_connection_name= server2
101 --source include/rpl_connection.inc
102
103 START TRANSACTION;
104 SELECT * FROM test.t1;
105
106 --echo
107 --echo # 7. Begin change of primary from server2(primary).
108
109 --let $rpl_connection_name= server_2
110 --source include/rpl_connection.inc
111
112 --replace_result $server1_uuid MEMBER2_UUID
113 --eval SELECT group_replication_set_as_primary("$server1_uuid",1)
114
115 --echo
116 --echo # 8. Assert primary changed.
117
118 --let $rpl_connection_name= server1
119 --source include/rpl_connection.inc
120
121 --source include/gr_assert_primary_member.inc
122
123 --let $rpl_connection_name= server_2
124 --source include/rpl_connection.inc
125
126 --source include/gr_assert_secondary_member.inc
127
128 --echo
129 --echo # 9. Transaction on server2 should fail, since it blocks the UDF.
130 --echo # Client connection is dropped.
131
132 --let $rpl_connection_name= server2
133 --source include/rpl_connection.inc
134
135 --error CR_SERVER_LOST
136 --enable_reconnect
137 --source include/wait_until_connected_again.inc
138 --disable_reconnect
139
140 --echo
141 --echo # 10. Execute "BEGIN WORK" on server1.
142
143 --let $rpl_connection_name= server1
144 --source include/rpl_connection.inc
145
146 BEGIN WORK;
147
148 --echo
149 --echo # 11. Begin change of primary from server2(secondary).
150
151 --let $rpl_connection_name= server2
152 --source include/rpl_connection.inc
153
154 --replace_result $server2_uuid MEMBER2_UUID
155 --eval SELECT group_replication_set_as_primary("$server2_uuid",3)
156
157 --echo
158 --echo # 12. Assert primary changed.
159
160 --let $rpl_connection_name= server2
161 --source include/rpl_connection.inc
162
163 --source include/gr_assert_primary_member.inc
164
165 --let $rpl_connection_name= server_1
166 --source include/rpl_connection.inc
167
168 --source include/gr_assert_secondary_member.inc
169
170 --echo
171 --echo # 13. Transaction on server1 should fail, since it blocks the UDF.
172 --echo # Client connection is dropped.
173
174 --let $rpl_connection_name= server1
175 --source include/rpl_connection.inc
176
177 --error CR_SERVER_LOST
178 --enable_reconnect
179 --source include/wait_until_connected_again.inc
180 --disable_reconnect
181
182 --echo
183 --echo # 14. Execute "BEGIN WORK" on server2.
184
185 --let $rpl_connection_name= server2
186 --source include/rpl_connection.inc
187
188 BEGIN WORK;
189 SELECT * FROM test.t1;
190
191 --echo
192 --echo # 15. Begin change of primary from server2(primary).
193
194 --let $rpl_connection_name= server_2
195 --source include/rpl_connection.inc
196
197 --replace_result $server1_uuid MEMBER2_UUID
198 --eval SELECT group_replication_set_as_primary("$server1_uuid",1)
199
200 --echo
201 --echo # 16. Assert primary changed.
202
203 --let $rpl_connection_name= server1
204 --source include/rpl_connection.inc
205
206 --source include/gr_assert_primary_member.inc
207
208 --let $rpl_connection_name= server_2
209 --source include/rpl_connection.inc
210
211 --source include/gr_assert_secondary_member.inc
212
213 --echo
214 --echo # 17. Transaction on server2 should fail, since it blocks the UDF.
215 --echo # Client connection is dropped.
216
217 --let $rpl_connection_name= server2
218 --source include/rpl_connection.inc
219
220 --error CR_SERVER_LOST
221 --enable_reconnect
222 --source include/wait_until_connected_again.inc
223 --disable_reconnect
224
225 --echo
226 --echo # 18. Cleanup.
227
228 --let $rpl_connection_name= server1
229 --source include/rpl_connection.inc
230
231 DROP TABLE test.t1;
232
233 --source include/group_replication_end.inc