在使用SpringBoot 2.0及Hikari连接池时，遇到数据库连接超时的问题。检查发现数据库连接配置和服务器设置一致，但调整配置并未解决问题。目前尚未找出解决方案。
最近使用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元/天 解锁文章
2608
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
