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