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 <eoi...@gmail.com<javascript:> > > 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 >> <thomas.to...@gmail.com<javascript:> >> > 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 h2-da...@googlegroups.com<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> h2-database...@googlegroups.com <javascript:>. >>> For more options, visit this group at >>> 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 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?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.
