I have a Spring Boot app with below database pool settings. If the app continuously runs for 2 to 3 days, I get pool empty error. So, 2 questions regarding this,
- I really suspect connection leaks might have happened. No. of users for our application is very less, so 32 should not be exhausted for our user base. How can I find leaked connections?
If I want to tell Spring to create few more connections when maxActive(32 in my case) is reached, what is the setting needs to be added?
poolProperties.setMaxWait(5000); //5 secs
o.h.e.jdbc.spi.SqlExceptionHelper.logExceptions(129) - [http-nio-6061-exec-9] Timeout: Pool empty. Unable to fetch a connection in 5 seconds, none available[size:32; busy:32; idle:0; lastwait:5000]