Is the restored H2 base real?

Question

Java

Jira is littered with File Corrupted Expeditions

Caesium-1-3 ERROR      [c.a.s.caesium.impl.SchedulerQueueWorker] Unhandled exception thrown by job QueuedJob[jobId=com.atlassian.jira.service.JiraService:10500,deadline=1638901140000]
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE PUBLIC.clusteredjob SET  VERSION = ? ,  NEXT_RUN = ?  WHERE JOB_ID=? AND VERSION=? (General error: "java.lang.IllegalStateException: File corrupted in chunk 46477485, expected page length =< 96, got 94887043 [1.4.185/6]" [50000-185])

I tried the restore way:

java -cp /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/h2-1.4.185.jar org.h2.tools.Recover h2db.mv.db

But didn't help

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Feature not supported: "h2db.mv.db" [50100-185]

I found a way that could help
https://stackoverflow.com/questions/27360272/h2-ge...
https://github.com/nyg/h2-recover

My knowledge is not enough on how to apply this, I'm not a programmer.

Answer 1

Launched the jira with the no addons flag, made an xml backup. And then he deleted the old database and the old settings, reconfigured it and uploaded it from the backup.