1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection master]
include/sync_slave_sql_with_master.inc
stop slave;
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
# Adding debug point 'simulate_find_log_pos_error' to @@GLOBAL.debug
reset slave;
ERROR HY000: Target log not found in binlog index
show warnings;
Level Code Message
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
Error 1373 Target log not found in binlog index
Error 1371 Failed purging old relay logs: Failed during log reset
# Removing debug point 'simulate_find_log_pos_error' from @@GLOBAL.debug
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE to SOURCE_HOST='dummy';
# Adding debug point 'simulate_find_log_pos_error' to @@GLOBAL.debug
CHANGE REPLICATION SOURCE to SOURCE_HOST='dummy';
ERROR HY000: Target log not found in binlog index
# Removing debug point 'simulate_find_log_pos_error' from @@GLOBAL.debug
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
CHANGE REPLICATION SOURCE to SOURCE_HOST='dummy';
# Adding debug point 'simulate_find_log_pos_error' to @@GLOBAL.debug
reset master;
ERROR HY000: Target log not found in binlog index
# Removing debug point 'simulate_find_log_pos_error' from @@GLOBAL.debug
reset master;
# Adding debug point 'simulate_find_log_pos_error' to @@GLOBAL.debug
purge binary logs to 'master-bin.000001';
ERROR HY000: Target log not found in binlog index
# Removing debug point 'simulate_find_log_pos_error' from @@GLOBAL.debug
purge binary logs to 'master-bin.000001';
==== clean up ====
CHANGE REPLICATION SOURCE TO SOURCE_HOST = '127.0.0.1';
include/rpl_end.inc
|
