I have not tested the scenario with MVCC off because that is pretty much a non-starter for our performance requirements.
It is kind of an odd bug because the application, the embedded h2 web console, and the h2 shell do not have a problem with the database file. Only other database viewers seem to have the problem - of which I certainly do not have an exhaustive list. When I started looking into the bug I did not realize that I'd be able to access the database file via the H2 shell, so it was initially a higher priority bug. As I mentioned, the most important thing for me that has come out of this is learning about MVCC support/stability for PageStore. Noel mentioned it is not a priority for them, which I totally agree with, and I would not want anyone to spend more of their time trying to research this because the solution for me is to switch to MVStore and to use the H2 shell instead of some of db viewer. On Wednesday, February 17, 2016 at 7:08:20 AM UTC-6, Kartweel wrote: > > I've been using MVCC with PageStore for years. LOBS don't work very well > (but I didn't want them in the db anyway, so we don't use LOBS). Haven't > had any issues with anything else though. > > Doesn't mean bugs don't exist though. > > You only get the issue with MVCC on though hey? > > On 17/02/2016 1:18 PM, Noel Grandin wrote: > > At some point in the future is all I can say, not anytime soon. My > > point was more that MVCC on PageStore is a dead end for us, so we're > > not going to expend any effort debugging problems with it. > > > > So if you want reliability, use PageStore without MVCC. > > > > > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
