You need to talk to your application team and find out about their connection related timeouts. Things like max-idle-time, server-lifetime, etc. (They almost certainly use a db library which implements some kind of client side connection pool).
In short: their timeouts should be lower than the server's idle_session_timeout.
Something like: max-idle-time < server-lifetime < idle_session_timeout
Hi all,
I was facing issue with idle connections not closed.
So, I thought of automating it and set the parameter idle_session_timeout to 5min. But I got a message from application team that they are getting jdbc error continuously and they are saying connection is getting terminated. So I had to turn it off now.
How to use this parameter correctly?