unable to start up confluence

[ZHENG TANG]

Description

Unable to start up Confluence. Fatal error during startup sequence.lifecycle.core:mananagedjobs(Start and stop the Managed Scheduled Jobs)-org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only

database: h2

confluence version: 5.10.9

we tried to recover the h2 database but it doesn't work out.

[Pramodh M · Accepted solution]

Hi @ZHENG TANG 

Based on this KB, would you please look at the cause for Atlassian Confluence log for troubleshooting

https://confluence.atlassian.com/confkb/org-springframework-transaction-unexpectedrollbackexception-when-viewing-or-creating-a-page-182157705.html

You could attach the logs here

Thanks,
Pramodh

[ZHENG TANG]

Hi @Pramodh M , thank you for your reply.

We checked the error log and found that there was a heap overflow error while performing the Confluence backup job, which caused the above problem. But we found a more serious problem, some data files in the h2 database were corrupted due to this. We used the h2 database recover tool but still cannot recover the corrupted data.

We wonder is there any way to roll back the Confluence backup job to recover the h2 database?