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 > <dieter....@gmail.com<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 h2-database@googlegroups.com. >>>> 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 h2-database...@googlegroups.com <javascript:>. >> To post to this group, send email to h2-da...@googlegroups.com<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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
