天天看點

The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code

1 mysq error日志報錯如下:

2014-05-12 11:29:54 22977 [ERROR] Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code: 1590

2014-05-12 11:29:54 22977 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log ‘mysql-bin.010275‘ position 91642

2 登入mysql從庫,check slave狀态

從這裡看出來,複制down了。

3,google了很多資料,大部分出現在mysql cluster中,大家的做法都是從新做從庫,或者換個master接入點。

時間緊急,我也隻能從新搭建從庫了,特留此記錄于此,如果有朋友看到這裡,有别的解決方案,非常歡迎留言或者發email到[email protected]