jira crashes frequently do to database connection issue. How to resolve that?

Question

jira crashes frequently do to database connection issue.

Error in atlassian-jira.log is as below:

Cannot get a connection, pool exhausted, cause: Timeout waiting for idle object

Unable to esablish a connection with the database. (Communications link failure

Please help to resolve this issue

Christian Czaia [Decadis AG] · Answer

Hey,

have a look at this document. You might want to increase the DB pool size:

https://confluence.atlassian.com/display/JIRA/Tuning+Database+Connections#TuningDatabaseConnections-Connectionpoolsettings

Cheers

Roshni J2 · Answer

Hi ,

We already tried increasing the pool size and some tunings in dbconfig.xml. Still the issue persists.

Any other suggestions? We found a document https://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures. can you please check and revert if this settings can help to resolve the issue?

Thanks

Roshni