Error on confluence start: "JDBC exception on Hibernate data access"

Vespasian

Hello, 

I am getting an error when starting confluence:

Description: Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)

Level: fatal

Exception: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [XX000]; error code [0]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

This started showin up after I upgraded my instance of Linux Mint Debian (LMDE) version 2 to version 3. 

I have tried upgrading confluence to its latest version 6.14.1. Tried uninstalling and reinstalling confluence. Still see the same issue. 

I have also checked the postgres database for any issues, but do not see any. 

Any suggestions on how I could resolve the error would be great!

Thank you

Kiran Panduga {Appfire}

Hi @Vespasian , 

This error is mostly noticing while using the H2 database i.e The H2 database is only supported for testing/DEV  instances, and I especially wouldn't recommend for Production.

Before starting the Confluence, can you go into the Home Directory and verify the confluence.cfg.xml file to see if the database is H2 or PostgreSQL.

If it's pointing to the H2 database, make sure to take a copy of the home directory and then start the Confluence with empty home directory, this time it would prompt to enter the Database details and make sure to add the PostgreSQL database details.

After which, if you have a backup copy of the database, you can restore and restart he Confluence again.

 

Thanks,

Kiran.