Replication

IO 執行緒錯誤:1595(中繼日誌寫入失敗:無法將來自主伺服器的事件排隊)

  • September 17, 2018

奴隸狀態:

          Last_IO_Errno: 1595
          Last_IO_Error: Relay log write failure: could not queue event from master
          Last_SQL_Errno: 0

來自錯誤日誌:

      [ERROR] Slave I/O for channel 'db12': Unexpected master's heartbeat data: heartbeat is not compatible with local info; the event's data: log_file_name toku10-bin.000063<D1> log_pos 97223067, Error_code: 1623
      [ERROR] Slave I/O for channel 'db12': Relay log write failure: could not queue event from master, Error_code: 1595

我多次嘗試重啟slave_io執行緒,還是一樣。

我們需要在手動停止時繼續啟動 io_thread,希望它的錯誤來自 percona

我已經簡單地編寫了 shell 並每隔 10 分鐘安排一次,以檢查 io_thread 是否未執行,為通道 ‘db12’ 啟動從屬 io_thread;。它現在正在工作

引用自:https://dba.stackexchange.com/questions/154510