Debian Codegraph @

mysql-test/suite/group_replication/r/gr_replication_timestamps.result

raw
1 include/group_replication.inc [rpl_server_count=5]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [connection server2]
7 include/start_and_bootstrap_group_replication.inc
8 include/start_slave.inc
9 [connection server3]
10 include/start_group_replication.inc
11 [connection server2]
12 include/rpl_gr_wait_for_number_of_members.inc
13 [connection server3]
14 include/assert.inc [QUEUEING_TRANSACTION was cleared in the group_replication_recovery channel after the member is online]
15 include/assert.inc [LAST_QUEUED_TRANSACTION was cleared in the group_replication_recovery channel after the member is online]
16 include/assert.inc [LAST_APPLIED_TRANSACTION is not cleared because channel group_replication_recovery applied view change log events for joining the group]
17 [connection server4]
18 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=SERVER_MYPORT_2, SOURCE_USER='root', SOURCE_AUTO_POSITION=1;
19 include/start_slave.inc
20 [connection server1]
21 CREATE DATABASE db1;
22 CREATE TABLE db1.t1(a INT PRIMARY KEY);
23 INSERT INTO db1.t1 VALUES(1);
24 UPDATE db1.t1 SET a= 2;
25 DELETE FROM db1.t1 WHERE a= 1;
26 DROP TABLE db1.t1;
27 DROP DATABASE db1;
28 include/sync_slave_sql_with_master.inc
29 [connection server2]
30 include/sync_slave_sql_with_master.inc
31 [connection server2]
32 include/sync_slave_sql_with_master.inc
33 [connection server2]
34 CREATE DATABASE db1;
35 CREATE TABLE db1.t1(a INT PRIMARY KEY);
36 INSERT INTO db1.t1 VALUES(1);
37 UPDATE db1.t1 SET a= 2;
38 DELETE FROM db1.t1 WHERE a= 1;
39 DROP TABLE db1.t1;
40 DROP DATABASE db1;
41 [connection server2]
42 include/sync_slave_sql_with_master.inc
43 [connection server2]
44 include/sync_slave_sql_with_master.inc
45 [connection server5]
46 include/start_group_replication.inc
47 # 1. Save both timestamps (original/immediate) on all servers.
48 [connection server1]
49 [connection server2]
50 # 2. Verify that the timestamps are correct.
51 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
52 include/assert.inc [Assert that OCT is the same as ICT on server1]
53 include/assert.inc [Assert that ICT increases from server1 to server2]
54 # 1. Save both timestamps (original/immediate) on all servers.
55 [connection server1]
56 [connection server2]
57 [connection server4]
58 # 2. Verify that the timestamps are correct.
59 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
60 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
61 include/assert.inc [Assert that OCT is the same as ICT on server1]
62 include/assert.inc [Assert that ICT > OCT on server2.]
63 include/assert.inc [Assert that ICT > OCT on server4.]
64 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
65 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
66 # 1. Save both timestamps (original/immediate) on all servers.
67 [connection server2]
68 [connection server3]
69 # 2. Verify that the timestamps are correct.
70 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
71 include/assert.inc [Assert that OCT is smaller than ICT on server2]
72 include/assert.inc [Assert that OCT is smaller than ICT on server3]
73 # 1. Save both timestamps (original/immediate) on all servers.
74 [connection server2]
75 [connection server5]
76 # 2. Verify that the timestamps are correct.
77 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
78 include/assert.inc [Assert that OCT is smaller than ICT on server2]
79 include/assert.inc [Assert that OCT is smaller than ICT on server5]
80 # 1. Save both timestamps (original/immediate) on all servers.
81 [connection server1]
82 [connection server2]
83 # 2. Verify that the timestamps are correct.
84 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
85 include/assert.inc [Assert that OCT is the same as ICT on server1]
86 include/assert.inc [Assert that ICT increases from server1 to server2]
87 # 1. Save both timestamps (original/immediate) on all servers.
88 [connection server1]
89 [connection server2]
90 [connection server4]
91 # 2. Verify that the timestamps are correct.
92 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
93 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
94 include/assert.inc [Assert that OCT is the same as ICT on server1]
95 include/assert.inc [Assert that ICT > OCT on server2.]
96 include/assert.inc [Assert that ICT > OCT on server4.]
97 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
98 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
99 # 1. Save both timestamps (original/immediate) on all servers.
100 [connection server2]
101 [connection server3]
102 # 2. Verify that the timestamps are correct.
103 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
104 include/assert.inc [Assert that OCT is smaller than ICT on server2]
105 include/assert.inc [Assert that OCT is smaller than ICT on server3]
106 # 1. Save both timestamps (original/immediate) on all servers.
107 [connection server2]
108 [connection server5]
109 # 2. Verify that the timestamps are correct.
110 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
111 include/assert.inc [Assert that OCT is smaller than ICT on server2]
112 include/assert.inc [Assert that OCT is smaller than ICT on server5]
113 # 1. Save both timestamps (original/immediate) on all servers.
114 [connection server1]
115 [connection server2]
116 # 2. Verify that the timestamps are correct.
117 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
118 include/assert.inc [Assert that OCT is the same as ICT on server1]
119 include/assert.inc [Assert that ICT increases from server1 to server2]
120 # 1. Save both timestamps (original/immediate) on all servers.
121 [connection server1]
122 [connection server2]
123 [connection server4]
124 # 2. Verify that the timestamps are correct.
125 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
126 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
127 include/assert.inc [Assert that OCT is the same as ICT on server1]
128 include/assert.inc [Assert that ICT > OCT on server2.]
129 include/assert.inc [Assert that ICT > OCT on server4.]
130 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
131 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
132 # 1. Save both timestamps (original/immediate) on all servers.
133 [connection server2]
134 [connection server3]
135 # 2. Verify that the timestamps are correct.
136 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
137 include/assert.inc [Assert that OCT is smaller than ICT on server2]
138 include/assert.inc [Assert that OCT is smaller than ICT on server3]
139 # 1. Save both timestamps (original/immediate) on all servers.
140 [connection server2]
141 [connection server5]
142 # 2. Verify that the timestamps are correct.
143 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
144 include/assert.inc [Assert that OCT is smaller than ICT on server2]
145 include/assert.inc [Assert that OCT is smaller than ICT on server5]
146 # 1. Save both timestamps (original/immediate) on all servers.
147 [connection server1]
148 [connection server2]
149 # 2. Verify that the timestamps are correct.
150 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
151 include/assert.inc [Assert that OCT is the same as ICT on server1]
152 include/assert.inc [Assert that ICT increases from server1 to server2]
153 # 1. Save both timestamps (original/immediate) on all servers.
154 [connection server1]
155 [connection server2]
156 [connection server4]
157 # 2. Verify that the timestamps are correct.
158 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
159 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
160 include/assert.inc [Assert that OCT is the same as ICT on server1]
161 include/assert.inc [Assert that ICT > OCT on server2.]
162 include/assert.inc [Assert that ICT > OCT on server4.]
163 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
164 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
165 # 1. Save both timestamps (original/immediate) on all servers.
166 [connection server2]
167 [connection server3]
168 # 2. Verify that the timestamps are correct.
169 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
170 include/assert.inc [Assert that OCT is smaller than ICT on server2]
171 include/assert.inc [Assert that OCT is smaller than ICT on server3]
172 # 1. Save both timestamps (original/immediate) on all servers.
173 [connection server2]
174 [connection server5]
175 # 2. Verify that the timestamps are correct.
176 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
177 include/assert.inc [Assert that OCT is smaller than ICT on server2]
178 include/assert.inc [Assert that OCT is smaller than ICT on server5]
179 # 1. Save both timestamps (original/immediate) on all servers.
180 [connection server1]
181 [connection server2]
182 # 2. Verify that the timestamps are correct.
183 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
184 include/assert.inc [Assert that OCT is the same as ICT on server1]
185 include/assert.inc [Assert that ICT increases from server1 to server2]
186 # 1. Save both timestamps (original/immediate) on all servers.
187 [connection server1]
188 [connection server2]
189 [connection server4]
190 # 2. Verify that the timestamps are correct.
191 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
192 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
193 include/assert.inc [Assert that OCT is the same as ICT on server1]
194 include/assert.inc [Assert that ICT > OCT on server2.]
195 include/assert.inc [Assert that ICT > OCT on server4.]
196 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
197 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
198 # 1. Save both timestamps (original/immediate) on all servers.
199 [connection server2]
200 [connection server3]
201 # 2. Verify that the timestamps are correct.
202 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
203 include/assert.inc [Assert that OCT is smaller than ICT on server2]
204 include/assert.inc [Assert that OCT is smaller than ICT on server3]
205 # 1. Save both timestamps (original/immediate) on all servers.
206 [connection server2]
207 [connection server5]
208 # 2. Verify that the timestamps are correct.
209 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
210 include/assert.inc [Assert that OCT is smaller than ICT on server2]
211 include/assert.inc [Assert that OCT is smaller than ICT on server5]
212 # 1. Save both timestamps (original/immediate) on all servers.
213 [connection server1]
214 [connection server2]
215 # 2. Verify that the timestamps are correct.
216 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
217 include/assert.inc [Assert that OCT is the same as ICT on server1]
218 include/assert.inc [Assert that ICT increases from server1 to server2]
219 # 1. Save both timestamps (original/immediate) on all servers.
220 [connection server1]
221 [connection server2]
222 [connection server4]
223 # 2. Verify that the timestamps are correct.
224 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
225 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
226 include/assert.inc [Assert that OCT is the same as ICT on server1]
227 include/assert.inc [Assert that ICT > OCT on server2.]
228 include/assert.inc [Assert that ICT > OCT on server4.]
229 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
230 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
231 # 1. Save both timestamps (original/immediate) on all servers.
232 [connection server2]
233 [connection server3]
234 # 2. Verify that the timestamps are correct.
235 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
236 include/assert.inc [Assert that OCT is smaller than ICT on server2]
237 include/assert.inc [Assert that OCT is smaller than ICT on server3]
238 # 1. Save both timestamps (original/immediate) on all servers.
239 [connection server2]
240 [connection server5]
241 # 2. Verify that the timestamps are correct.
242 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
243 include/assert.inc [Assert that OCT is smaller than ICT on server2]
244 include/assert.inc [Assert that OCT is smaller than ICT on server5]
245 # 1. Save both timestamps (original/immediate) on all servers.
246 [connection server1]
247 [connection server2]
248 # 2. Verify that the timestamps are correct.
249 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
250 include/assert.inc [Assert that OCT is the same as ICT on server1]
251 include/assert.inc [Assert that ICT increases from server1 to server2]
252 # 1. Save both timestamps (original/immediate) on all servers.
253 [connection server1]
254 [connection server2]
255 [connection server4]
256 # 2. Verify that the timestamps are correct.
257 include/assert.inc [Assert that the OCT is the same on server1 and server2.]
258 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
259 include/assert.inc [Assert that OCT is the same as ICT on server1]
260 include/assert.inc [Assert that ICT > OCT on server2.]
261 include/assert.inc [Assert that ICT > OCT on server4.]
262 include/assert.inc [Assert that ICT on server_1 < ICT on server2.]
263 include/assert.inc [Assert that ICT on server_2 < ICT on server4.]
264 # 1. Save both timestamps (original/immediate) on all servers.
265 [connection server2]
266 [connection server3]
267 # 2. Verify that the timestamps are correct.
268 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
269 include/assert.inc [Assert that OCT is smaller than ICT on server2]
270 include/assert.inc [Assert that OCT is smaller than ICT on server3]
271 # 1. Save both timestamps (original/immediate) on all servers.
272 [connection server2]
273 [connection server5]
274 # 2. Verify that the timestamps are correct.
275 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
276 include/assert.inc [Assert that OCT is smaller than ICT on server2]
277 include/assert.inc [Assert that OCT is smaller than ICT on server5]
278 # 1. Save both timestamps (original/immediate) on all servers.
279 [connection server2]
280 [connection server4]
281 # 2. Verify that the timestamps are correct.
282 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
283 include/assert.inc [Assert that OCT is smaller than ICT on server2]
284 include/assert.inc [Assert that ICT increases from server2 to server4]
285 [connection server_2]
286 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_2.]
287 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_2.]
288 [connection server_3]
289 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
290 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_3.]
291 [connection server_5]
292 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
293 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_3.]
294 # 1. Save both timestamps (original/immediate) on all servers.
295 [connection server2]
296 [connection server4]
297 # 2. Verify that the timestamps are correct.
298 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
299 include/assert.inc [Assert that OCT is smaller than ICT on server2]
300 include/assert.inc [Assert that ICT increases from server2 to server4]
301 [connection server_2]
302 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_2.]
303 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_2.]
304 [connection server_3]
305 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
306 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_3.]
307 [connection server_5]
308 include/assert.inc [Assert that the View_change_event ICT is bigger than zero for server_3.]
309 include/assert.inc [Assert that the View_change_event OCT is bigger than zero for server_3.]
310 # 1. Save both timestamps (original/immediate) on all servers.
311 [connection server2]
312 [connection server4]
313 # 2. Verify that the timestamps are correct.
314 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
315 include/assert.inc [Assert that OCT is smaller than ICT on server2]
316 include/assert.inc [Assert that ICT increases from server2 to server4]
317 # 1. Save both timestamps (original/immediate) on all servers.
318 [connection server2]
319 [connection server3]
320 # 2. Verify that the timestamps are correct.
321 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
322 include/assert.inc [Assert that OCT is smaller than ICT on server2]
323 include/assert.inc [Assert that OCT is smaller than ICT on server3]
324 # 1. Save both timestamps (original/immediate) on all servers.
325 [connection server2]
326 [connection server5]
327 # 2. Verify that the timestamps are correct.
328 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
329 include/assert.inc [Assert that OCT is smaller than ICT on server2]
330 include/assert.inc [Assert that OCT is smaller than ICT on server5]
331 # 1. Save both timestamps (original/immediate) on all servers.
332 [connection server2]
333 [connection server4]
334 # 2. Verify that the timestamps are correct.
335 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
336 include/assert.inc [Assert that OCT is smaller than ICT on server2]
337 include/assert.inc [Assert that ICT increases from server2 to server4]
338 # 1. Save both timestamps (original/immediate) on all servers.
339 [connection server2]
340 [connection server3]
341 # 2. Verify that the timestamps are correct.
342 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
343 include/assert.inc [Assert that OCT is smaller than ICT on server2]
344 include/assert.inc [Assert that OCT is smaller than ICT on server3]
345 # 1. Save both timestamps (original/immediate) on all servers.
346 [connection server2]
347 [connection server5]
348 # 2. Verify that the timestamps are correct.
349 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
350 include/assert.inc [Assert that OCT is smaller than ICT on server2]
351 include/assert.inc [Assert that OCT is smaller than ICT on server5]
352 # 1. Save both timestamps (original/immediate) on all servers.
353 [connection server2]
354 [connection server4]
355 # 2. Verify that the timestamps are correct.
356 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
357 include/assert.inc [Assert that OCT is smaller than ICT on server2]
358 include/assert.inc [Assert that ICT increases from server2 to server4]
359 # 1. Save both timestamps (original/immediate) on all servers.
360 [connection server2]
361 [connection server3]
362 # 2. Verify that the timestamps are correct.
363 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
364 include/assert.inc [Assert that OCT is smaller than ICT on server2]
365 include/assert.inc [Assert that OCT is smaller than ICT on server3]
366 # 1. Save both timestamps (original/immediate) on all servers.
367 [connection server2]
368 [connection server5]
369 # 2. Verify that the timestamps are correct.
370 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
371 include/assert.inc [Assert that OCT is smaller than ICT on server2]
372 include/assert.inc [Assert that OCT is smaller than ICT on server5]
373 # 1. Save both timestamps (original/immediate) on all servers.
374 [connection server2]
375 [connection server4]
376 # 2. Verify that the timestamps are correct.
377 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
378 include/assert.inc [Assert that OCT is smaller than ICT on server2]
379 include/assert.inc [Assert that ICT increases from server2 to server4]
380 # 1. Save both timestamps (original/immediate) on all servers.
381 [connection server2]
382 [connection server3]
383 # 2. Verify that the timestamps are correct.
384 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
385 include/assert.inc [Assert that OCT is smaller than ICT on server2]
386 include/assert.inc [Assert that OCT is smaller than ICT on server3]
387 # 1. Save both timestamps (original/immediate) on all servers.
388 [connection server2]
389 [connection server5]
390 # 2. Verify that the timestamps are correct.
391 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
392 include/assert.inc [Assert that OCT is smaller than ICT on server2]
393 include/assert.inc [Assert that OCT is smaller than ICT on server5]
394 # 1. Save both timestamps (original/immediate) on all servers.
395 [connection server2]
396 [connection server4]
397 # 2. Verify that the timestamps are correct.
398 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
399 include/assert.inc [Assert that OCT is smaller than ICT on server2]
400 include/assert.inc [Assert that ICT increases from server2 to server4]
401 # 1. Save both timestamps (original/immediate) on all servers.
402 [connection server2]
403 [connection server3]
404 # 2. Verify that the timestamps are correct.
405 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
406 include/assert.inc [Assert that OCT is smaller than ICT on server2]
407 include/assert.inc [Assert that OCT is smaller than ICT on server3]
408 # 1. Save both timestamps (original/immediate) on all servers.
409 [connection server2]
410 [connection server5]
411 # 2. Verify that the timestamps are correct.
412 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
413 include/assert.inc [Assert that OCT is smaller than ICT on server2]
414 include/assert.inc [Assert that OCT is smaller than ICT on server5]
415 # 1. Save both timestamps (original/immediate) on all servers.
416 [connection server2]
417 [connection server4]
418 # 2. Verify that the timestamps are correct.
419 include/assert.inc [Assert that the OCT is the same on server2 and server4.]
420 include/assert.inc [Assert that OCT is smaller than ICT on server2]
421 include/assert.inc [Assert that ICT increases from server2 to server4]
422 # 1. Save both timestamps (original/immediate) on all servers.
423 [connection server2]
424 [connection server3]
425 # 2. Verify that the timestamps are correct.
426 include/assert.inc [Assert that the OCT is the same on server2 and server3.]
427 include/assert.inc [Assert that OCT is smaller than ICT on server2]
428 include/assert.inc [Assert that OCT is smaller than ICT on server3]
429 # 1. Save both timestamps (original/immediate) on all servers.
430 [connection server2]
431 [connection server5]
432 # 2. Verify that the timestamps are correct.
433 include/assert.inc [Assert that the OCT is the same on server2 and server5.]
434 include/assert.inc [Assert that OCT is smaller than ICT on server2]
435 include/assert.inc [Assert that OCT is smaller than ICT on server5]
436 [connection server2]
437 include/stop_slave.inc [FOR CHANNEL 'channel_1']
438 include/rpl_reset_slave.inc
439 [connection server4]
440 include/stop_slave.inc
441 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
442 include/group_replication_end.inc
443 RESET REPLICA ALL FOR CHANNEL 'channel_1';