Hi, Version 1.3.155 is quite old, there were some problems related to corruption fixed in newer version (see the change log for details).
> Running the Recovery tool, ... only seems to reclaim < 5% of the data That's strange. > -- page 20: data node parent: 0 table: 18 entries: 295 rowCount: 5058 > -- ERROR [20] child[0]: 63 parent: 0 > -- ERROR [20] child[1]: 64 parent: 0 > ... > ... > -- ERROR [20] child[291]: 1335 parent: 0 > -- ERROR [20] child[292]: 1340 parent: 0 > -- page 21: data overflow (last) Those messages are usually not a problem, as they refer to b-tree nodes and not leaves. All the data is in the leaves (H2 uses b+trees internally). > -- page 1294: data node parent: 17 table: 20 entries: 203 rowCount: -1 The rowCount: -1 isn't a problem (the row count is set to -1 on an update, this is normal). The counts are not updated (I tried to implement counted b-trees but it is incomplete). > I could use some expert assistance in determine if there's any hope of recovering the rest of the data. The Recover tool should be able to retrieve all data. Possibly you need to use a more recent version of the Recover tool, did you try using the newest version? The file format didn't change. > I appreciate any help in trying to recover the data. If you want, you can send the .h2.db file to me and I can try. Regards, Thomas -- 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.
