Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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!

1 answer

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.

Suggest an answer

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

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

106 views 2 9
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