主库 : 114.116.182.128
从库: 114.116.182.62
造成该错误原因:
之前手动在从库更改了数据,再在主库更改该条数据时,主从数据版本不一致。
解决:
- 进入主库的mysql界面
mysql -utkuser -pTk123qwe!
- 关闭主库的写操作
flush tables with read lock;
- 查看并记下主库的日志及position
show master status;
mysql> show master status \G *************************** 1. row
File: mysql-bin.000023 Position: 523859 Binlog_Do_DB: hm_advertise,hm_common,hm_num,hm_order,hm_user Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set (0.00 sec)
- 进入从库的mysql界面
mysql -umysql62 -pmysql62
- 关闭同步
mysql> stop slave \G
- 执行手动同步
change master to master_host = '114.116.182.128',master_user='tkuser',master_passwo