Debian Codegraph @

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

raw
1 ################################################################################
2 # Test to check if the flush command works fine for Group Replication.
3 #
4 # Test:
5 # 0. The test requires two servers: M1 and M2.
6 # 1. Setup a GROUP with two members ONLINE.
7 # 2. Test 'flush error logs' statement on M1. It should support.
8 # 3. Test 'flush relay logs' statement on M1. It should support.
9 # 4. Test 'flush slow logs' statement on M1. It should support.
10 # 5. Test 'flush general logs' statement on M1. It should support.
11 # 6. Test 'flush engine logs' statement on M1. It should support.
12 # For each 'flush..' command above:-
13 # - Check error log file exists on M1.
14 # - Make sure binary logs was not flushed on M1.
15 # - Make sure applier logs was not flushed on M1.
16 # - Make sure recovery logs was not flushed on M2.
17 # - Make sure applier logs was not flushed on M2.
18 # - Make sure binary logs was not flushed on M2.
19 # - Test that replication is working fine between the members.
20 # 7. Test 'flush binary logs' statement on M1. It should support.
21 # - Make sure binary logs is flushed on M1.
22 # - Make sure that the 'show binary logs' statement shows the correct data.
23 # - Make sure applier logs was not flushed on M1.
24 # - Make sure recovery logs was not flushed on M2.
25 # - Make sure applier logs was not flushed on M2.
26 # - Make sure binary logs was not flushed on M2.
27 # - Test that replication is working fine between the members.
28 # 8. Test if support to combine all kinds of logs into one statement on M1. It
29 # should support 'flush error logs, relay logs'.
30 # - Make sure binary logs was not flushed on M1.
31 # - Make sure applier logs was not flushed on M1.
32 # - Make sure recovery logs was not flushed on M2.
33 # - Make sure applier logs was not flushed on M2.
34 # - Make sure binary logs was not flushed on M2.
35 # - Test that replication is working fine between the members.
36 # 9. Test if 'flush logs' statement works fine and flush all the logs on M1.
37 # - Make sure binary logs is flushed on M1.
38 # - Make sure applier logs was not flushed on M1.
39 # - Make sure recovery logs was not flushed on M2.
40 # - Make sure applier logs was not flushed on M2.
41 # - Make sure binary logs was not flushed on M2.
42 # - Execute 'flush logs' on M2:
43 # - Make sure binary logs is flushed on M2.
44 # - Make sure applier logs was not flushed on M2.
45 # - Make sure applier logs was not flushed on M1.
46 # - Make sure binary logs was not flushed on M1.
47 # - Test that replication is working fine between the members.
48 ################################################################################
49 --source include/have_group_replication_plugin.inc
50 --source include/group_replication.inc
51
52 ################################################################################
53 # Save current binlog, applier log and recovery log index number to be used with
54 # `assert_logs_rotated.inc`
55 ################################################################################
56 --write_file $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc PROCEDURE
57 if ($server_number == '')
58 {
59 --die !!!ERROR IN TEST: you must set $server_number
60 }
61
62 --let $old_include_silent = $include_silent
63 --let $include_silent = 1
64
65 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*binary-log*
66 --source include/rpl_log_file_max_number.inc
67 --let MAX_BINLOG_FILE_BEFORE_FLUSH = $log_file_max_number
68
69 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*group_replication_applier*
70 --source include/rpl_log_file_max_number.inc
71 --let MAX_APPLIER_LOG_FILE_BEFORE_FLUSH = $log_file_max_number
72
73 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*group_replication_recovery*
74 --source include/rpl_log_file_max_number.inc
75 --let MAX_RECOVERY_LOG_FILE_BEFORE_FLUSH = $log_file_max_number
76
77 --let RESULT_FILE = $MYSQLTEST_VARDIR/tmp/save_current_log_info_$server_number.inc
78
79 --perl SCRIPT
80 my $max_binlog_file = $ENV{'MAX_BINLOG_FILE_BEFORE_FLUSH'};
81 my $max_applier_log_file = $ENV{'MAX_APPLIER_LOG_FILE_BEFORE_FLUSH'};
82 my $max_recovery_log_file = $ENV{'MAX_RECOVERY_LOG_FILE_BEFORE_FLUSH'};
83 my $out = $ENV{'RESULT_FILE'};
84
85 unlink $out;
86 open OUT, "> $out" or die("Unable to open $out: $!\n");
87 print OUT "--let \$max_binlog_file_before_flush = " . $max_binlog_file . "\n";
88 print OUT "--let \$max_applier_log_file_before_flush = " . $max_applier_log_file . "\n";
89 print OUT "--let \$max_recovery_log_file_before_flush = " . $max_recovery_log_file . "\n";
90 close OUT;
91 #END OF
92 SCRIPT
93 --let $include_silent = $old_include_silent
94 #END OF
95 PROCEDURE
96
97 ################################################################################
98 # Load information stored with `save_current_log_info` and match it to current
99 # index number in binary log, applier log and recovery log.
100 ################################################################################
101 --write_file $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc PROCEDURE
102 if ($server_number == '')
103 {
104 --die !!!ERROR IN TEST: you must set $server_number
105 }
106 if ($must_rotate_binlog == '')
107 {
108 --die !!!ERROR IN TEST: you must set $must_rotate_binlog
109 }
110 if ($must_rotate_applier_log == '')
111 {
112 --die !!!ERROR IN TEST: you must set $must_rotate_applier_log
113 }
114 if ($must_rotate_recovery_log == '')
115 {
116 --die !!!ERROR IN TEST: you must set $must_rotate_recovery_log
117 }
118
119 --let $old_include_silent = $include_silent
120 --let $include_silent = 1
121
122 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info_$server_number.inc
123
124 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*binary-log*
125 --let $include_silent = 1
126 --source include/rpl_log_file_max_number.inc
127 --let $max_binlog_file_after_flush = $log_file_max_number
128 --let $assert_text = Binary log WAS flushed and rotated
129 --let $operator = <
130 if ($must_rotate_binlog == 'no')
131 {
132 --let $assert_text = Binary log WAS NOT flushed nor rotated
133 --let $operator = =
134 }
135 --let $assert_cond = $max_binlog_file_before_flush $operator $max_binlog_file_after_flush
136 --let $include_silent = 0
137 --source include/assert.inc
138
139 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*group_replication_applier*
140 --let $include_silent = 1
141 --source include/rpl_log_file_max_number.inc
142 --let $max_applier_log_file_after_flush = $log_file_max_number
143 --let $assert_text = Applier relay log WAS flushed and rotated
144 --let $operator = <
145 if ($must_rotate_applier_log == 'no')
146 {
147 --let $assert_text = Applier relay log WAS NOT flushed nor rotated
148 --let $operator = =
149 }
150 --let $assert_cond = $max_applier_log_file_before_flush $operator $max_applier_log_file_after_flush
151 --let $include_silent = 0
152 --source include/assert.inc
153
154 --let $pattern_to_match = $MYSQLTEST_VARDIR/mysqld.$server_number/data/*group_replication_recovery*
155 --let $include_silent = 1
156 --source include/rpl_log_file_max_number.inc
157 --let $max_recovery_log_file_after_flush = $log_file_max_number
158 --let $assert_text = Recovery relay log WAS flushed and rotated
159 --let $operator = <
160 if ($must_rotate_recovery_log == 'no')
161 {
162 --let $assert_text = Recovery relay log WAS NOT flushed nor rotated
163 --let $operator = =
164 }
165 --let $assert_cond = $max_recovery_log_file_before_flush $operator $max_recovery_log_file_after_flush
166 --let $include_silent = 0
167 --source include/assert.inc
168
169 --remove_file $MYSQLTEST_VARDIR/tmp/save_current_log_info_$server_number.inc
170 --error 1
171 --file_exists $MYSQLTEST_VARDIR/tmp/save_current_log_info_$server_number.inc
172 --let $include_silent = $old_include_silent
173 #END OF
174 PROCEDURE
175
176 --let $rpl_connection_name = server1
177 --source include/rpl_connection.inc
178
179 CREATE TABLE t1 (i INT PRIMARY KEY) engine= innodb;
180 --source include/rpl_sync.inc
181
182 --let $rpl_connection_name = server1
183 --source include/rpl_connection.inc
184
185 --echo # Test if support 'flush error logs' statement.
186 --let $server_number = 1
187 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
188 --let $server_number = 2
189 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
190
191 flush error logs;
192
193 --file_exists $MYSQLTEST_VARDIR/tmp/master_log.err
194
195 --echo # Make sure binary logs was not flushed after execute 'flush error logs' statement.
196 --echo # Make sure applier logs was not flushed after execute 'flush error logs' statement.
197 --echo # Make sure recovery logs was not flushed after execute 'flush error logs' statement.
198 --let $server_number = 1
199 --let $must_rotate_binlog = no
200 --let $must_rotate_applier_log = no
201 --let $must_rotate_recovery_log = no
202 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
203
204 --source include/rpl_sync.inc
205 --let $rpl_connection_name = server2
206 --source include/rpl_connection.inc
207
208 --echo # Make sure recovery logs was not flushed after execute 'flush error logs' statement.
209 --echo # Make sure applier logs was not flushed after execute 'flush error logs' statement.
210 --echo # Make sure binary logs was not flushed after execute 'flush error logs' statement.
211 --let $server_number = 2
212 --let $must_rotate_binlog = no
213 --let $must_rotate_applier_log = no
214 --let $must_rotate_recovery_log = no
215 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
216
217 # Testing if the replication is working fine between the members.
218
219 --source include/rpl_sync.inc
220 --let $rpl_connection_name = server1
221 --source include/rpl_connection.inc
222
223 INSERT INTO t1 VALUES(1);
224 --source include/rpl_sync.inc
225
226 INSERT INTO t1 VALUES(2);
227 --source include/rpl_sync.inc
228
229 --let $rpl_connection_name = server1
230 --source include/rpl_connection.inc
231 --let $wait_condition= select count(*) = 2 from t1
232 --source include/wait_condition.inc
233
234 --let $diff_tables=server1:t1, server2:t1
235 --source include/diff_tables.inc
236
237
238 --let $rpl_connection_name = server1
239 --source include/rpl_connection.inc
240 --echo # Test if support 'flush local relay logs' statement.
241 --let $server_number = 1
242 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
243 --let $server_number = 2
244 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
245
246 flush local relay logs;
247
248 --echo # Make sure binary logs was not flushed after execute 'flush local relay logs' statement.
249 --echo # Make sure applier logs was flushed after execute 'flush local relay logs' statement.
250 --echo # Make sure recovery logs was flushed after execute 'flush local relay logs' statement.
251 --let $server_number = 1
252 --let $must_rotate_binlog = no
253 --let $must_rotate_applier_log = yes
254 --let $must_rotate_recovery_log = yes
255 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
256
257 --source include/rpl_sync.inc
258 --let $rpl_connection_name = server2
259 --source include/rpl_connection.inc
260
261 --echo # Make sure recovery logs was not flushed after execute 'flush local relay logs' statement.
262 --echo # Make sure applier logs was flushed after execute 'flush local relay logs' statement.
263 --echo # Make sure binary logs was not flushed after execute 'flush local relay logs' statement.
264 --let $server_number = 2
265 --let $must_rotate_binlog = no
266 --let $must_rotate_applier_log = no
267 --let $must_rotate_recovery_log = no
268 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
269
270 # Testing if the replication is working fine between the members.
271
272 --let $rpl_connection_name = server1
273 --source include/rpl_connection.inc
274 INSERT INTO t1 VALUES(3);
275 --source include/rpl_sync.inc
276
277 INSERT INTO t1 VALUES(4);
278 --source include/rpl_sync.inc
279
280 --let $rpl_connection_name = server1
281 --source include/rpl_connection.inc
282 --let $wait_condition= select count(*) = 4 from t1
283 --source include/wait_condition.inc
284
285 --let $diff_tables=server1:t1, server2:t1
286 --source include/diff_tables.inc
287
288 # Test 'flush slow logs' statement.
289 --echo # Test if support 'flush slow logs' statement.
290 --let $server_number = 1
291 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
292 --let $server_number = 2
293 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
294
295 flush slow logs;
296
297 --echo # Make sure binary logs was not flushed after execute 'flush slow logs' statement.
298 --echo # Make sure applier logs was not flushed after execute 'flush slow logs' statement.
299 --echo # Make sure recovery logs was not flushed after execute 'flush slow logs' statement.
300 --let $server_number = 1
301 --let $must_rotate_binlog = no
302 --let $must_rotate_applier_log = no
303 --let $must_rotate_recovery_log = no
304 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
305
306 --source include/rpl_sync.inc
307 --let $rpl_connection_name = server2
308 --source include/rpl_connection.inc
309
310 --echo # Make sure recovery logs was not flushed after execute 'flush slow logs' statement.
311 --echo # Make sure applier logs was not flushed after execute 'flush slow logs' statement.
312 --echo # Make sure binary logs was not flushed after execute 'flush slow logs' statement.
313 --let $server_number = 2
314 --let $must_rotate_binlog = no
315 --let $must_rotate_applier_log = no
316 --let $must_rotate_recovery_log = no
317 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
318
319
320 # Testing if the replication is working fine between the members.
321
322 --source include/rpl_sync.inc
323 --let $rpl_connection_name = server1
324 --source include/rpl_connection.inc
325 INSERT INTO t1 VALUES(5);
326 --source include/rpl_sync.inc
327
328 INSERT INTO t1 VALUES(6);
329 --source include/rpl_sync.inc
330
331 --let $rpl_connection_name = server1
332 --source include/rpl_connection.inc
333 --let $wait_condition= select count(*) = 6 from t1
334 --source include/wait_condition.inc
335
336 --let $diff_tables=server1:t1, server2:t1
337 --source include/diff_tables.inc
338
339 --let $rpl_connection_name = server1
340 --source include/rpl_connection.inc
341 # Test 'flush general logs' statement.
342 --echo # Test if support 'flush general logs' statement.
343 --let $server_number = 1
344 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
345 --let $server_number = 2
346 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
347
348 flush general logs;
349
350 --echo # Make sure binary logs was not flushed after execute 'flush general logs' statement.
351 --echo # Make sure applier logs was not flushed after execute 'flush general logs' statement.
352 --echo # Make sure recovery logs was not flushed after execute 'flush general logs' statement.
353 --let $server_number = 1
354 --let $must_rotate_binlog = no
355 --let $must_rotate_applier_log = no
356 --let $must_rotate_recovery_log = no
357 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
358
359 --source include/rpl_sync.inc
360 --let $rpl_connection_name = server2
361 --source include/rpl_connection.inc
362
363 --echo # Make sure recovery logs was not flushed after execute 'flush general logs' statement.
364 --echo # Make sure applier logs was not flushed after execute 'flush general logs' statement.
365 --echo # Make sure binary logs was not flushed after execute 'flush general logs' statement.
366 --let $server_number = 2
367 --let $must_rotate_binlog = no
368 --let $must_rotate_applier_log = no
369 --let $must_rotate_recovery_log = no
370 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
371
372 # Testing if the replication is working fine between the members.
373
374 --let $rpl_connection_name = server1
375 --source include/rpl_connection.inc
376 INSERT INTO t1 VALUES(7);
377 --source include/rpl_sync.inc
378
379 INSERT INTO t1 VALUES(8);
380 --source include/rpl_sync.inc
381
382 --let $rpl_connection_name = server1
383 --source include/rpl_connection.inc
384 --let $wait_condition= select count(*) = 8 from t1
385 --source include/wait_condition.inc
386
387 --let $diff_tables=server1:t1, server2:t1
388 --source include/diff_tables.inc
389
390 # Test 'flush engine logs' statement.
391 --echo # Test if support 'flush engine logs' statement.
392 --let $server_number = 1
393 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
394 --let $server_number = 2
395 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
396
397 flush engine logs;
398
399 --echo # Make sure binary logs was not flushed after execute 'flush engine logs' statement.
400 --echo # Make sure applier logs was not flushed after execute 'flush engine logs' statement.
401 --echo # Make sure recovery logs was not flushed after execute 'flush engine logs' statement.
402 --let $server_number = 1
403 --let $must_rotate_binlog = no
404 --let $must_rotate_applier_log = no
405 --let $must_rotate_recovery_log = no
406 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
407
408 --source include/rpl_sync.inc
409 --let $rpl_connection_name = server2
410 --source include/rpl_connection.inc
411
412 --echo # Make sure recovery logs was not flushed after execute 'flush engine logs' statement.
413 --echo # Make sure applier logs was not flushed after execute 'flush engine logs' statement.
414 --echo # Make sure binary logs was not flushed after execute 'flush engine logs' statement.
415 --let $server_number = 2
416 --let $must_rotate_binlog = no
417 --let $must_rotate_applier_log = no
418 --let $must_rotate_recovery_log = no
419 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
420
421 # Testing if the replication is working fine between the members.
422
423 --let $rpl_connection_name = server1
424 --source include/rpl_connection.inc
425 INSERT INTO t1 VALUES(9);
426 --source include/rpl_sync.inc
427
428 INSERT INTO t1 VALUES(10);
429 --source include/rpl_sync.inc
430
431 --let $rpl_connection_name = server1
432 --source include/rpl_connection.inc
433 --let $wait_condition= select count(*) = 10 from t1
434 --source include/wait_condition.inc
435
436 --let $diff_tables=server1:t1, server2:t1
437 --source include/diff_tables.inc
438
439 --let $rpl_connection_name = server1
440 --source include/rpl_connection.inc
441 # Test 'flush binary logs' statement.
442 --echo # Test if support 'flush binary logs' statement.
443 --let $server_number = 1
444 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
445 --let $server_number = 2
446 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
447
448 flush binary logs;
449
450 --echo # Make sure binary logs is flushed after execute 'flush binary logs' statement.
451 --echo # Make sure applier logs was not flushed after execute 'flush binary logs' statement.
452 --echo # Make sure recovery logs was not flushed after execute 'flush binary logs' statement.
453 --let $server_number = 1
454 --let $must_rotate_binlog = yes
455 --let $must_rotate_applier_log = no
456 --let $must_rotate_recovery_log = no
457 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
458
459 --echo # Test if it supports 'show binary logs' statement and verify that it shows the correct data
460
461 --let $binlog1= query_get_value(show binary logs, Log_name, 1)
462 --let $assert_text= assert that the first binary log name is server-binary-log.000001
463 --let $assert_cond= "$binlog1" = "server-binary-log.000001"
464 --source include/assert.inc
465
466 --let $binlog2= query_get_value(show binary logs, Log_name, 2)
467 --let $assert_text= assert that the second binary log name is server-binary-log.000002
468 --let $assert_cond= "$binlog2" = "server-binary-log.000002"
469 --source include/assert.inc
470
471 --source include/rpl_sync.inc
472 --let $rpl_connection_name = server2
473 --source include/rpl_connection.inc
474
475 --echo # Make sure recovery logs was not flushed after execute 'flush binary logs' statement.
476 --echo # Make sure applier logs was not flushed after execute 'flush binary logs' statement.
477 --echo # Make sure binary logs was not flushed after execute 'flush binary logs' statement.
478 --let $server_number = 2
479 --let $must_rotate_binlog = no
480 --let $must_rotate_applier_log = no
481 --let $must_rotate_recovery_log = no
482 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
483
484 # Testing if the replication is working fine between the members.
485
486 --let $rpl_connection_name = server1
487 --source include/rpl_connection.inc
488 INSERT INTO t1 VALUES(11);
489 --source include/rpl_sync.inc
490
491 INSERT INTO t1 VALUES(12);
492 --source include/rpl_sync.inc
493
494 --let $rpl_connection_name = server1
495 --source include/rpl_connection.inc
496 --let $wait_condition= select count(*) = 12 from t1
497 --source include/wait_condition.inc
498
499 --let $diff_tables=server1:t1, server2:t1
500 --source include/diff_tables.inc
501
502 --let $rpl_connection_name = server1
503 --source include/rpl_connection.inc
504
505 --echo # Test if support to combine all kinds of logs into one statement.
506 --let $server_number = 1
507 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
508 --let $server_number = 2
509 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
510
511 flush local error logs, relay logs;
512
513 --file_exists $MYSQLTEST_VARDIR/tmp/master_log.err
514
515 --echo # Make sure binary logs was not flushed after execute 'flush local error logs, relay logs' statement.
516 --echo # Make sure applier logs was flushed after execute 'flush local error logs, relay logs' statement.
517 --echo # Make sure recovery logs was flushed after execute 'flush local error logs, relay logs' statement.
518 --let $server_number = 1
519 --let $must_rotate_binlog = no
520 --let $must_rotate_applier_log = yes
521 --let $must_rotate_recovery_log = yes
522 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
523
524 --source include/rpl_sync.inc
525 --let $rpl_connection_name = server2
526 --source include/rpl_connection.inc
527
528 --echo # Make sure recovery logs was not flushed after execute 'flush local error logs, relay logs' statement.
529 --echo # Make sure applier logs was flushed after execute 'flush local error logs, relay logs' statement.
530 --echo # Make sure binary logs was not flushed after execute 'flush local error logs, relay logs' statement.
531 --let $server_number = 2
532 --let $must_rotate_binlog = no
533 --let $must_rotate_applier_log = no
534 --let $must_rotate_recovery_log = no
535 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
536
537 # Testing if the replication is working fine between the members.
538
539 --source include/rpl_sync.inc
540 --let $rpl_connection_name = server1
541 --source include/rpl_connection.inc
542 INSERT INTO t1 VALUES(13);
543 --source include/rpl_sync.inc
544
545 INSERT INTO t1 VALUES(14);
546 --source include/rpl_sync.inc
547
548 --let $rpl_connection_name = server1
549 --source include/rpl_connection.inc
550 --let $wait_condition= select count(*) = 14 from t1
551 --source include/wait_condition.inc
552
553 --let $diff_tables=server1:t1, server2:t1
554 --source include/diff_tables.inc
555
556 --let $rpl_connection_name = server2
557 --source include/rpl_connection.inc
558 # Test 'flush logs' statement
559
560 --let $rpl_connection_name = server1
561 --source include/rpl_connection.inc
562
563 --echo # Test if 'flush logs' statement works fine and flush all the logs.
564 --let $server_number = 1
565 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
566 --let $server_number = 2
567 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
568
569 flush logs;
570
571 --file_exists $MYSQLTEST_VARDIR/tmp/master_log.err
572
573 --echo # Check 'server1-bin.000003' is created after execute 'flush logs' statement.
574 --echo # Make sure applier logs was flushed after execute 'flush logs' statement.
575 --echo # Make sure recovery logs was flushed after execute 'flush logs' statement.
576 --let $server_number = 1
577 --let $must_rotate_binlog = yes
578 --let $must_rotate_applier_log = yes
579 --let $must_rotate_recovery_log = yes
580 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
581
582 --source include/rpl_sync.inc
583 --let $rpl_connection_name = server2
584 --source include/rpl_connection.inc
585
586 --echo # Make sure recovery logs was not flushed after execute 'flush logs' statement.
587 --echo # Make sure applier logs was not flushed after execute 'flush logs' statement.
588 --echo # Make sure binary logs was not flushed after execute 'flush logs' statement.
589 --let $server_number = 2
590 --let $must_rotate_binlog = no
591 --let $must_rotate_applier_log = no
592 --let $must_rotate_recovery_log = no
593 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
594
595 --echo # Checking the "flush logs" behavior executed from the server2 side
596
597 --let $rpl_connection_name = server2
598 --source include/rpl_connection.inc
599 --let $server_number = 1
600 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
601 --let $server_number = 2
602 --source $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
603
604 flush logs;
605
606 --echo # Check 'server2-bin.000002' is created after execute 'flush logs' statement.
607 --echo # Make sure applier logs was flushed after execute 'flush logs' statement.
608 --echo # Make sure recovery logs was flushed after execute 'flush logs' statement.
609 --let $server_number = 2
610 --let $must_rotate_binlog = yes
611 --let $must_rotate_applier_log = yes
612 --let $must_rotate_recovery_log = yes
613 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
614
615 --source include/rpl_sync.inc
616 --let $rpl_connection_name = server1
617 --source include/rpl_connection.inc
618
619 --echo # Make sure recovery logs was not flushed after execute 'flush logs' statement.
620 --echo # Make sure applier logs was not flushed after execute 'flush logs' statement.
621 --echo # Make sure binary logs was not flushed after execute 'flush logs' statement.
622 --let $server_number = 1
623 --let $must_rotate_binlog = no
624 --let $must_rotate_applier_log = no
625 --let $must_rotate_recovery_log = no
626 --source $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
627
628 # Testing if the replication is working fine between the members.
629 --let $rpl_connection_name = server1
630 --source include/rpl_connection.inc
631
632 INSERT INTO t1 VALUES(15);
633
634 --source include/rpl_sync.inc
635 INSERT INTO t1 VALUES(16);
636
637 --source include/rpl_sync.inc
638
639 --let $wait_condition= select count(*) = 16 from t1
640 --source include/wait_condition.inc
641
642 --let $diff_tables=server1:t1, server2:t1
643 --source include/diff_tables.inc
644
645 --let $rpl_connection_name = server1
646 --source include/rpl_connection.inc
647 DROP TABLE t1;
648 --remove_file $MYSQLTEST_VARDIR/tmp/save_current_log_info.inc
649 --remove_file $MYSQLTEST_VARDIR/tmp/assert_logs_rotated.inc
650 --source include/group_replication_end.inc