Mysql主从同步 Error reading packet from server: Lost connection to MySQL server during query 错误解决

问题：最近公司服务器Mysql主从同步

通过执行show slave status\G; 查看返回的

Slave_IO_Running: Yes
Slave_SQL_Running: Yes，

状态一切正常

可是数据无法正常同步，

经一番排查，是主从同步断开连接，通过如下步骤操作就可以恢复

 

1、确定主从同步问题，用txt打开文件C:\ProgramData\MySQL\MySQL Server 5.5\data\WIN-L2N8ANRGSLS.err查看到如下报错

200410  7:52:57 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
200410  7:52:57 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000051' at position 27394280

2、到主服务器执行

show master status;

3、在从服务执行如下代码，即可修复主从同步问题

stop slave;
change master to master_log_file='mysql-bin.000051',master_log_pos=46234080;
start slave;
show slave status\G;