Confluence upgrade issue - unable to access

unknown

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 ?

 

 

Shannon S

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