Driver pool leakage detection

JDBC4Connection ffd on thread http-nioexec-8 was returned to the pool unleaked log row. Which version of Hikari CP are you using? How long does it take to execute the method?

If it is longer then 2seconds Hikari will log this warning as that is what you confiugred it to do. MatteoBaldi HikariCP 2. Add a comment. Active Oldest Votes. Matteo Baldi Matteo Baldi 4, 9 9 gold badges 34 34 silver badges 46 46 bronze badges. I am still getting the same error even if I set hikariConfig. It depends on the query time If I used this query over SQLDeveloeper, it only takes 25 secs, almost 20 batch jobs are already running, is that causing because of that?

Its happening in few batch jobs. Well, all those jobs share the same connection pool? Have you tried tuning its size? Typically, after an application reaches a stable running state, it allocates memory and free memory at roughly the same rate. If it tends to allocate memory faster than it frees it, its memory use will grow over time.

This often indicates a memory leak. After you have determined which pool tag is associated with the leak, this might reveal all you need to know about the leak.

If you need to determine which specific instance of the allocation routine is causing the leak, see Using the Kernel Debugger to Find Kernel-Mode Memory Leaks.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. We cannot see the "borrow" action in the log, but we can infer it:.

Jdbc4Connection e Jdbc4Connection e , stack trace follows java. Exception: Apparent connection leak detected at scala. Jdbc4Connection e was returned to the pool unleaked. Thanks brettwooldridge ,. This connection was likely added because a client thread was requesting a connection I don't know how I can state this more clearly, somewhere in your code you are borrowing a connection and keeping it out of the pool for exactly one minute, then closing it.

Basically it looks like:. That is the equivalent of what is going on. Because the logs show this occurring every minute Don't do that. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary Necessary. Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.