Hikari数据库连接池泄露问题排查

Hikari数据库连接池泄露问题排查

1、配置文件中配置泄露监测阈值

spring.datasource.hikari.leak-detection-threshold=600000

2、log配置日志输出

<Configuration status="INFO" monitorInterval="5" packages="com.jiuqi.np.log.log4j2.appender"> 
 	<properties>
        <!--设置日志在硬盘上输出的目录-->
        <!-- System.out.println(System.getProperty("java.io.tmpdir"));
             C:\Users\Kim\AppData\Local\Temp
         -->
        <property name="logPath">${sys:java.io.tmpdir}/jiuqi/logs</property>
        <property name="historyLogPath">${sys:java.io.tmpdir}/jiuqi/logs/history</property>
    </properties>
    <Appenders>
        <RollingFile name="hikariLogFile" fileName="${logPath}/hikari.log" filePattern="${historyLogPath}/$${date:yyyy-MM}/hikari-%d{yyyy-MM-dd}-%i.log.zip">
            <PatternLayout pattern="%d{YYYY-MM-dd HH:mm:ss.SSS} [%t] %C:%M:%L - %msg%n" />
            <Policies>
                <TimeBasedTriggeringPolicy interval="1" modulate="true" />
                <SizeBasedTriggeringPolicy size="20M" />
            </Policies>
            <DefaultRolloverStrategy max="20" />
        </RollingFile>
    </Appenders>
	<Loggers>
        <Logger name="com.zaxxer.hikari" level="INFO" additivity="false">
            <appender-ref ref="hikariLogFile" />
        </Logger>
	</Loggers>
</Configuration>

3、查看日志输出

win系统上述配置的默认文件夹地址：C:\Users\JIUQI\AppData\Local\Temp\jiuqi\logs

也可以在启动参数配置：java -Djava.io.tmpdir=/path/to/tmpdir

2022-08-22 12:43:38.819 [nr housekeeper] com.zaxxer.hikari.pool.ProxyLeakTask:run:84 - Connection leak detection triggered for oracle.jdbc.driver.T4CConnection@ac2d942 on thread http-nio-8188-exec-7, stack trace follows
java.lang.Exception: Apparent connection leak detected
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:?]
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) ~[spring-jdbc-5.3.20.jar:5.3.20]
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) ~[spring-jdbc-5.3.20.jar:5.3.20]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) ~[spring-jdbc-5.3.20.jar:5.3.20]
	at com.jiuqi.nr.dataentry.web.ActionController.batchCheckForm(ActionController.java:823) ~[main/:?]
	at com.jiuqi.nr.dataentry.web.ActionController$$FastClassBySpringCGLIB$$1.invoke(<generated>) ~[main/:?]

注意：有些数据库驱动，在远程连接数据库时hakari.log日志会抛出异常

2022-08-22 12:24:39.994 [main] com.zaxxer.hikari.pool.PoolBase:getAndSetNetworkTimeout:541 - nr - Driver does not support get/set network timeout for connections. (oracle.jdbc.driver.T4CConnection.getNetworkTimeout()I)

这种大概率是数据库驱动问题，如：上述问题用的ojdbc6，换成ojdbc7就没问题了。