quartz集群的数据库链接断开修复

最新推荐文章于 2024-05-21 11:50:19 发布

TitanSeekSun

最新推荐文章于 2024-05-21 11:50:19 发布

阅读量2.8k

点赞数 2

分类专栏： JAVA 文章标签：定时任务

本文链接：https://blog.csdn.net/titanseeksun/article/details/86471335

版权

本文主要讨论了在Quartz集群运行过程中遇到的数据库连接断开问题，原因是MySQL的wait_timeout设置不同导致。解决方案包括调整MySQL的wait_timeout参数、在Quartz配置中启用链接校验和配置验证查询，确保集群与数据库的链接有效性。同时提醒注意配置文件中的大小写正确性，避免因细节错误导致调试困扰。

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

错误日志简述：

o.q.i.j.JobStoreTX [?:?] Failed to override connection auto commit/transaction isolation.

xxx

Failure obtaining db row lock: Communications link failure

The last packet successfully received from the server was 2,173,381 milliseconds ago. The last packet sent successfully to the server was 19 milliseconds ago.

xxxxxx

Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

Caused by:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Caused by: java.net.SocketException: Broken pipe

其实就是一句话，定时任务集群和数据库的链接断掉了。原因呢，参考https://www.cnblogs.com/cyd-shuihan/p/9718099.html

由于测试（28800）仿真（5000）生产（1800）环境的 mysql wait_timeout时间设置的不同，导致这个定时任务