search

openbouquet / HikariCP

Custom version of HikariCP to support ClassLoader isolation
Apache License 2.0
11 stars 19 forks source link

Springboot 2, HikariCP and Microsoft SQL Server 2014 #3

Open vamsi-616 opened 3 years ago

vamsi-616 commented 3 years ago

We have services written in Springboot 2 and we are using SQL Server as backend database

Hikaricp is 3.4.1 [compile] - Comes with spring-boot-starter-jdbc: 2.2.1.RELEASE Microsoft SQL Server 2014 Springboot 2.2.1

2 Issues: 1.The Hikari Get connection is taking some times more than 4 sec's intermittently (Java/com.zaxxer.hikari.HikariDataSource/getConnection) 2.Failed to validate connection ConnectionID:XXXX(The connection is closed.). Possibly consider using a shorter maxLifetime value.

minimum-idle:3 maximum-pool-size: 25 connection-timeout: 60000 idle-timeout: 60000 max-lifetime: 6000 allow-pool-suspension: true register-mbeans: true leak-detection-threshold: 60000

We have enabled Debug logs to capture any leaked detections but nothing was observed, any inputs ?

vamsi-616 commented 3 years ago

Today we have changed below settings and the number of occurrences reduced but still same issue. Ideally validationtimeout to 2 secs is helping our SLA because it’s checking next available connection from bag and pulling data after 2 seconds

minimum-idle: 5 maximum-pool-size: 25 connection-timeout: 30000 idle-timeout: 25000 max-lifetime: 30000 allow-pool-suspension: true register-mbeans: true leak-detection-threshold: 25000 validationtimeout : 2000

vamsi-616 commented 3 years ago

Team,

Any inputs on this issue ?

We have engaged Microsoft and they are not able to see any connections forcibly closed by SQL