We experience the problem with PoolExhaustedException when running Camunda connected to Oracle DB. At some point Camunda stops working because of this error.
org.apache.tomcat.jdbc.pool.PoolExhaustedException: [pool-3-thread-1544] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000].
The problem could be resolved by restarting the Camunda server but we need to get rid of this error as it keep appearing.
Is it related to the number of connections which is set in ‘server.xml’? We tried maxTotal=“50” and maxTotal=“100” but still eventually get the error. Does it has sense to increase this number? Is it safe?
Sometimes we also get the error “ORA-29270: too many open HTTP requests”. Is it related to PoolExhaustedException?