mysql同步中断报错 [ERROR] Slave: Query caused different errors

发布时间:2019-11-05编辑:脚本学堂
本文介绍了mysql同步数据时中断,并报错[ERROR] Slave: Query caused different errors的解决方法,有需要的朋友参考下。

mysql同步中断报错:
 

[ERROR] Slave: Query caused different errors on master and slave.     Error on master: 'Table '%-.64s' is marked as crashed and should be repaired' (1194), Error on slave: 'no error' (0). Default database: 'house'. Query: 'update sell set esta='2' where esta='1' and `expiretime`!='' and `expiretime`<1224795661', Error_code: 0

出现上面的报错信息,原因是表坏了,需要把表修复一下,然后slave start 即可。
 
mysql slave 出现复制错误“Could not parse relay log event entry
 
可以执行下面的语句:
 

复制代码 代码示例:
CHANGE MASTER TO
MASTER_LOG_FILE=<Relay_Master_Log_File>,
MASTER_LOG_POS=<Exec_Master_Log_Pos>