jdbcpingquery mysql_java – 如何缓解连接com.mysql.jdbc.JDBC4Connection@11d08960触发的连接泄漏,...

我有一个mqtt客户端获取主题请求订阅,

然后我把它交给固定大小为50的线程池.

我使用hikaricp 2.4.2 for DB Pooling

MySQL数据库.

我目前正在使用2.4.2,这是我的设置

HikariConfig config = new HikariConfig();

config.setDataSourceClassName(CLASS_FOR_NAME);

config.setJdbcUrl(HOST);

config.setUsername(USER);

config.setPassword(PASS);

config.addDataSourceProperty("cachePrepStmts", "true");

config.addDataSourceProperty("prepStmtCacheSize", "250");

config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

config.setLeakDetectionThreshold(TimeUnit.SECONDS.toMillis(30));

config.setValidationTimeout(TimeUnit.MINUTES.toMillis(1));

config.setMaximumPoolSize(10);

config.setMinimumIdle(0);

config.setMaxLifetime(TimeUnit.MINUTES.toMillis(2)); // 120 seconds

config.setIdleTimeout(TimeUnit.MINUTES.toMillis(1)); // minutes

config.setConnectionTimeout(TimeUnit.MINUTES.toMillis(5));

config.setConnectionTestQuery("/* ping */ SELECT 1");

下面是完整的日志消息：

WARNLOG：

811439 [Hikari housekeeper (pool HikariPool-0)] WARN

com.zaxxer.hikari.pool.ProxyLeakTask – Connection leak detection

triggered for connection com.mysql.jdbc.JDBC4Connection@11d0896, stack

trace follows java.lang.Exception: Apparent connection leak detected

at com.hcpdatabase.DataSource.getConnection(DataSource.java:69)

at com.database.AccessDatabase.create_alert(AccessDatabase.java:3849)

at com.runnable.StartTaskRunnable2.execute(StartTaskRunnable2.java:78)

这是正常的吗？我必须抓住这个吗？