Debian Codegraph @

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

raw
1 #
2 # Testing reconnecting by slave as specified by `replica_net_timeout'
3 #
4 # Bug #50296 Slave reconnects earlier than the prescribed replica_net_timeout value
5 #
6 --source include/master-slave.inc
7
8
9 # save global env
10 connection master;
11 set @save_general_log = @@global.general_log;
12 set @save_log_output = @@global.log_output;
13
14 connection slave;
15 set @save_replica_net_timeout = @@global.replica_net_timeout;
16
17 connection master;
18 set @@global.general_log = ON;
19 set @@global.log_output = 'table,file';
20
21 connection slave;
22 --source include/stop_slave.inc
23 #
24 # if heartbeat is disabled then reconnecting to the idle master
25 # should happen with `replica_net_timeout' period.
26 # Since it's the real time that is measured, `replica_net_timeout'
27 # merely guarantees that reconnecting can *not* happen earlier of a value specified.
28 # That is there can't an exact estimate for how many time it will happen.
29 #
30 # The following lines verify that having idle master
31 # for more than 2 * replica_net_timeout seconds and
32 # slave.net_read_timeout < replica_net_timeout
33 # won't cause reconnecting by the slave within at least
34 # replica_net_timeout interval.
35 #
36 --replace_result $MASTER_MYPORT MASTER_PORT
37 --replace_column 2 ####
38 eval CHANGE REPLICATION SOURCE to SOURCE_HOST = '127.0.0.1',SOURCE_PORT = $MASTER_MYPORT,
39 SOURCE_USER = 'root', SOURCE_HEARTBEAT_PERIOD = 0;
40
41 set @@global.replica_net_timeout = @@global.net_read_timeout * 2;
42 let $idle_time=`select @@global.replica_net_timeout * 2`;
43
44 let $replica_net_timeout = `select @@global.replica_net_timeout`;
45
46 --source include/start_slave.inc
47
48 --disable_query_log
49 --disable_result_log
50 eval select 'master is idle for ', sleep($idle_time);
51 --enable_result_log
52 --enable_query_log
53
54 # querying general-log
55
56 connection master;
57
58 # In particular the last reconnection timestamp must be greater or equal to
59 # the previous one + replica_net_timeout
60
61 --let $ts_last= `select time_to_sec(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`
62 --let $ts_prev= `select time_to_sec(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`
63
64 --let $timeout= $idle_time + 10
65 while ($timeout)
66 {
67 --let $ts_last= `select time_to_sec(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`
68 --let $ts_flag= `select $ts_last-$ts_prev>=$replica_net_timeout`
69 if($ts_flag)
70 {
71 --let $timeout=1
72 }
73 --dec $timeout
74 --sleep 1
75 }
76
77 --let $assert_cond= $ts_flag=1
78 --let $assert_text= time between last reconnection and the reconnection before that should be >= replica_net_timeout
79 --source include/assert.inc
80
81 # cleanup
82
83 # restore global env
84 connection master;
85 set @@global.general_log = @save_general_log;
86 set @@global.log_output = @save_log_output;
87 TRUNCATE TABLE mysql.general_log;
88 connection slave;
89 set @@global.replica_net_timeout = @save_replica_net_timeout;
90
91 --source include/rpl_end.inc