| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
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. |
| 5 |
[connection master] |
| 6 |
call mtr.add_suppression("Replica I/O: The replica I/O thread stops because a fatal error is encountered when it tried to SET @master_binlog_checksum"); |
| 7 |
call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state"); |
| 8 |
|
| 9 |
*** Preparing *** |
| 10 |
include/sync_slave_sql_with_master.inc |
| 11 |
include/stop_slave.inc |
| 12 |
RESET SLAVE; |
| 13 |
Warnings: |
| 14 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 15 |
RESET MASTER; |
| 16 |
SET @restore_replica_net_timeout=@@global.replica_net_timeout; |
| 17 |
RESET MASTER; |
| 18 |
SET @restore_replica_net_timeout=@@global.replica_net_timeout; |
| 19 |
SET @restore_event_scheduler=@@global.event_scheduler; |
| 20 |
|
| 21 |
*** Default value *** |
| 22 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root'; |
| 23 |
Warnings: |
| 24 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 25 |
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. |
| 26 |
replica_net_timeout/slave_heartbeat_timeout=2.0000 |
| 27 |
RESET SLAVE; |
| 28 |
Warnings: |
| 29 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 30 |
RESET MASTER; |
| 31 |
|
| 32 |
*** Reset slave affect *** |
| 33 |
SET @@global.replica_net_timeout=30; |
| 34 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=5; |
| 35 |
Warnings: |
| 36 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 37 |
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. |
| 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 |
RESET MASTER; |
| 42 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 43 |
heartbeat_interval |
| 44 |
5.000 |
| 45 |
|
| 46 |
*** Default value if replica_net_timeout changed *** |
| 47 |
SET @@global.replica_net_timeout=50; |
| 48 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20; |
| 49 |
Warnings: |
| 50 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 51 |
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. |
| 52 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 53 |
heartbeat_interval |
| 54 |
25.000 |
| 55 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 56 |
RESET SLAVE; |
| 57 |
Warnings: |
| 58 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 59 |
RESET MASTER; |
| 60 |
|
| 61 |
*** Warning if updated replica_net_timeout < slave_heartbeat_timeout *** |
| 62 |
SET @@global.replica_net_timeout=FLOOR(SLAVE_HEARTBEAT_TIMEOUT)-1; |
| 63 |
Warnings: |
| 64 |
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. |
| 65 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 66 |
RESET SLAVE; |
| 67 |
Warnings: |
| 68 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 69 |
RESET MASTER; |
| 70 |
|
| 71 |
*** Warning if updated slave_heartbeat_timeout > replica_net_timeout *** |
| 72 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=REPLICA_NET_TIMEOUT; |
| 73 |
Warnings: |
| 74 |
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. |
| 75 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 76 |
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. |
| 77 |
RESET SLAVE; |
| 78 |
Warnings: |
| 79 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 80 |
RESET MASTER; |
| 81 |
|
| 82 |
*** CHANGE MASTER statement only updates slave_heartbeat_period *** |
| 83 |
SET @@global.replica_net_timeout=20; |
| 84 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=5; |
| 85 |
Warnings: |
| 86 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 87 |
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. |
| 88 |
SHOW VARIABLES LIKE 'replica_net_timeout'; |
| 89 |
Variable_name Value |
| 90 |
replica_net_timeout 20 |
| 91 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 92 |
heartbeat_interval |
| 93 |
5.000 |
| 94 |
SET @@global.replica_net_timeout=2*@@global.replica_net_timeout; |
| 95 |
SHOW VARIABLES LIKE 'replica_net_timeout'; |
| 96 |
Variable_name Value |
| 97 |
replica_net_timeout 40 |
| 98 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 99 |
heartbeat_interval |
| 100 |
5.000 |
| 101 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 102 |
RESET SLAVE; |
| 103 |
Warnings: |
| 104 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 105 |
RESET MASTER; |
| 106 |
|
| 107 |
*** Update replica_net_timeout on master *** |
| 108 |
SET @@global.replica_net_timeout=500; |
| 109 |
SET @@global.replica_net_timeout=200; |
| 110 |
RESET SLAVE; |
| 111 |
Warnings: |
| 112 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 113 |
RESET MASTER; |
| 114 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20; |
| 115 |
Warnings: |
| 116 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 117 |
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. |
| 118 |
include/start_slave.inc |
| 119 |
include/sync_slave_sql_with_master.inc |
| 120 |
SHOW VARIABLES LIKE 'replica_net_timeout'; |
| 121 |
Variable_name Value |
| 122 |
replica_net_timeout 200 |
| 123 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 124 |
heartbeat_interval |
| 125 |
100.000 |
| 126 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 127 |
Warnings: |
| 128 |
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. |
| 129 |
include/stop_slave.inc |
| 130 |
RESET SLAVE; |
| 131 |
Warnings: |
| 132 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 133 |
RESET MASTER; |
| 134 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 135 |
|
| 136 |
*** Start/stop slave *** |
| 137 |
SET @@global.replica_net_timeout=100; |
| 138 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=20; |
| 139 |
Warnings: |
| 140 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 141 |
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. |
| 142 |
include/start_slave.inc |
| 143 |
include/sync_slave_sql_with_master.inc |
| 144 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 145 |
heartbeat_interval |
| 146 |
20.000 |
| 147 |
include/stop_slave.inc |
| 148 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 149 |
heartbeat_interval |
| 150 |
20.000 |
| 151 |
|
| 152 |
*** Reload slave *** |
| 153 |
SET @@global.replica_net_timeout=50; |
| 154 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=30; |
| 155 |
Warnings: |
| 156 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 157 |
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. |
| 158 |
include/rpl_restart_server.inc [server_number=2] |
| 159 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 160 |
heartbeat_interval |
| 161 |
30.000 |
| 162 |
SET @restore_replica_net_timeout=@@global.replica_net_timeout; |
| 163 |
|
| 164 |
*** Disable heartbeat *** |
| 165 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0; |
| 166 |
Warnings: |
| 167 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 168 |
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. |
| 169 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 170 |
heartbeat_interval |
| 171 |
0.000 |
| 172 |
select count_received_heartbeats from performance_schema.replication_connection_status; |
| 173 |
count_received_heartbeats |
| 174 |
0 |
| 175 |
include/start_slave.inc |
| 176 |
include/sync_slave_sql_with_master.inc |
| 177 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 178 |
heartbeat_interval |
| 179 |
0.000 |
| 180 |
select count_received_heartbeats from performance_schema.replication_connection_status; |
| 181 |
count_received_heartbeats |
| 182 |
0 |
| 183 |
include/stop_slave.inc |
| 184 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 185 |
heartbeat_interval |
| 186 |
0.000 |
| 187 |
select count_received_heartbeats from performance_schema.replication_connection_status; |
| 188 |
count_received_heartbeats |
| 189 |
0 |
| 190 |
RESET SLAVE; |
| 191 |
Warnings: |
| 192 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 193 |
RESET MASTER; |
| 194 |
SELECT SLAVE_HEARTBEAT_TIMEOUT = 0 AS Result; |
| 195 |
Result |
| 196 |
1 |
| 197 |
|
| 198 |
*** Min slave_heartbeat_timeout *** |
| 199 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.001; |
| 200 |
Warnings: |
| 201 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 202 |
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. |
| 203 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 204 |
heartbeat_interval |
| 205 |
0.001 |
| 206 |
RESET SLAVE; |
| 207 |
Warnings: |
| 208 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 209 |
RESET MASTER; |
| 210 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.0009; |
| 211 |
Warnings: |
| 212 |
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. |
| 213 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 214 |
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. |
| 215 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 216 |
heartbeat_interval |
| 217 |
0.000 |
| 218 |
RESET SLAVE; |
| 219 |
Warnings: |
| 220 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 221 |
RESET MASTER; |
| 222 |
|
| 223 |
*** Max slave_heartbeat_timeout *** |
| 224 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294967; |
| 225 |
Warnings: |
| 226 |
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. |
| 227 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 228 |
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. |
| 229 |
select heartbeat_interval from performance_schema.replication_connection_configuration; |
| 230 |
heartbeat_interval |
| 231 |
4294967.000 |
| 232 |
RESET SLAVE; |
| 233 |
Warnings: |
| 234 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 235 |
RESET MASTER; |
| 236 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294968; |
| 237 |
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds). |
| 238 |
RESET SLAVE; |
| 239 |
Warnings: |
| 240 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 241 |
RESET MASTER; |
| 242 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=8589935; |
| 243 |
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds). |
| 244 |
RESET SLAVE; |
| 245 |
Warnings: |
| 246 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 247 |
RESET MASTER; |
| 248 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294967296; |
| 249 |
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds). |
| 250 |
RESET SLAVE; |
| 251 |
Warnings: |
| 252 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 253 |
RESET MASTER; |
| 254 |
|
| 255 |
*** Misc incorrect values *** |
| 256 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD='-1'; |
| 257 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''-1'' at line 1 |
| 258 |
RESET SLAVE; |
| 259 |
Warnings: |
| 260 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 261 |
RESET MASTER; |
| 262 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD='123abc'; |
| 263 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''123abc'' at line 1 |
| 264 |
RESET SLAVE; |
| 265 |
Warnings: |
| 266 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 267 |
RESET MASTER; |
| 268 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=''; |
| 269 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1 |
| 270 |
RESET SLAVE; |
| 271 |
Warnings: |
| 272 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 273 |
RESET MASTER; |
| 274 |
|
| 275 |
*** Running slave *** |
| 276 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD= 3.0; |
| 277 |
Warnings: |
| 278 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 279 |
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. |
| 280 |
SELECT unix_timestamp() into @time_0; |
| 281 |
include/start_slave.inc |
| 282 |
include/sync_slave_sql_with_master.inc |
| 283 |
SELECT unix_timestamp() into @time_1; |
| 284 |
Heartbeat event received |
| 285 |
|
| 286 |
*** Stopped slave *** |
| 287 |
include/stop_slave.inc |
| 288 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD= 0.1; |
| 289 |
Warnings: |
| 290 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 291 |
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. |
| 292 |
Number of received heartbeat events while slave stopped: 0 |
| 293 |
|
| 294 |
*** Started slave *** |
| 295 |
include/start_slave.inc |
| 296 |
Heartbeat event received |
| 297 |
|
| 298 |
*** Stopped IO thread *** |
| 299 |
include/stop_slave_io.inc |
| 300 |
Number of received heartbeat events while io thread stopped: 0 |
| 301 |
|
| 302 |
*** Started IO thread *** |
| 303 |
START SLAVE IO_THREAD; |
| 304 |
Warnings: |
| 305 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 306 |
include/wait_for_slave_io_to_start.inc |
| 307 |
Heartbeat event received |
| 308 |
|
| 309 |
*** Stopped SQL thread *** |
| 310 |
include/stop_slave_sql.inc |
| 311 |
Heartbeat events are received while sql thread stopped (1 means 'yes'): 1 |
| 312 |
|
| 313 |
*** Started SQL thread *** |
| 314 |
START SLAVE SQL_THREAD; |
| 315 |
Warnings: |
| 316 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 317 |
include/wait_for_slave_sql_to_start.inc |
| 318 |
Heartbeat event received |
| 319 |
|
| 320 |
*** Stopped SQL thread by error *** |
| 321 |
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT); |
| 322 |
include/sync_slave_sql_with_master.inc |
| 323 |
INSERT INTO t1 VALUES (1, 'on slave', NULL); |
| 324 |
INSERT INTO t1 VALUES (1, 'on master', NULL); |
| 325 |
call mtr.add_suppression("Replica SQL.*Duplicate entry .1. for key .t1.PRIMARY.. on query.* Error_code: MY-001062"); |
| 326 |
call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group"); |
| 327 |
Heartbeat events are received while sql thread stopped (1 means 'yes'): 1 |
| 328 |
include/stop_slave_io.inc |
| 329 |
DELETE FROM t1; |
| 330 |
include/start_slave.inc |
| 331 |
include/sync_slave_sql_with_master.inc |
| 332 |
DROP TABLE t1; |
| 333 |
|
| 334 |
include/sync_slave_sql_with_master.inc |
| 335 |
*** Flush logs on slave *** |
| 336 |
include/rpl_reset.inc |
| 337 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.5; |
| 338 |
Warnings: |
| 339 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 340 |
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. |
| 341 |
include/start_slave.inc |
| 342 |
include/assert.inc [Should receive at least one heartbeat event while running FLUSH LOGS for 10 seconds] |
| 343 |
|
| 344 |
*** Compressed protocol *** |
| 345 |
SET @@global.replica_compressed_protocol=1; |
| 346 |
include/stop_slave.inc |
| 347 |
RESET SLAVE; |
| 348 |
Warnings: |
| 349 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 350 |
RESET MASTER; |
| 351 |
SET @@global.replica_compressed_protocol=1; |
| 352 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1; |
| 353 |
Warnings: |
| 354 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 355 |
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. |
| 356 |
include/start_slave.inc |
| 357 |
Heartbeat event received |
| 358 |
SET @@global.replica_compressed_protocol=0; |
| 359 |
SET @@global.replica_compressed_protocol=0; |
| 360 |
|
| 361 |
*** Reset master *** |
| 362 |
STOP SLAVE; |
| 363 |
Warnings: |
| 364 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 365 |
RESET SLAVE; |
| 366 |
Warnings: |
| 367 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 368 |
RESET MASTER; |
| 369 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1; |
| 370 |
Warnings: |
| 371 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 372 |
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. |
| 373 |
include/start_slave.inc |
| 374 |
RESET MASTER; |
| 375 |
include/sync_slave_sql_with_master.inc |
| 376 |
Heartbeat events are received after reset of master (1 means 'yes'): 1 |
| 377 |
|
| 378 |
*** Reload master *** |
| 379 |
STOP SLAVE; |
| 380 |
Warnings: |
| 381 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 382 |
RESET SLAVE; |
| 383 |
Warnings: |
| 384 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 385 |
RESET MASTER; |
| 386 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1; |
| 387 |
Warnings: |
| 388 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 389 |
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. |
| 390 |
include/start_slave.inc |
| 391 |
Heartbeat event received |
| 392 |
include/rpl_restart_server.inc [server_number=1] |
| 393 |
include/wait_for_slave_io_to_start.inc |
| 394 |
Heartbeat event received |
| 395 |
|
| 396 |
*** Circular replication *** |
| 397 |
include/rpl_reset.inc |
| 398 |
include/stop_slave.inc |
| 399 |
include/rpl_change_topology.inc [new topology=1->2->1] |
| 400 |
Warnings: |
| 401 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 402 |
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. |
| 403 |
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=1; |
| 404 |
include/start_slave.inc |
| 405 |
CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)); |
| 406 |
INSERT INTO t1 VALUES(1, 'on master'); |
| 407 |
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=0.1; |
| 408 |
include/start_slave.inc |
| 409 |
INSERT INTO t1 VALUES(2, 'on slave'); |
| 410 |
include/sync_slave_sql_with_master.inc |
| 411 |
SELECT * FROM t1 ORDER BY a; |
| 412 |
a b |
| 413 |
1 on master |
| 414 |
2 on slave |
| 415 |
SELECT * FROM t1 ORDER BY a; |
| 416 |
a b |
| 417 |
1 on master |
| 418 |
2 on slave |
| 419 |
Heartbeat event received on master |
| 420 |
Heartbeat event received on slave |
| 421 |
*** Clean up *** |
| 422 |
DROP TABLE t1; |
| 423 |
SET @@global.replica_net_timeout=@restore_replica_net_timeout; |
| 424 |
include/rpl_end.inc |