Confluence server VM was restarted unexpectedly, now unable to access confluence. Database was not restarted and is functional.
Environment:
Confluence 7.1.0 on Ubuntu 18.04
MySQL 8.0.18 on Ubuntu 18.04
Error:
Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)
| 2020-04-12 19:13:07 | fatal | JDBC exception on Hibernate data access: SQLException for SQL [select schedulerr0_.id as id1_50_, schedulerr0_.job_id as job_id2_50_, schedulerr0_.start_time as start_ti3_50_, schedulerr0_.duration as duration4_50_, schedulerr0_.outcome as outcome5_50_, schedulerr0_.message as message6_50_ from scheduler_run_details schedulerr0_ where schedulerr0_.job_id=? order by schedulerr0_.start_time desc]; SQL state [S1009]; error code [0]; could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query |
Confirmed connectivity to database is okay.
Looking at confluence.log:
2020-04-12 19:13:07,197 ERROR [Catalina-utility-1] [atlassian.config.lifecycle.LifecycleManager] panicAndShutdown Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)
org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [select schedulerr0_.id as id1_50_, schedulerr0_.job_id as job_id2_50_, schedulerr0_.start_time as start_ti3_50_, schedulerr0_.duration as duration4_50_, schedulerr0_.outcome as outcome5_50_, schedulerr0_.message as message6_50_ from scheduler_run_details schedulerr0_ where schedulerr0_.job_id=? order by schedulerr0_.start_time desc]; SQL state [S1009]; error code [0]; could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query
....
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
I have a VM level backup and database dumps, if it comes to it, but would prefer to fix if it's possible.
Thanks!
