Debian Codegraph @

mysql-test/suite/rpl/r/rpl_heartbeat.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 reset master;
5 connection slave;
6 include/stop_slave.inc
7 set @restore_slave_net_timeout= @@global.slave_net_timeout;
8 set @@global.slave_net_timeout= 10;
9 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
10 show status like 'Slave_heartbeat_period';;
11 Variable_name Slave_heartbeat_period
12 Value 5.000
13 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4294968;
14 ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds)
15 show status like 'Slave_heartbeat_period';;
16 Variable_name Slave_heartbeat_period
17 Value 5.000
18 connection slave;
19 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 0.0009999;
20 Warnings:
21 Warning 1703 The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled
22 show status like 'Slave_heartbeat_period';;
23 Variable_name Slave_heartbeat_period
24 Value 0.000
25 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4294967;
26 Warnings:
27 Warning 1704 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout
28 show status like 'Slave_heartbeat_period';;
29 Variable_name Slave_heartbeat_period
30 Value 4294967.000
31 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 0.001;
32 show status like 'Slave_heartbeat_period';;
33 Variable_name Slave_heartbeat_period
34 Value 0.001
35 reset slave;
36 set @@global.slave_net_timeout= 5;
37 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 5.001;
38 Warnings:
39 Warning 1704 The requested value for the heartbeat period exceeds the value of `slave_net_timeout' seconds. A sensible value for the period should be less than the timeout
40 show status like 'Slave_heartbeat_period';;
41 Variable_name Slave_heartbeat_period
42 Value 5.001
43 reset slave;
44 set @@global.slave_net_timeout= 5;
45 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4;
46 show status like 'Slave_heartbeat_period';;
47 Variable_name Slave_heartbeat_period
48 Value 4.000
49 set @@global.slave_net_timeout= 3 /* must be a warning */;
50 reset slave;
51 connection master;
52 drop table if exists t1;
53 connection slave;
54 set @@global.slave_net_timeout= 10;
55 change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_ssl_verify_server_cert=0, master_heartbeat_period= 0.5;
56 show status like 'Slave_heartbeat_period';;
57 Variable_name Slave_heartbeat_period
58 Value 0.500
59 start slave;
60 connection master;
61 create table t1 (f1 int);
62 connection slave;
63 include/check_slave_param.inc [Relay_Log_File]
64 show status like 'Slave_heartbeat_period';;
65 Variable_name Slave_heartbeat_period
66 Value 0.500
67 A heartbeat has been received by the slave
68 connection master;
69 drop table t1;
70 connection slave;
71 set @@global.slave_net_timeout= @restore_slave_net_timeout;
72 include/rpl_end.inc
73 End of tests