Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

h2db corrupted, anything i can do ?

Kai Fröhlich
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 12, 2017

Hi community,

we're using JIRA with h2 database. (yes. i know.. not a good idea)

cause of insufficient memory the Databasefile corrupted.

2017-05-04 08:55:04,387 http-nio-8085-exec-6 ERROR      [NoModule] Could not determine database type.

org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db". Possible solution: use the recovery tool [90030-185]

 

org.h2.message.DbException: General error: "java.lang.IllegalStateException: Chunk 1528696 is invalid [1.4.185/6]" [50000-185]

 

we've allready tried to fix the problem with the recoveryTool,
but also had no luck.

org.h2.tools.Recover Exception in thread "main" java.lang.IllegalStateException: Chunk 1528696 is invalid [1.4.185/6]

 

there is no Backup available.

Just in case i miss something... but is there any way to restore the data?

i guess not.

 

Thanks

Kai

1 answer

1 accepted

2 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 12, 2017

I'm afraid that is probably not fixable.

Are you sure you have no backups?  Have a look under <jira home>/export

Kai Fröhlich
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 14, 2017 edited

Thank you!
i wasn't aware that
Jira exports its Data on its own into /export .


i've got therefore an Backup.

 

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events