JIRA Startup Failed - JiraLockedError

Question

Hi,

We are getting this error

Error occurred while starting component 'com.atlassian.jira.web.action.issue.DefaultTemporaryWebAttachmentsMonitor'. caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM PUBLIC.clusteredjob WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: File corrupted in chunk 5116816, expected page length =< 768, got 976302904 [1.4.185/6]"; SQL statement: DELETE FROM PUBLIC.clusteredjob WHERE JOB_ID=? [50000-185]))

Please help

Daniel Eads · Answer

Hi Athakkar,

Take a look in the export folder of Jira's home directory. Hopefully there are automated backups here you can restore from - by default for all Jira 7 releases, Jira tries to take automated backups every 12 hours.

If you are able to pull an XML file from this folder to restore to, we recommend you switch to a dedicated database as soon as possible. The embedded H2 database is for evaluation purposes and not recommended for production environments. Check out our documentation for more information on using a dedicated database.

Cheers,
Daniel

athakkar · Answer

Hi Marko,

Yes we are using embedded H2 database. What options do I have now? Can this be restored?

Marko Filipan · Answer

Hi Athakkar,

Can you please tell if you are using embedded H2 database? If so, according to the code, it seems the database file is corrupted. H2 database is very prone to data corruption, especially if the system was shut down unexpectedly.

Cheers,
Marko