Dear, after a shutdown/restart of our webserver, the content can not be fetched from our embedded H2 database. It is running H2 1.0.68. I know this version is old and that we should have migrated much sooner to newer versions; but everything worked fine until the issue I'm describing below.
The returned error is "General error: java.lang.Error: File ID mismatch got=1845493760 expected=31 pos=281601 true org.h2.store.DiskFile:/Users/jofallon81/db_27_07/test.data.db blockCount:6666" This is important prod data. We tried the following to recover : 1. append ";RECOVER=1" at the end of the url when connecting. The returned error is then General error: java.lang.Error: double allocation in file /Users/ jofallon81/db_27_07/test.data.db page 4400 blocks 281600-281663 [50000-68] HY000/50000 2. use the "org.h2.tools.Recover" tool. The output was the following : Created file: /Users/jofallon81/db_27_07/test.171.log.txt Created file: /Users/jofallon81/db_27_07/test.data.sql Error: java.lang.Error: read len -128 Please advise on how to recover our data. We are ready to pay for this service. I know we should have migrated much sooner to newer versions; but are there some migration tools to help doing that ? I can not open my DB with the latest H2, it says it is not the same database version. Any help would be appreciated, Many thanks, Jonathan. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
