I'm sure the corruption was not there using 1.3.161 because its just an empty scheme I created once back then (i can send it if it helps).
Whatever happens in that file later on, happens by a more recent h2.jar (1.3.168 in this report). I completely understand there's nothing you can do without a .db file or reproducible test. Op dinsdag 1 oktober 2013 19:36:04 UTC+2 schreef Thomas Mueller: > > Hi, > > Well, the problem is, if the database was created with an old version, > then the corruption might have been there already when you switched to a > new version. Corruption problems are very hard to analyze, because there is > no log file that tells us which change in the database file was created by > which version of H2... > > Of course, if the problem is reproducible, yes, that's another case. > Reproducible problems are usually quite easy to analyze and fix. > > Regards, > Thomas > > > > On Tue, Oct 1, 2013 at 4:12 PM, Dieter Cailliau > <[email protected]<javascript:> > > wrote: > >> I assume that that fact (that the h2 version with which i created the >> schema = 1.3.161) is not relevant for the problem experienced in 1.3.168 >> which is still a problem in 1.3.168? >> It is true that i have created a schema once using an older h2, and kept >> that db file as a file to start of in my app, even though i've been >> upgrading h2.jar along in my app. >> If this is a problem (using this db file against an uptodate h2.jar), >> please tell me. >> >> Op woensdag 21 augustus 2013 07:43:45 UTC+2 schreef Thomas Mueller: >> >>> Hi, >>> >>> The empty database was created with version 1.3.161, as the >>> "CREATE_BUILD" is 161. Since then, a few bugs have been fixed that could >>> cause corruption; see the change log for details. I suggest to try again >>> with a more recent version of H2. If it is still a problem, it would be >>> great if you could provide a simple, reproducible test case. >>> >>> Regards, >>> Thomas >>> >>> >>> On Tuesday, August 13, 2013, Dieter Cailliau wrote: >>> >>>> jdbc:h2:/tmp/x;DB_CLOSE_DELAY=**-1;LOCK_TIMEOUT=5000 >>>> It's a small db (3M on a windows7) with small tables (about 100 rows). >>>> I'm using multiple threads. >>>> I attached the empty schema. If it helps i can send you a (non-corrupt) >>>> populated one. I'm still trying to reproduce the corruption. >>>> While reading the list, i learned that h2 performs a corruption >>>> correction at open-time: i think that does not help, because the opening >>>> succeeds, but later that query fails. >>>> >>>> Thanks! >>>> >>>> Op dinsdag 13 augustus 2013 10:18:19 UTC+2 schreef Noel Grandin: >>>>> >>>>> >>>>> On 2013-08-13 10:05, Dieter Cailliau wrote: >>>>> > >>>>> > Here's another example of ArrayIndexOutOfBoundsException at >>>>> > org.h2.index.PageDataLeaf.**getR**owAt: this happened on 1.3.168. >>>>> The most >>>>> > recent fix i found in changelog about this kind of error was >>>>> 1.3.166, >>>>> > so probably there's still something wrong since then, or have there >>>>> > been fixes related to this, since 1.3.168? >>>>> >>>>> What does your database URL look like? >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "H2 Database" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to h2-database+unsubscribe@**googlegroups.com. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at >>>> http://groups.google.com/**group/h2-database<http://groups.google.com/group/h2-database> >>>> . >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>>> >>>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
