SpringBoot警告-springboot2.0 hikaricp - failed to valid... no operations allowed after connection clos

SpringBoot警告-springboot2.0 hikaricp - failed to valid... no operations allowed after connection closed.

——墨问苍生


 

1 2020-01-13 14:26:58.733  WARN 15263 --- [http-nio-8830-exec-10] com.zaxxer.hikari.pool.PoolBase          : MyHikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@49fe3d0e (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2 2020-01-13 14:26:58.735  WARN 15263 --- [http-nio-8830-exec-10] com.zaxxer.hikari.pool.PoolBase          : MyHikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@516aa6c4 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

首先在mysql中执行

1 SHOW VARIABLES LIKE "%timeout%";

SpringBoot警告-springboot2.0 hikaricp - failed to valid... no operations allowed after connection clos

 

后查阅资料发现不是这个问题

修改/etc/my.cnf文件,添加或修改如下代码

SpringBoot警告-springboot2.0 hikaricp - failed to valid... no operations allowed after connection clos

 

 问题解决

 

上一篇:SFTP上传出错之: com.jcraft.jsch.JSchException: connection is closed by foreign host


下一篇:swift_slowAlloc Crash 分析