Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Apparent connection leak detected error #2227

Open
justinsumida opened this issue Aug 7, 2024 · 0 comments
Open

Apparent connection leak detected error #2227

justinsumida opened this issue Aug 7, 2024 · 0 comments

Comments

@justinsumida
Copy link

justinsumida commented Aug 7, 2024

We recently converted to Spring Boot 3 as a major upgrade and switched from Tomcat to Hikari. We are currently running load tests and are noticing a large change in the 99th percentile of overall response time to our web service.

One thing we notice is a lot of Apparent connection leak errors, we have the leak detection threshold set at 5 seconds right now to diagnose troubles.
Our Oracle DBE reported no queries taking close to 5 seconds from his perspective in OEM.

With a major upgrade, it can very well be another issue, but with the disconnect between a leak detection to OEM reporting fast queries, Hikari is our lead we are chasing. Is there a reason that we could be seeing such long connection times?

Our current settings look like this:

registerMbeans: true
maximum-pool-size: 20
connection-timeout: 30000 # 30 seconds
idle-timeout: 600000 # 10 minutes
max-lifetime: 1800000 # 30 minutes
leak-detection-threshold: 5000 # 5 seconds
data-source-properties:
  oracle:
    jdbc:
      defaultConnectionValidation: LOCAL
  socketTimeout: "30"

Any help here would be appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant