Got fatal error 1236 from master when reading data from binary log

Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event 'mysql-bin.000091'

 

 저 같은 경우에는 replication 을 사용하는중 마스터 서버를 재부팅할때 발생하였습니다.

 

mysql> stop slave; mysql> CHANGE MASTE R TO MASTER_LOG_FILE='mysql-bin. 000092', MASTER_LOG_POS=4; mysql> start slave; mysql> show slave status \G;

 이렇게 현재 읽고있는 log 를 다음으로 변경하여 수정하였습니다.

 

https://www.percona.com/blog/2014/10/08/mysql-replication-got-fatal-error-1236-causes-and-cures/