Confluence upgrade issue - unable to access

[Deleted user]

Attempting to upgrade Confluence 6.9 to 6.14 on a local server, we are now unable to access the application. The error message previously on launching 6.14 was:

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

We see this is because we tried upgrading using the H2 database. We've now removed 6.14 and tried reinstalling 6.9, but now get this message:

type Exception report

message Confluence is vacant, a call to tenanted [public abstract org.hibernate.Session org.hibernate.SessionFactory.getCurrentSession() throws org.hibernate.HibernateException] is not allowed.

description The server encountered an internal error that prevented it from fulfilling this request.

Any ideas how we can re-install and using the backups we took prior to all this ?

[Deleted user · Accepted solution]

We were able to restore a backup once we created an MS SQL database. We then upgraded to 6.14.

[Shannon S]

Nick,

Thank you for confirming you were able to resolve the issue.

Take care, and have a pleasant rest of your week.

Regards,

Shannon

[Shannon S · Accepted solution]

Nick,

Can you let me know if you're using the internal H2 database for this? If so, you'll need to migrate immediately to a supported database. H2 database is supported only for evaluation, and tends to fail during upgrades for this reason. I ask because I see this error most often when users try to upgrade an H2 database.

If you are not using the H2 database, can you let me know what database version you are using? 

Regards,

Shannon

[Shannon S]

Apologies - I see now you did confirm you were using the H2 database. I missed that sentence.

Please do migrate your data over to the supported database at this time, so you can bring Confluence back online.

Regards,

Shannon