暂无图片
[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
我来答
分享
知识蛀虫
2019-11-30
[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

2019-11-30 04:10:36 47114 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2019-11-30 04:10:36 47114 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘binlog.002260’ at position 329464093
2019-11-30 04:10:36 47114 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ‘START SLAVE Syntax’ in the MySQL Manual for more information.
2019-11-30 04:10:46 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 1, Error_code: 2013
2019-11-30 04:11:56 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 2, Error_code: 2013
2019-11-30 04:13:06 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 3, Error_code: 2013
2019-11-30 04:14:16 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 4, Error_code: 2013
2019-11-30 04:15:26 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 5, Error_code: 2013
2019-11-30 04:16:37 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 6, Error_code: 2013
2019-11-30 04:17:47 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 7, Error_code: 2013
2019-11-30 04:18:57 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 8, Error_code: 2013
2019-11-30 04:20:07 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 9, Error_code: 2013
2019-11-30 04:21:17 47114 [ERROR] Slave I/O: error reconnecting to master ‘repli@172.31.1.67:3306’ - retry-time: 60 retries: 10, Error_code: 2013
2019-11-30 04:22:22 47114 [Note] Slave: connected to master ‘repli@172.31.1.67:3306’,replication resumed in log ‘binlog.002260’ at position 329464093
2019-11-30 05:04:29 47114 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2019-11-30 05:04:29 47114 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘binlog.002261’ at position 38361784
2019-11-30 05:04:29 47114 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ‘START SLAVE Syntax’ in the MySQL Manual for more information.
2019-11-30 05:24:01 47114 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2019-11-30 05:24:01 47114 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘binlog.002261’ at position 105884756

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
知识蛀虫

主从偶尔会断开连接

暂无图片 评论
暂无图片 有用 0
春去秋来

如果你的slave的IO和sql进程已经正常了,就需要排查一下,当时master或者slave的服务器资源使用情况,是否有内存,IO,cpu不够用的情况,网络流量是否打满
如果slave还是异常,请执行

show slave status\G

看看复制报的最后一个错误是什么,进一步排查

暂无图片 评论
暂无图片 有用 0
外包DBA

网络问题,这种是mysql主从无法避免的,一个主不能带太多的slave,产生binlog太多也会这样~

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏