《Mysql實例mysql同步中斷報錯 [ERROR] Slave: Query caused different errors》要點:
本文介紹了Mysql實例mysql同步中斷報錯 [ERROR] Slave: Query caused different errors,希望對您有用。如果有疑問,可以聯系我們。
導讀:mysql同步中斷報錯:[ERROR] Slave: Query caused different errors on master and slave. Error on master: Table %-.64s ...
MYSQL必讀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
MYSQL必讀出現上面的報錯信息,原因是表壞了,需要把表修復一下,然后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>
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/6460.html