ok, thanks for the clarification on the output from the recovery tool. I tried the latest version but there appears to be little difference. our db is small in comparison to what i've seen listed here, but i know i'm missing a large percentage of my data. A comparable db instance contains ~5k records in one of the larger tables and only seeing maybe 50 in the recovery output. If you wouldn't mind taking a crack at it, i'd like to send it to you.
thank you On Tuesday, August 21, 2012 2:26:17 PM UTC-4, Thomas Mueller wrote: > > 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/_X9q-LYXXJ8J. 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.
