Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unable to start up Confluence

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:07fatalJDBC 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!

2 answers

1 accepted

0 votes
Answer accepted

Attempted restore of ZIP backup on a fresh install, of same version - got an error with restoring. 

New database, new server, fresh install, restored backup from 2 days prior and we're back up and running. 

Daniel Eads Atlassian Team Apr 15, 2020

Hey Jacob, welcome to the Community! Glad to hear you were able to get things working again. Thanks for updating us and accepting your answer, so we know the problem was solved. Hope to see you around!

It is not resolved. This is a workaround.

We are experiencing the exact same problem.  Completely rebuilding should not be an acceptable answer.  Atlassian, help to troubleshoot this is what's needed.

0 votes

Hi

We had a similar issue.  Jira started OK but Confluence did not.  This occurred after a server restart after the daylight saving clock change.

Check out this fix:

https://confluence.atlassian.com/confkb/confluence-will-not-start-after-dst-daylight-saving-time-with-mysql-database-and-gives-hour_of_day-1-2-error-1052641715.html

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,474 views 7 29
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you