java应用mysql报错The last packet successfully received from the server was 231,450 milliseconds ago.

最新推荐文章于 2024-08-12 20:17:31 发布

fall_hat

最新推荐文章于 2024-08-12 20:17:31 发布

阅读量851

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/fall_hat/article/details/103630551

版权

mysql 专栏收录该内容

27 篇文章

订阅专栏

本文详细解析了当数据库连接池的max-lifetime大于mysql的wait_timeout时导致的超时错误。介绍了如何通过调整数据库的wait_timeout参数来解决此问题，避免应用程序中出现连接断开的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错内容：

The last packet successfully received from the server was 231,450 milliseconds ago. The last packet sent successfully to the server was 231,450 milliseconds ago. is longer than the server configured value of ‘wait_timeout’. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property ‘autoReconnect=true’ to avoid this problem
原因：数据库连接池的max-lifetime大于mysql的wait_timeout
修改方法：将数据库字段的wait_timeout字段设置大些
注意事项：要注意全局的wait_timeout字段。