Debian Codegraph @

mysql-test/suite/rpl/include/rpl_shutdown_wait_slaves.inc

raw
1 --connection server_1
2
3 CREATE TABLE t1 (a INT) ENGINE=innodb;
4
5 --save_master_pos
6
7 --connection server_2
8 --sync_with_master
9
10 --connection server_3
11 --sync_with_master
12
13 --connection server_4
14 --source include/stop_slave.inc
15
16 --connection server_1
17 --disable_query_log
18 --let $count=1000
19 while ($count)
20 {
21 INSERT INTO t1 SET a=1;
22 --dec $count
23 }
24 --enable_query_log
25 --save_master_pos
26
27 # Shutdown master and restart server_4 who will be waiting for the master
28 # to start replication at its shutdown beginning phase.
29 # The being forked out server_4 dump thread must relate to a record
30 # in slave_list, and it won't start sending out binlog events
31 # until has received a signal from the shutdown thread.
32 # This also proves delivery to a started-in-middle-of-shutdown slave.
33 --connection server_1
34 SET @@GLOBAL.debug_dbug="+d,simulate_delay_at_shutdown";
35
36 --connection server_4
37 --source include/start_slave.inc
38
39 --connection server_1
40 --write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
41 wait
42 EOF
43 # --shutdown_server
44 --send SHUTDOWN WAIT FOR ALL SLAVES
45 --reap
46 --source include/wait_until_disconnected.inc
47 #
48 # MDEV-18450 liveness condition:
49 # Despite shutdown even "late" slave #4 is in sync
50 #
51 --connection server_4
52 --sync_with_master
53
54 --connection server_3
55 --sync_with_master
56
57 --connection server_2
58 --sync_with_master
59
60 --connection server_1
61 --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
62 restart
63 EOF
64
65 --connection default
66 --enable_reconnect
67 --source include/wait_until_connected_again.inc
68 --connection server_1
69 --enable_reconnect
70 --source include/wait_until_connected_again.inc
71
72 #
73 # Cleanup
74 #
75 --connection server_1
76 DROP TABLE t1;
77
78 # Slaves IO thread will receive the disconnect error when master was shutdown
79 # so we are allowing error on start.
80 --connection server_2
81 --disable_warnings
82 --let rpl_allow_error=1
83 --source include/start_slave.inc
84 --enable_warnings
85
86 --connection server_3
87 --disable_warnings
88 --let rpl_allow_error=1
89 --source include/start_slave.inc
90 --enable_warnings
91
92 --connection server_4
93 --disable_warnings
94 --let rpl_allow_error=1
95 --source include/start_slave.inc
96 --enable_warnings