springboot的Hikari的数据源报错Failed to validate connection

 

使用springboot的默认数据源 Hikari 的DataSource的时候，日志里面时常出现以下的异常日志：

 

HikariPool-1 - Failed to validate connection com.mysql.jdbc.JDBC4Connection@16521373 (No operations allowed after connection closed

 

 

修改springboot的数据源配置如下：

 

spring: 
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/xxxx
    username: root
    password: xxxxx
    hikari:    
      #timeout 5 minutes: 5 * 60 seconds. Here unit is ms.
      max-lifetime: 300000

 

 

新增如下的配置

 

    hikari:    
      #timeout 5 minutes: 5 * 60 seconds. Here unit is ms.
      max-lifetime: 300000

 问题解决。

 

 

观察springboot的启动日志可以发现如下的区别：

未添加spring.hikari.max-lifetime: 300000 之前启动日志：

FrameworkServlet 'dispatcherServlet': initialization started
FrameworkServlet 'dispatcherServlet': initialization completed in 35 ms
HikariPool-1 - Starting...
HikariPool-1 - Start completed.

 添加spring.hikari.max-lifetime: 300000 之后启动日志：

FrameworkServlet 'dispatcherServlet': initialization started
FrameworkServlet 'dispatcherServlet': initialization completed in 44 ms
HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling it.
HikariPool-1 - Starting...
HikariPool-1 - Start completed.

 发现多了一行：

HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling it.

 

 

 

参考地址：

https://www.cnblogs.com/l-tianyi/p/8143103.html