Slave: received end packet from server, apparent master shutdown

標籤：mysql複製

資料庫的一台從產生大量的如下錯誤： 

140121 13:56:07 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 220648071
140121 13:56:09 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:09 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 220718334
140121 13:56:10 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 221074239
140121 13:56:12 [Note] Slave: received end packet from server, apparent master shutdown:

原來slave上的my.cnf 設定檔是一台台拷貝的，忘記修改server-id值，導致server-id值相同，server-id值一定保持唯一。

本文出自 “dba天空” 部落格，請務必保留此出處http://9425473.blog.51cto.com/9415473/1664024

Slave: received end packet from server, apparent master shutdown