HikariCP
HikariCP copied to clipboard
Connection leak detection triggered for oracle.jdbc.driver.T4CConnection java.lang.Exception: Apparent connection leak detected
We are suddenly getting Apparent connection leak detected in project. Please find the attached snap.
1600 active session were not killed even after reboot of microservice server. Created indexes on three columns of one table to avoid the tm-contention in database.
HikariCP version is - 3.2.0 Below is the configuration with Spring boot with version 2.1.5 :
spring:
datasource:
hikari:
connection-timeout: 30000
idle-timeout: 600000
max-lifetime: 840000
pool-name: xyz
minimum-idle: 100
maximum-pool-size: 500
transaction-isolation: TRANSACTION_READ_COMMITTED
leak-detection-threshold: 60000
jpa:
open-in-view: true
show-sql: true
hibernate:
ddl-auto: none
properties:
hibernate:
connection:
release-mode: AFTER_STATEMENT
current_session_context_class: org.springframework.orm.hibernate5.SpringSessionContext
dialect: org.hibernate.dialect.Oracle10gDialect
Please let me know how to tackle this ?