Debian Codegraph @

mysql-test/suite/large_tests/t/rpl_slave_net_timeout.test

raw
1 #
2 # Testing reconnecting by slave as specified by `slave_net_timeout'
3 #
4 # Bug #50296 Slave reconnects earlier than the prescribed slave_net_timeout value
5 #
6 --source include/have_csv.inc
7 --source include/master-slave.inc
8
9
10 # save global env
11 connection master;
12 set @save_general_log = @@global.general_log;
13 set @save_log_output = @@global.log_output;
14
15 connection slave;
16 set @save_slave_net_timeout = @@global.slave_net_timeout;
17
18 connection master;
19 set @@global.general_log = ON;
20 set @@global.log_output = 'table,file';
21
22 connection slave;
23 --source include/stop_slave.inc
24 #
25 # if heartbeat is disabled then reconnecting to the idle master
26 # should happen with `slave_net_timeout' period.
27 # Since it's the real time that is measured, `slave_net_timeout'
28 # merely guarantees that reconnecting can *not* happen earlier of a value specified.
29 # That is there can't an exact estimate for how many time it will happen.
30 #
31 # The following lines verify that having idle master
32 # for more than 2 * slave_net_timeout seconds and
33 # slave.net_read_timeout < slave_net_timeout
34 # won't cause reconnecting by the slave within at least
35 # slave_net_timeout interval.
36 --replace_result $MASTER_MYPORT MASTER_PORT
37 eval change master to master_host = '127.0.0.1',master_port = $MASTER_MYPORT,
38 master_user = 'root', master_heartbeat_period = 0;
39
40 set @@global.slave_net_timeout = @@global.net_read_timeout * 2;
41 let $idle_time=`select @@global.slave_net_timeout * 2`;
42
43 let $slave_net_timeout = `select @@global.slave_net_timeout`;
44
45 --source include/start_slave.inc
46
47 --disable_query_log
48 --disable_result_log
49 eval select 'master is idle for ', sleep($idle_time);
50 --enable_result_log
51 --enable_query_log
52
53 --source include/stop_slave.inc
54
55 # querying general-log
56
57 connection master;
58
59 # In particular the last reconnection timestamp must be greater or equal to
60 # the previous one + slave_net_timeout
61
62 select event_time from (select event_time from mysql.general_log as t_1 where command_type like 'Connect' order by event_time desc limit 2) as t_2 order by event_time desc limit 1 into @ts_last;
63 select event_time from (select event_time from mysql.general_log as t_1 where command_type like 'Connect' order by event_time desc limit 2) as t_2 order by event_time asc limit 1 into @ts_prev;
64
65 --let $assert_cond= time_to_sec(@ts_last) - time_to_sec(@ts_prev) >= $slave_net_timeout
66 --let $assert_text= time between last reconnection and the reconnection before that should be >= slave_net_timeout
67 --source include/assert.inc
68
69 # cleanup
70
71 # restore global env
72 connection master;
73 set @@global.general_log = @save_general_log;
74 set @@global.log_output = @save_log_output;
75 connection slave;
76 set @@global.slave_net_timeout = @save_slave_net_timeout;
77
78 --let $rpl_only_running_threads= 1
79 --source include/rpl_end.inc