You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
oracle version = Oracle Database Enterprise Edition Release 19.0.0.0.0
HikaryCP = 5.0.1
The following happened in a few of our test environments (but I cannot reproduce it locally).
After an outage of the DB, the connection pool was not able to recover when the DB was up and running again.
After the spring application is restarted the problem is solved, but a restart should not be necessary in this scenario.
The exception (happening over and over again until the Spring application is restarted) is:
When I reproduce the scenario locally (stopping and restarting the DB), the datasource recovers after the DB is restarted.
Have you tried setting the socket read timeout for Oracle JDBC? If you don't set the Read Timeout, Oracle's default socket read timeout is null. This means that after a Tomcat thread borrows a connection from the Hikari connection pool, it could infinitely wait for the query result without recovering, after db outage happened.
Context:
The following happened in a few of our test environments (but I cannot reproduce it locally).
After an outage of the DB, the connection pool was not able to recover when the DB was up and running again.
After the spring application is restarted the problem is solved, but a restart should not be necessary in this scenario.
The exception (happening over and over again until the Spring application is restarted) is:
When I reproduce the scenario locally (stopping and restarting the DB), the datasource recovers after the DB is restarted.
The problem is the same as described in https://stackoverflow.com/questions/69566390/hikari-cp-spring-boot-connection-recovery-problem-after-db-failure
The text was updated successfully, but these errors were encountered: