Replication_Error:Relay log write failure:could not queue event from master,eventqueue

來源:互聯網
上載者:User

Replication_Error:Relay log write failure:could not queue event from master,eventqueue

Mysql Version :5.6.16

OS Version :CentOS release 6.4 (Final)

Replication:Master-Master 



剛剛突然發現DB Master1(當前讀寫)磁碟滿了,DB Master2(當前不對外提供寫)replication 拋出異常:Relay log write failure:could not queue event from master,並且Slave_IO_Running: No。



當時第一個想到的解決辦法是嘗試在DB Master2上stop slave;start slave;重新整理複製線程的辦法,嘗試,不可。

然後嘗試查詢Master1上的binlog,找到對應binlog,尋找下個binlog pos點重新做change master操作跳過報錯pos點,嘗試,不可。報錯:



最後解決跳過整個binlog日誌,從下個binlog013048起繼續複製(此操作要視環境而定,需考慮複製下文資料是否會存在報錯的可能)。

然後使用pt工具校正複製差異,若存在差異,修複........

著作權聲明:本文為博主原創文章,未經博主允許不得轉載。

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.