WARN PoolBase:176 - DateSourceHikariCP - Failed to validate connection com.m

我就是我，是不一样的烟火

于 2020-01-24 18:45:11 发布

阅读量827

点赞数

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/weixin_43636291/article/details/104073186

版权

在使用SpringBoot 2.0及Hikari连接池时，遇到数据库连接超时的问题。检查发现数据库连接配置和服务器设置一致，但调整配置并未解决问题。目前尚未找出解决方案。

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

最近使用springboot2.0+hikari连接池，程序在过段时间访问数据库就会报下面错误：


2020-01-22 22:17:10 WARN  PoolBase:176 - DateSourceHikariCP - Failed to validate connection com.mysql.jdbc.JDBC4Connection@6abdb43e (Communications link failure

The last packet successfully received from the server was 980,321 milliseconds ago.  The last packet sent successfully to the server was 5,000 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
2020-01-22 22:17:15 WARN  PoolBase:176 - DateSourceHikariCP - Failed to validate connection com.mysql.jdbc.JDBC4Connection@4efcb030 (Communications link failure

The last packet successfully received from the server was 1,048,069 milliseconds ago.  The last packet sent successfully to the server was 5,001 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
2020-01-22 22:17:20 WARN  PoolBase:176 - DateSourceHikariCP - Failed to validate connection com.mysql.jdbc.JDBC4Connection@49ba5a72 (Communicat

最低0.47元/天解锁文章