mysql里的cpon_mysql – 在Slick / HikariCP中连接关闭错误后不允许任何操作

我正在使用Slick3.1.1 HikariCP2.5.1.我的配置是：

rdsConfig = {

url = "jdbc:mysql://mydb.........us-west-2.rds.amazonaws.com:3306/owlschema"

driver = "com.mysql.jdbc.Driver"

connectionPool = HikariCP

maxConnections = 222

minConnections = 30

keepAliveConnection = true

properties = {

user = "me"

password = "mydarksecret"

}

numThreads = 40

}

我每3秒运行一次查询,每次查询都是< 0.4秒.起初一切运行正常,但大约2小时后,HikariCP开始关闭连接,导致错误“连接关闭后不允许操作”：

15:20:38.288 DEBUG [] [rdsConfig-8] com.zaxxer.hikari.pool.HikariPool - rdsConfig - Timeout failure stats (total=30, active=0, idle=30, waiting=0)

15:20:38.290 DEBUG [] [rdsConfig connection closer] com.zaxxer.hikari.pool.PoolBase - rdsConfig - Closing connection com.mysql.jdbc.JDBC4Connection@229960c: (connection is evicted or dead)

15:20:38.333 DEBUG [] [rdsConfig connection closer] com.zaxxer.hikari.pool.PoolBase - rdsConfig - Closing connection com.mysql.jdbc.JDBC4Connection@229960c failed

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_77]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_77]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_77]

at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.8.0_77]

是否有其他配置设置我需要避免这个？我不明白为什么HikariCP完全关闭连接,如果它想要,它不应该只提供我的代码与非关闭连接？它以其默认设置运行良好而闻名,所以我很困惑为什么它有问题.谢谢.