Debian Codegraph @

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

raw
1 ################################################################################
2 #
3 # Upon starting group replication, the joining node should not have any
4 # transaction on the LAST_CONFLICT_FREE_TRANSACTION field of the group member
5 # stats table.
6 #
7 # This test verifies that the LAST_CONFLICT_FREENTRANSACTION field is empty and
8 # that that empty value is correctly broadcast to the rest of the group,
9 # upon entering.
10 #
11 # Test:
12 # 0) This test will use initially 2 servers and later on will add one more.
13 # 1) Configure a replication group with 2 members
14 # 2) Execute a transaction on the first member
15 # 3) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the
16 # performance_schema.replication_group_members table has the same value
17 # between members
18 # 4) Restart group replication on member 2
19 # 5) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the second member
20 # is empty (due to restart of the plugin) on both members
21 # 6) Add new member
22 # 7) Verify that this new member has an empty LAST_CONFLICT_FREE_TRANSACTION
23 # on himself and in the rest of the group
24 # 8) Execute a new transaction
25 # 9) Verify that everyone has a conflict free transaction executed
26 # 10) Restart group replication on member 1 (primary)
27 # 11) Verify that member 1 has no conflict free transaction on the group
28 # 12) Cleanup
29 #
30 ################################################################################
31
32 --source include/big_test.inc
33 --let $group_replication_group_name= c9f7fc80-034a-45c9-be2b-d738604be275
34 --source include/have_group_replication_plugin.inc
35 --let $rpl_skip_group_replication_start= 1
36 --let $rpl_server_count= 3
37 --source include/group_replication.inc
38
39 --echo
40 --echo #########################################################################
41 --echo # 1) Configure a replication group with 2 members
42 --echo #########################################################################
43 --echo
44 --let $rpl_connection_name= server1
45 --source include/rpl_connection.inc
46 --let $server1_uuid= `SELECT @@GLOBAL.SERVER_UUID`
47 --source include/start_and_bootstrap_group_replication.inc
48 --let $rpl_connection_name= server2
49 --source include/rpl_connection.inc
50 --source include/start_group_replication.inc
51 --let $server2_uuid= `SELECT @@GLOBAL.SERVER_UUID`
52
53 --echo
54 --echo #########################################################################
55 --echo # 2) Execute a transaction on the first member
56 --echo #########################################################################
57 --echo
58 --let $rpl_connection_name= server1
59 --source include/rpl_connection.inc
60 CREATE TABLE t1 (a INT PRIMARY KEY);
61 --source include/rpl_sync.inc
62 ## Wait for member 2 to report a conflict free transaction to member 1
63 --let $wait_condition= SELECT COUNT(*) = 2 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
64 --source include/wait_condition.inc
65
66 --echo
67 --echo #########################################################################
68 --echo # 3) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the
69 --echo # performance_schema.replication_group_members table has the same value
70 --echo # between members
71 --echo #########################################################################
72 --echo
73 --let $rpl_connection_name= server2
74 --source include/rpl_connection.inc
75 ## Wait for member 2 to report a conflict free transaction
76 --let $wait_condition= SELECT COUNT(*) = 2 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
77 --source include/wait_condition.inc
78
79 --let $rpl_connection_name= server1
80 --source include/rpl_connection.inc
81 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
82 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
83 FROM performance_schema.replication_group_member_stats gms
84 JOIN performance_schema.replication_group_members gm
85 ON gms.MEMBER_ID=gm.MEMBER_ID
86 ORDER BY gm.MEMBER_PORT ASC;
87 --let $rpl_connection_name= server2
88 --source include/rpl_connection.inc
89 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
90 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
91 FROM performance_schema.replication_group_member_stats gms
92 JOIN performance_schema.replication_group_members gm
93 ON gms.MEMBER_ID=gm.MEMBER_ID
94 ORDER BY gm.MEMBER_PORT ASC;
95
96 --echo
97 --echo #########################################################################
98 --echo # 4) Restart group replication on member 2
99 --echo #########################################################################
100 --echo
101 --source include/stop_group_replication.inc
102 --source include/start_group_replication.inc
103
104 --echo
105 --echo #########################################################################
106 --echo # 5) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the second
107 --echo # member is empty (due to restart of the plugin) on both members
108 --echo #########################################################################
109 --echo
110 --let $rpl_connection_name= server1
111 --source include/rpl_connection.inc
112 ## Wait for member 2 to have an empty conflict free transaction
113 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server2_uuid' AND LAST_CONFLICT_FREE_TRANSACTION = ''
114 --source include/wait_condition.inc
115 --let $rpl_connection_name= server2
116 --source include/rpl_connection.inc
117 ## Wait for member 2 to have an empty conflict free transaction
118 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server2_uuid' AND LAST_CONFLICT_FREE_TRANSACTION = ''
119 --source include/wait_condition.inc
120 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server1_uuid' AND LAST_CONFLICT_FREE_TRANSACTION <> ''
121 --source include/wait_condition.inc
122
123 --let $rpl_connection_name= server1
124 --source include/rpl_connection.inc
125 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
126 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
127 FROM performance_schema.replication_group_member_stats gms
128 JOIN performance_schema.replication_group_members gm
129 ON gms.MEMBER_ID=gm.MEMBER_ID
130 ORDER BY gm.MEMBER_PORT ASC;
131 --let $rpl_connection_name= server2
132 --source include/rpl_connection.inc
133 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
134 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
135 FROM performance_schema.replication_group_member_stats gms
136 JOIN performance_schema.replication_group_members gm
137 ON gms.MEMBER_ID=gm.MEMBER_ID
138 ORDER BY gm.MEMBER_PORT ASC;
139
140 --echo
141 --echo #########################################################################
142 --echo # 6) Add a new member
143 --echo #########################################################################
144 --echo
145 --let $rpl_connection_name= server3
146 --source include/rpl_connection.inc
147 --source include/start_group_replication.inc
148
149 --echo
150 --echo #########################################################################
151 --echo # 7) Verify that this new member has an empty
152 --echo # LAST_CONFLICT_FREE_TRANSACTION on himself and in the rest of the
153 --echo # group
154 --echo #########################################################################
155 --echo
156 --let $rpl_connection_name= server1
157 --source include/rpl_connection.inc
158 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
159 --source include/wait_condition.inc
160 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
161 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
162 FROM performance_schema.replication_group_member_stats gms
163 JOIN performance_schema.replication_group_members gm
164 ON gms.MEMBER_ID=gm.MEMBER_ID
165 ORDER BY gm.MEMBER_PORT ASC;
166 --let $rpl_connection_name= server2
167 --source include/rpl_connection.inc
168 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
169 --source include/wait_condition.inc
170 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
171 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
172 FROM performance_schema.replication_group_member_stats gms
173 JOIN performance_schema.replication_group_members gm
174 ON gms.MEMBER_ID=gm.MEMBER_ID
175 ORDER BY gm.MEMBER_PORT ASC;
176 --let $rpl_connection_name= server3
177 --source include/rpl_connection.inc
178 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
179 --source include/wait_condition.inc
180 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
181 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
182 FROM performance_schema.replication_group_member_stats gms
183 JOIN performance_schema.replication_group_members gm
184 ON gms.MEMBER_ID=gm.MEMBER_ID
185 ORDER BY gm.MEMBER_PORT ASC;
186
187 --echo
188 --echo #########################################################################
189 --echo # 8) Execute a new transaction
190 --echo #########################################################################
191 --echo
192 --let $rpl_connection_name= server1
193 --source include/rpl_connection.inc
194 INSERT INTO t1 VALUES (1);
195 --source include/rpl_sync.inc
196
197 --echo
198 --echo #########################################################################
199 --echo # 9) Verify that everyone has a conflict free transaction executed
200 --echo #########################################################################
201 --echo
202 --let $rpl_connection_name= server1
203 --source include/rpl_connection.inc
204 ## Wait for every member to report a conflict free transaction
205 --let $wait_condition= SELECT COUNT(*) = 3 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION = '$group_replication_group_name:6'
206 --source include/wait_condition.inc
207 --let $rpl_connection_name= server2
208 --source include/rpl_connection.inc
209 ## Wait for every member to report a conflict free transaction
210 --let $wait_condition= SELECT COUNT(*) = 3 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION = '$group_replication_group_name:6'
211 --source include/wait_condition.inc
212 --let $rpl_connection_name= server3
213 --source include/rpl_connection.inc
214 ## Wait for every member to report a conflict free transaction
215 --let $wait_condition= SELECT COUNT(*) = 3 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION = '$group_replication_group_name:6'
216 --source include/wait_condition.inc
217
218 --let $rpl_connection_name= server1
219 --source include/rpl_connection.inc
220 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
221 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
222 FROM performance_schema.replication_group_member_stats gms
223 JOIN performance_schema.replication_group_members gm
224 ON gms.MEMBER_ID=gm.MEMBER_ID
225 ORDER BY gm.MEMBER_PORT ASC;
226 --let $rpl_connection_name= server2
227 --source include/rpl_connection.inc
228 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
229 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
230 FROM performance_schema.replication_group_member_stats gms
231 JOIN performance_schema.replication_group_members gm
232 ON gms.MEMBER_ID=gm.MEMBER_ID
233 ORDER BY gm.MEMBER_PORT ASC;
234 --let $rpl_connection_name= server3
235 --source include/rpl_connection.inc
236 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
237 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
238 FROM performance_schema.replication_group_member_stats gms
239 JOIN performance_schema.replication_group_members gm
240 ON gms.MEMBER_ID=gm.MEMBER_ID
241 ORDER BY gm.MEMBER_PORT ASC;
242
243 --echo
244 --echo #########################################################################
245 --echo # 10) Restart group replication on member 1
246 --echo #########################################################################
247 --echo
248 --let $rpl_connection_name= server1
249 --source include/rpl_connection.inc
250 --source include/stop_group_replication.inc
251 --source include/start_group_replication.inc
252
253 --echo
254 --echo #########################################################################
255 --echo # 11) Verify that member 1 has no conflict free transaction on the group
256 --echo #########################################################################
257 --echo
258 --let $rpl_connection_name= server1
259 --source include/rpl_connection.inc
260 ## Wait for member 1 to report an empty conflict free transaction
261 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server1_uuid' AND LAST_CONFLICT_FREE_TRANSACTION = ''
262 --source include/wait_condition.inc
263 --let $wait_condition= SELECT COUNT(*) = 2 FROM performance_schema.replication_group_member_stats WHERE LAST_CONFLICT_FREE_TRANSACTION <> ''
264 --source include/wait_condition.inc
265 --let $rpl_connection_name= server2
266 --source include/rpl_connection.inc
267 ## Wait for member 1 to report an empty conflict free transaction
268 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server1_uuid' AND LAST_CONFLICT_FREE_TRANSACTION = ''
269 --source include/wait_condition.inc
270 --let $rpl_connection_name= server3
271 --source include/rpl_connection.inc
272 ## Wait for member 1 to report an empty conflict free transaction
273 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE MEMBER_ID = '$server1_uuid' AND LAST_CONFLICT_FREE_TRANSACTION = ''
274 --source include/wait_condition.inc
275
276 --let $rpl_connection_name= server1
277 --source include/rpl_connection.inc
278 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
279 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
280 FROM performance_schema.replication_group_member_stats gms
281 JOIN performance_schema.replication_group_members gm
282 ON gms.MEMBER_ID=gm.MEMBER_ID
283 ORDER BY gm.MEMBER_PORT ASC;
284 --let $rpl_connection_name= server2
285 --source include/rpl_connection.inc
286 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
287 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
288 FROM performance_schema.replication_group_member_stats gms
289 JOIN performance_schema.replication_group_members gm
290 ON gms.MEMBER_ID=gm.MEMBER_ID
291 ORDER BY gm.MEMBER_PORT ASC;
292 --let $rpl_connection_name= server3
293 --source include/rpl_connection.inc
294 --replace_result $SERVER_MYPORT_1 SERVER1 $SERVER_MYPORT_2 SERVER2 $SERVER_MYPORT_3 SERVER3
295 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
296 FROM performance_schema.replication_group_member_stats gms
297 JOIN performance_schema.replication_group_members gm
298 ON gms.MEMBER_ID=gm.MEMBER_ID
299 ORDER BY gm.MEMBER_PORT ASC;
300
301 --echo
302 --echo #########################################################################
303 --echo # 12) Cleanup
304 --echo #########################################################################
305 --echo
306 DROP TABLE t1;
307 --source include/rpl_sync.inc
308
309 --source include/group_replication_end.inc