写数据时出现2013，Lost connection to MySQL server during query错误问题解决

最新推荐文章于 2024-08-22 11:24:28 发布

Lzs1998

最新推荐文章于 2024-08-22 11:24:28 发布

阅读量1.8k

点赞数

分类专栏：项目经验文章标签： mysql

本文链接：https://blog.csdn.net/Lzs1998/article/details/101568546

版权

在服务器上部署的定时调度程序出现异常退出，日志显示'2013, Lost connection to MySQL server during query'错误。经过排查，确认非代码bug，而是MySQL配置问题。主要通过调整net_read_timeout、connect_timeout和max_allowed_packet参数来避免大量数据传输时的连接中断问题。" 119787296,11289391,浮动布局在HTML5中的应用与实现,"['HTML', 'CSS', '前端开发']

摘要由CSDN通过智能技术生成

写了一个定时调度程序，在本地测试下没什么问题，但是部署到服务器上时不时就出现异常退出了，查看了程序运行日志，出现了以下异常

[2019-09-27 22:15:18,994: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:18,997: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:18,997: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:19,054: WARNING/ForkPoolWorker-12] (0, '')
[2019-09-27 22:15:18,997: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:18,998: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:18,998: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during query')
[2019-09-27 22:15:18,998: WARNING/ForkPoolWorker-12] (2013, 'Lost connection to MySQL server during qu