Hi, Thomas - We are confronting a similar (possibly entirely different) issue described in https://groups.google.com/d/msg/h2-database/awQR6dY5ZPY/74wcsGAWsCcJ We have a workaround now and I have hopes that MVStore will completely eliminate these two problems.
I'm not familiar with H2 internals at all but would love to provide a test case. So far, our attempts to replicate the problem in a test case that we can send you haven't been successful. Obviously, there is some key aspect of the problem that our test case isn't incorporating. Can you provide some guidance as to related conditions, we might be able to come up with an appropriate test case. The conditions I'm thinking of are pretty broad like LOBs, high insert rates, using batch inserts, concurrent deletes, indexes (do multicolumn indexes matter?), etc. On Friday, June 7, 2013 8:31:01 AM UTC-7, Thomas Mueller wrote: > > Hi, > > > Has there been any update on the missing lob problem in the interim? > > I don't think so, sorry. But you should test with the latest version; > 1.3.167 is relatively old already. > > Also, (as written earlier already) a simple, reproducible test case would > be great... ;-) > > Regards, > Thomas > > > On Fri, May 31, 2013 at 5:45 PM, Karlos TheJackal > <[email protected]<javascript:> > > wrote: > >> I am working on the same code that Eoin previously worked on. The fix for >> breaking up the select query is still in the code, but recently we have >> started getting the error again. The "DB closed" errors persist until the >> process is restarted unfortunately. >> >> Has there been any update on the missing lob problem in the interim? >> >> Thanks. >> >> >> On Friday, June 15, 2012 8:54:51 AM UTC+1, Eoin Byrne wrote: >> >>> We tested a change last night which broke up the select * on the lob >>> table to select in batches of 1000 entries and it seems to have fixed the >>> "Missing LOB" error. There were no "DB closed" errors either. Because the >>> problem seems intermittent that's no guarantee that the issue has been >>> fixed but it looks good so far. >>> >>> It looks like we will have to turn MVCC back on because we are now >>> hitting a large number of table lock timeouts but thats going to >>> reintroduce the DB file growth issue. I know this feature is experimental >>> but I guess my question is how experimental is it? and assuming the growth >>> is down to long lived connections - is there any way to find out what >>> selects / updates are still pending commits from the DB logs? >>> >>> On Thu, Jun 14, 2012 at 6:24 PM, Eoin Byrne <[email protected]> wrote: >>> >>>> heh - tell me about it, having to wait 8 hours to see if a fix works >>>> can make things difficult :) >>>> >>>> >>>> On Thu, Jun 14, 2012 at 6:23 PM, Thomas Mueller <[email protected] >>>> > wrote: >>>> >>>>> Hi, >>>>> >>>>> Is there any other info you need? >>>>>> >>>>> >>>>> Hm, a simple, reproducible test case would be great... ;-) >>>>> >>>>> 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 h2-database...@** >>>>> googlegroups.com. >>>>> >>>>> For more options, visit this group at http://groups.google.com/** >>>>> group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >>>>> . >>>>> >>>> >>>> >>> -- >> 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?hl=en-US. >> >> 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?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.
