Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # This test checks if the original_server_version and immediate_server_version
4 # are generated and replicated correctly inside a group.
5 #
6 # 0. The test uses 4 servers in a setup that includes a GR group in multi
7 # primary mode and asynchronous slave connections.
8 # 1. Start two members of the group (server2 and server3).
9 # 2. Execute a transaction on each of these two servers. Server3 will have a
10 # pre-determined server version, set by a debug point-
11 # 3. Synchronize the group and start a third member (server4).
12 # 4. Make the following assertions on the executed transactions:
13 # 4.1. The original_server_version is the same accross all servers and
14 # immediate_server_version is generated correctly.
15 # 4.2. Transactions consisting of view change events have their
16 # original_server_version set to their own server version.
17 # 5. Run transactions on the server outside the group (server1) and synchronize
18 # the group.
19 # 6. Assert that the original_server_version and immediate_server_version of
20 # these transactions generated outside the group are correctly replicated and
21 # generated.
22 # 7. Cleanup.
23 #
24 # ==== References ====
25 #
26 # WL#11879 replicate original server version
27
28 --source include/have_debug.inc
29 # needed so that GTIDs are deterministic
30 --source include/have_group_replication_gtid_assignment_block_size_1.inc
31 --source include/have_group_replication_plugin.inc
32 --let $rpl_skip_group_replication_start = 1
33 --let $rpl_server_count = 4
34 --let $rpl_multi_source = 1
35 --source include/group_replication.inc
36
37 # transform server version in format AA.BB.CC[-suffix] into AABBCC
38 --write_file $MYSQL_TMP_DIR/get_numerical_server_version.inc
39 --let $server_version = `SELECT @@GLOBAL.version`
40 --let $major_version_number = `SELECT SUBSTRING_INDEX('$server_version', '.', 1)`
41 --let $mid_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '.', 2), '.', -1)`
42 --let $minor_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '-', 1), '.', -1)`
43 --let $numerical_server_version = `SELECT $major_version_number * 10000 + $mid_version_number * 100 + $minor_version_number`
44 EOF
45
46 # start first member of the group
47 --let $rpl_connection_name = server2
48 --source include/rpl_connection.inc
49 --source include/start_and_bootstrap_group_replication.inc
50 # this group member is also a slave of server1
51 # (server2 was implicitely set up as slave of server1 in include/group_replication.inc)
52 --source include/start_slave.inc
53
54 # start second member of the group
55 --let $rpl_connection_name = server3
56 --source include/rpl_connection.inc
57 --source include/start_group_replication.inc
58
59 # execute a transaction on server2
60 --let $rpl_connection_name = server2
61 --source include/rpl_connection.inc
62 CREATE TABLE t1(a INT PRIMARY KEY);
63 # sync group
64 --let $rpl_connection_name= server2
65 --source include/rpl_connection.inc
66 --let $sync_slave_connection= server3
67 --source include/sync_slave_sql_with_master.inc
68
69 # execute a transaction on server3, forcing its original_server_version to be
70 # 777777 in order to check that the value is replicated unchanged. Also force
71 # immediate_server_version to be 777777 to check that it is generated correctly
72 --let $rpl_connection_name = server3
73 --source include/rpl_connection.inc
74 --let $debug_point = gr_fixed_server_version
75 --source include/add_debug_point.inc
76 DROP TABLE t1;
77 # sync group
78 --let $rpl_connection_name= server2
79 --source include/rpl_connection.inc
80 --let $sync_slave_connection= server3
81 --source include/sync_slave_sql_with_master.inc
82
83 # start third member of the group (which will be synced with the group as it joins)
84 --let $rpl_connection_name = server4
85 --source include/rpl_connection.inc
86 --source include/start_group_replication.inc
87
88 # check if the original_server_version from the CREATE TABLE transaction from
89 # server2 was propagated correctly, immediate_server_version was generated
90 # correctly and that the immediate_server_version was replicated correctly to
91 # server3 through the GR applier channel.
92 --let $gtid = $group_replication_group_name:3
93
94 --let $rpl_connection_name = server2
95 --source include/rpl_connection.inc
96 --source include/get_original_server_version.inc
97 --let $OSV_2 = $original_server_version
98 --source include/get_immediate_server_version.inc
99 --let $ISV_2 = $immediate_server_version
100 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
101 --let $numerical_server_version_2 = $numerical_server_version
102
103 --let $rpl_connection_name = server3
104 --source include/rpl_connection.inc
105 --source include/get_original_server_version.inc
106 --let $OSV_3 = $original_server_version
107 --source include/get_immediate_server_version.inc
108 --let $ISV_3 = $immediate_server_version
109 --let $log_file = $server_3_datadir/server-relay-log-group_replication_applier.000002
110 --source include/get_immediate_server_version.inc
111 --let $relay_log_ISV_3 = $immediate_server_version
112 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
113 --let $numerical_server_version_3 = $numerical_server_version
114
115 --let $rpl_connection_name = server4
116 --source include/rpl_connection.inc
117 --source include/get_original_server_version.inc
118 --let $OSV_4 = $original_server_version
119 --source include/get_immediate_server_version.inc
120 --let $ISV_4 = $immediate_server_version
121 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
122 --let $numerical_server_version_4 = $numerical_server_version
123
124 --let $assert_text = server2 original_server_version must be equal to its own server version
125 --let $assert_cond = $numerical_server_version_2 = $OSV_2
126 --source include/assert.inc
127
128 --let $assert_text = server3 original_server_version must be equal to server2
129 --let $assert_cond = $OSV_3 = $OSV_2
130 --source include/assert.inc
131
132 --let $assert_text = server4 original_server_version must be equal to server2
133 --let $assert_cond = $OSV_4 = $OSV_2
134 --source include/assert.inc
135
136 --let $assert_text = server2 immediate_server_version must be equal its own server version
137 --let $assert_cond = $ISV_2 = $numerical_server_version_2
138 --source include/assert.inc
139
140 --let $assert_text = server3 immediate_server_version must be equal its own server version
141 --let $assert_cond = $ISV_3 = $numerical_server_version_3
142 --source include/assert.inc
143
144 --let $assert_text = server4 immediate_server_version must be equal its own server version
145 --let $assert_cond = $ISV_4 = $numerical_server_version_4
146 --source include/assert.inc
147
148 --let $assert_text = server3 immediate_server_version in the applier relay log must be equal to server2 ISV
149 --let $assert_cond = $relay_log_ISV_3 = $ISV_2
150 --source include/assert.inc
151
152
153 # check if the original_server_version from the DROP TABLE transaction from
154 # server3 was propagated correctly and if immediate_server_version was generated
155 # correctly
156 --let $gtid = $group_replication_group_name:4
157
158 --let $rpl_connection_name = server2
159 --source include/rpl_connection.inc
160 --source include/get_original_server_version.inc
161 --let $OSV_2 = $original_server_version
162 --source include/get_immediate_server_version.inc
163 --let $ISV_2 = $immediate_server_version
164
165 --let $rpl_connection_name = server3
166 --source include/rpl_connection.inc
167 --source include/get_original_server_version.inc
168 --let $OSV_3 = $original_server_version
169 --source include/get_immediate_server_version.inc
170 --let $ISV_3 = $immediate_server_version
171
172 --let $rpl_connection_name = server4
173 --source include/rpl_connection.inc
174 --source include/get_original_server_version.inc
175 --let $OSV_4 = $original_server_version
176 --source include/get_immediate_server_version.inc
177 --let $ISV_4 = $immediate_server_version
178
179 --let $assert_text = server3 original_server_version must be equal to 777777
180 --let $assert_cond = $OSV_3 = 777777
181 --source include/assert.inc
182
183 --let $assert_text = server2 original_server_version must be equal to server3
184 --let $assert_cond = $OSV_2 = $OSV_3
185 --source include/assert.inc
186
187 --let $assert_text = server4 original_server_version must be equal to server3
188 --let $assert_cond = $OSV_4 = $OSV_3
189 --source include/assert.inc
190
191 --let $assert_text = server2 immediate_server_version must be equal to its own server version
192 --let $assert_cond = $ISV_2 = $numerical_server_version_2
193 --source include/assert.inc
194
195 --let $assert_text = server3 immediate_server_version must be equal to 777777
196 --let $assert_cond = $ISV_3 = 777777
197 --source include/assert.inc
198
199 --let $assert_text = server4 immediate_server_version must be equal to its own server version
200 --let $assert_cond = $ISV_4 = $numerical_server_version_4
201 --source include/assert.inc
202
203
204 # check the View_change log event generated when server 4 joined
205 --let $gtid = $group_replication_group_name:1
206
207 --let $rpl_connection_name = server2
208 --source include/rpl_connection.inc
209 --source include/get_original_server_version.inc
210 --let $OSV_2 = $original_server_version
211 --source include/get_immediate_server_version.inc
212 --let $ISV_2 = $immediate_server_version
213
214 --let $rpl_connection_name = server3
215 --source include/rpl_connection.inc
216 --source include/get_original_server_version.inc
217 --let $OSV_3 = $original_server_version
218 --source include/get_immediate_server_version.inc
219 --let $ISV_3 = $immediate_server_version
220
221 --let $rpl_connection_name = server4
222 --source include/rpl_connection.inc
223 --source include/get_original_server_version.inc
224 --let $OSV_4 = $original_server_version
225 --source include/get_immediate_server_version.inc
226 --let $ISV_4 = $immediate_server_version
227
228 --let $assert_text = server2 original_server_version must be equal to its own server_version
229 --let $assert_cond = $OSV_2 = $numerical_server_version_2
230 --source include/assert.inc
231
232 --let $assert_text = server3 original_server_version must be equal to its own server_version
233 --let $assert_cond = $OSV_3 = $numerical_server_version_3
234 --source include/assert.inc
235
236 --let $assert_text = server4 original_server_version must be equal to its own server_version
237 --let $assert_cond = $OSV_4 = $numerical_server_version_4
238 --source include/assert.inc
239
240 --let $assert_text = server2 immediate_server_version must be equal to its own server_version
241 --let $assert_cond = $ISV_2 = $numerical_server_version_2
242 --source include/assert.inc
243
244 --let $assert_text = server3 immediate_server_version must be equal to its own server_version
245 --let $assert_cond = $ISV_3 = $numerical_server_version_3
246 --source include/assert.inc
247
248 --let $assert_text = server4 immediate_server_version must be equal to its own server_version
249 --let $assert_cond = $ISV_4 = $numerical_server_version_4
250 --source include/assert.inc
251
252 # run transactions on server1
253 --let $rpl_connection_name = server1
254 --source include/rpl_connection.inc
255
256 # force transactions issued by this server to have 888888 has server version
257 --let $debug_point = fixed_server_version
258 --source include/add_debug_point.inc
259
260 --let $server1_uuid = query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
261
262 CREATE TABLE t2 (a INT PRIMARY KEY);
263 DROP TABLE t2;
264
265 # sync server2 with its master, server1
266 --let $sync_slave_connection = server2
267 --source include/sync_slave_sql_with_master.inc
268 --let $sync_slave_connection =
269 # sync group
270 --let $rpl_connection_name= server2
271 --source include/rpl_connection.inc
272 --let $sync_slave_connection= server3
273 --source include/sync_slave_sql_with_master.inc
274 --let $rpl_connection_name= server2
275 --source include/rpl_connection.inc
276 --let $sync_slave_connection= server4
277 --source include/sync_slave_sql_with_master.inc
278
279 # check if transactions from outside the group have the expected
280 # original_server_version and immediate_server_version
281 --let $gtid = $server1_uuid:1
282
283 --let $rpl_connection_name = server1
284 --source include/rpl_connection.inc
285 --source include/get_original_server_version.inc
286 --let $OSV_1 = $original_server_version
287 --source include/get_immediate_server_version.inc
288 --let $ISV_1 = $immediate_server_version
289
290 --let $rpl_connection_name = server2
291 --source include/rpl_connection.inc
292 --source include/get_original_server_version.inc
293 --let $OSV_2 = $original_server_version
294 --source include/get_immediate_server_version.inc
295 --let $ISV_2 = $immediate_server_version
296
297 --let $rpl_connection_name = server3
298 --source include/rpl_connection.inc
299 --source include/get_original_server_version.inc
300 --let $OSV_3 = $original_server_version
301 --source include/get_immediate_server_version.inc
302 --let $ISV_3 = $immediate_server_version
303
304 --let $rpl_connection_name = server4
305 --source include/rpl_connection.inc
306 --source include/get_original_server_version.inc
307 --let $OSV_4 = $original_server_version
308 --source include/get_immediate_server_version.inc
309 --let $ISV_4 = $immediate_server_version
310
311 --let $assert_text = server1 original_server_version must be equal to 888888
312 --let $assert_cond = $OSV_1 = 888888
313 --source include/assert.inc
314
315 --let $assert_text = server2 original_server_version must be equal to server1
316 --let $assert_cond = $OSV_2 = $OSV_1
317 --source include/assert.inc
318
319 --let $assert_text = server3 original_server_version must be equal to server1
320 --let $assert_cond = $OSV_3 = $OSV_1
321 --source include/assert.inc
322
323 --let $assert_text = server4 original_server_version must be equal to server1
324 --let $assert_cond = $OSV_4 = $OSV_1
325 --source include/assert.inc
326
327 --let $assert_text = server1 immediate_server_version must be equal to 888888
328 --let $assert_cond = $ISV_1 = 888888
329 --source include/assert.inc
330
331 --let $assert_text = server2 immediate_server_version must be equal to its own server version
332 --let $assert_cond = $ISV_2 = $numerical_server_version_2
333 --source include/assert.inc
334
335 # the debug point has not been removed yet, which means that the immediate
336 # server version must still be 777777
337 --let $assert_text = server3 immediate_server_version must be equal to 777777
338 --let $assert_cond = $ISV_3 = 777777
339 --source include/assert.inc
340
341 --let $assert_text = server4 immediate_server_version must be equal to its own server version
342 --let $assert_cond = $ISV_4 = $numerical_server_version_4
343 --source include/assert.inc
344
345 # cleanup
346 --let $rpl_connection_name = server1
347 --source include/rpl_connection.inc
348 --let $debug_point = fixed_server_version
349 --source include/remove_debug_point.inc
350
351 --let $rpl_connection_name = server3
352 --source include/rpl_connection.inc
353 --let $debug_point = gr_fixed_server_version
354 --source include/remove_debug_point.inc
355
356 --let $rpl_connection_name= server2
357 --source include/rpl_connection.inc
358 --let $rpl_channel_name= 'channel_1'
359 --source include/stop_slave.inc
360 --source include/rpl_reset_slave.inc
361
362 --let $rpl_skip_sync= 1
363 --source include/group_replication_end.inc
364 --remove_file $MYSQL_TMP_DIR/get_numerical_server_version.inc