Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 [connection slave]
4 set @restore_replica_net_timeout= @@global.replica_net_timeout;
5 set @@global.replica_net_timeout= 10;
6 SELECT LAST_HEARTBEAT_TIMESTAMP FROM performance_schema.replication_connection_status;
7 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root';
8 Warnings:
9 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
10 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
11 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
12 HEARTBEAT_INTERVAL 5.000
13 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4294968;
14 ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
15 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
16 HEARTBEAT_INTERVAL 5.000
17 [connection slave]
18 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.0009999;
19 Warnings:
20 Warning #### 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.
21 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
22 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
23 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
24 HEARTBEAT_INTERVAL 0.000
25 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4294967;
26 Warnings:
27 Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
28 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
29 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
30 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
31 HEARTBEAT_INTERVAL 4294967.000
32 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.001;
33 Warnings:
34 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
35 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
36 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
37 HEARTBEAT_INTERVAL 0.001
38 reset slave;
39 Warnings:
40 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
41 set @@global.replica_net_timeout= 5;
42 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 5.001;
43 Warnings:
44 Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
45 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
46 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
47 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
48 HEARTBEAT_INTERVAL 5.001
49 reset slave;
50 Warnings:
51 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
52 set @@global.replica_net_timeout= 5;
53 Warnings:
54 Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
55 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4;
56 Warnings:
57 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
58 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
59 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
60 HEARTBEAT_INTERVAL 4.000
61 set @@global.replica_net_timeout= 3 /* must be a warning */;
62 Warnings:
63 Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
64 reset slave;
65 Warnings:
66 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
67 [connection master]
68 drop table if exists t1;
69 [connection slave]
70 set @@global.replica_net_timeout= 10;
71 CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.5;
72 Warnings:
73 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
74 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
75 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
76 HEARTBEAT_INTERVAL 0.500
77 start slave;
78 Warnings:
79 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
80 [connection master]
81 create table t1 (f1 int);
82 include/sync_slave_sql_with_master.inc
83 include/check_slave_param.inc [Relay_Log_File]
84 SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
85 HEARTBEAT_INTERVAL 0.500
86 A heartbeat has been received by the slave
87 include/assert.inc [last_heartbeat_timestamp should not be empty]
88 [connection master]
89 drop table t1;
90 include/sync_slave_sql_with_master.inc
91 set @@global.replica_net_timeout= @restore_replica_net_timeout;
92 [connection slave]
93 include/stop_slave.inc
94 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD= 10;
95 include/assert.inc [HEARTBEAT_INTERVAL should be 10.000]
96
97 # Verify that heartbeat period is not reset to default implicitly and
98 # received_heartbeat is not set to 0 by this.
99
100 CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 3;
101 include/assert.inc [HEARTBEAT_INTERVAL should be 10.000]
102 include/assert.inc [COUNT_RECEIVED_HEARTBEATS should NOT be set to 0]
103 include/stop_slave.inc
104 Warnings:
105 Note 3084 Replication thread(s) for channel '' are already stopped.
106 RESET SLAVE;
107 Warnings:
108 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
109 RESET MASTER;
110 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION;
111 include/start_slave.inc
112 include/assert.inc [HEARTBEAT_INTERVAL should still be 10.000 after RESET SLAVE.]
113 include/stop_slave_io.inc
114 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'localhost', SOURCE_PORT= SOURCE_PORT;
115 include/start_slave.inc
116 include/assert.inc [HEARTBEAT_INTERVAL should reset to default.]
117 #
118 # Change from default to make sure changing HOST resets heartbeat_interval
119 # to default.
120 #
121 include/stop_slave_io.inc
122 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD = 10;
123 include/start_slave.inc
124 DROP TABLE IF EXISTS t1;
125 include/sync_slave_sql_with_master.inc
126 include/stop_slave.inc
127 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1';
128 include/start_slave.inc
129 include/assert.inc [heartbeat_interval should reset to default on changing host.]
130 DROP TABLE IF EXISTS t1;
131 include/sync_slave_sql_with_master.inc
132 #
133 # Change from default to make sure changing PORT resets heartbeat_interval
134 # to default.
135 #
136 include/stop_slave.inc
137 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD = 10;
138 include/start_slave.inc
139 DROP TABLE IF EXISTS t1;
140 include/sync_slave_sql_with_master.inc
141 include/stop_slave.inc
142 CHANGE REPLICATION SOURCE TO SOURCE_PORT= SOURCE_PORT;
143 include/start_slave.inc
144 include/assert.inc [heartbeat_interval should reset to default on changing port.]
145 DROP TABLE IF EXISTS t1;
146 include/sync_slave_sql_with_master.inc
147 #
148 # Change from default to make sure changing HOST and PORT resets
149 # heartbeat_period to default.
150 #
151 include/stop_slave.inc
152 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= SOURCE_PORT;
153 include/start_slave.inc
154 include/assert.inc [heartbeat_interval should reset to default on changing host and port.]
155 DROP TABLE IF EXISTS t1;
156 include/sync_slave_sql_with_master.inc
157 include/stop_slave.inc
158 RESET SLAVE ALL;
159 Warnings:
160 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
161 include/assert.inc [heartbeat_interval should reset to zero by RESET SLAVE ALL.]
162 CHANGE REPLICATION SOURCE to SOURCE_HOST= '127.0.0.1', SOURCE_PORT= SOURCE_PORT, SOURCE_USER= 'root';
163 Warnings:
164 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
165 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
166 include/start_slave.inc
167 DROP TABLE IF EXISTS t1;
168 include/sync_slave_sql_with_master.inc
169 include/rpl_end.inc