具体警告内容:
2020-01-13 14:26:58.733 WARN 15263 --- [http-nio-8830-exec-10] com.zaxxer.hikari.pool.PoolBase : MyHikariCP - Failed to validate connection [email protected] (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2020-01-13 14:26:58.735 WARN 15263 --- [http-nio-8830-exec-10] com.zaxxer.hikari.pool.PoolBase : MyHikariCP - Failed to validate connection [email protected] (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2020-01-13 14:26:58.737 WARN 15263 --- [http-nio-8830-exec-10] com.zaxxer.hikari.pool.PoolBase : MyHikariCP - Failed to validate connection [email protected] (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
看到的大部分解决方案是修改hikari的 max-lifetime配置(不是改大就是该小),各种方法都试过了,然而都没有解决这个问题。
还有一种比较接近的方案就是:
首先在mysql中执行
SHOW VARIABLES LIKE "%timeout%";
得到结果:
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsICM38FdsYkRGZkRG9lcvx2bjxiNx8VZ6l2csQjVuJGc4JDW1Z1RhpWNXlFcwdFZwhnMMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnL5YjN1UTM1QTMzETMwAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
坑就坑在这里了,这里查出来的wait_timeout的值显示的是28800秒,误导我以为数据库配置的wait_timeout就是28800,然而并不是,一次偶然的机会,执行了下 vim /etc/my.cnf ,忽然看到下面的画面:
我的天,这个玩意谁改的。。。。。
好了,问题找到了,把这项改成28800(8小时),再重启mysql
service mysqld restart
问题解决。。。