Unable to acquire JDBC Connection

anshul.sehgal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 17, 2023

We were getting below exceptions in logs for few days 

[security.denormalisedpermissions.impl.DenormalisedPermissionStateManagerImpl] reloadServiceState reloadServiceState failed: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.jav

runJob Scheduled job confluence.extra.webdav:contentJobQueueExecutor#contentJobQueueExecutorTrigger jobToBeExecuted failed to run org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:476) ... 24 lines omitted ... Caused by: net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

onCronEvent Unable to process records: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:476) ... 27 lines omitted ... at java.base/java.lang.Thread.run(Unknown Source) Caused by: net.sf.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

And after reboot of the server all exceptions have gone away. What can be the reason of these errors going away suddenly. Any pointers will be helpful

1 answer

1 accepted

1 vote
Answer accepted
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 17, 2023

Try going thru this post.

https://confluence.atlassian.com/confkb/unable-to-start-due-to-net-sf-hibernate-exception-genericjdbcexception-cannot-open-connection-128843899.html

However, if Confluence is working and you have just noticed these exceptions in the log, it's likely that Confluence was having issues connecting to the database resolved itself.

anshul.sehgal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 17, 2023

Thanks @Shawn Doyle - ReleaseTEAM , Our errors existed for almost 10 days and when we reinstalled confluence on new host, it got resolved, so not able to figure out what got changed during that time which resolved the issue.

Note : There are no database changes done. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events