Open psneha716 opened 7 months ago
Hi, were you able to find any solution?
Hello @psneha716, can you share your Hikari/hibernate/jpa config?
Hi @oucem00decat, Thanks for taking a look at the issue. Below are the config details:
spring.jpa.hibernate.ddl-auto=none spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect spring.jpa.properties.hibernate.connection.release_mode=after_transaction
logging.level.com.zaxxer.hikari.HikariConfig=DEBUG logging.level.com.zaxxer.hikari=TRACE spring.datasource.hikari.leak-detection-threshold=60000 spring.datasource.hikari.maximum-pool-size=50 spring.datasource.hikari.minimum-idle=5 spring.datasource.hikari.connection-timeout=30000
Hi team, We've been facing the following issue since quite sometime in our application that the number of active connections goes upto 50(max) and the connections are not returned back to the pool. Have enabled ProxyLeak detection which reports leaks for all the active connections and they are released only when the application is restarted/an OOM error happens which forces the application to restart. Any help will be greatly appreciated. Thanks in advance!
Spring data jpa + Hibernate + jdbc Jdk: 18 DB: Postgresql (42.3.5) Hikaricp: 4.0.3 Spring boot: v2.7.0
Tried setting spring.jpa.properties.hibernate.connection.release_mode=after_transaction, bit it didn't work.
Logs:
One such connection leak log: