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

素颜马尾好姑娘i 2023-07-24 09:04 32阅读 0赞

问题：最近公司服务器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;

![20200410164134911.png][]

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

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE0Nzc5MTQ_size_16_color_FFFFFF_t_70][]

[20200410164134911.png]: /images/20230528/045f5946d13d44778dc309d0e202f9da.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE0Nzc5MTQ_size_16_color_FFFFFF_t_70]: /images/20230528/ccafd9b483b04285937c9ecb15f06f63.png