报错信息：Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction ‘NOT_YET_DETERMINED’ at master log mysql-bin.002207, end_log_pos 752133877. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
紧急恢复步骤：
stop slave;
reset slave;
CHANGE master to MASTER_HOST=“172.18.3.", master_port=33060,MASTER_USER="", MASTER_PASSWORD="****”, MASTER_LOG_FILE=“mysql-bin.002207”, MASTER_LOG_POS=752133877;
是否可行？？？，数据能保持一致吗？？？
紧急恢复步骤：
stop slave;
reset slave;
CHANGE master to MASTER_HOST=“172.18.3.", master_port=33060,MASTER_USER="", MASTER_PASSWORD="****”, MASTER_LOG_FILE=“mysql-bin.002207”, MASTER_LOG_POS=752133877;
start slave;
是否可行？？？，数据能保持一致吗？？？
通过这样的方式恢复，我关注一下，发现Read_Master_Log_Pos跟Relay_Log_Pos相差过大
让我有点冷汗直下
评论
有用 0我是从出问题的binlog文件以及binlog日志点恢复的，按逻辑来说，同步到mysql-bin.00220跟752133877点报错，那么我就从mysql-bin.00220跟752133877点开始重新同步，为什么会数据不一致，想不明白这一点。
评论 有用 0
