AnsweredAssumed Answered

Cannot get a connection, pool error Timeout waiting for idle object

Question asked by Lakshmanan Ramanathan on Jan 8, 2021
Latest reply on Jan 20, 2021 by Lakshmanan Ramanathan

We been experiencing sporadic  error " Cannot get a connection, pool error Timeout waiting for idle object.

2021-01-07 17:50:12,618 ERROR [pool-11-thread-3] [] [] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <Cannot get a connection, pool error Timeout waiting for idle object>

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

2021-01-07 17:50:14,122 ERROR [http-apr-10.14.138.64-8443-exec-136] [] [] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <Cannot get a connection, pool error Timeout waiting for idle object>

org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

2021-01-07 17:50:19,134 ERROR [http-apr-10.14.138.64-8443-exec-141] [] [] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <Cannot get a connection, pool error Timeout waiting for idle object>

 

Currently we have 12 JVM load balanced. total of 1680 database connections in a given time.  Initially we had 9 JVM and increased 3 more and we still have the problem.  Here is the DB connection string.

                maxActive="140"

                maxWait="25000"

                fastConnectionFailoverEnabled="true"

                driverClassName="oracle.jdbc.OracleDriver"

                maxIdle="40"

                validationQuery="Select 1 from Dual"

Outcomes