Hi Andrei, thank you for the answer. The problem occurs that I report above occurs on H2 1.4.197/9. H2 1.4.197 is already the latest version of H2 that can be downloaded from the website.
I will try these days to check out the latest source code and build and then test again. Do you know which commit on GitHub fixes the issue? Currently, we have a workaround for the problem. We just disabled the new MVStore storage by setting MV_STORE to FALSE. However, I have another question. After upgrading to H2 1.4 (previously we used H2 1.2) I observed a performance drop by executing a huge number of select statements. After setting MV_STORE to FALSE the performance issues disappeared. Is this MVStore performance problem well-known and if so, do you know if the optimisation of MVStore is in the TODO list for the next release? Thanks and greetings, Ivaylo. Am Dienstag, 21. August 2018 12:08:30 UTC+2 schrieb Andrei Tokar: > > Hi Ivaylo, > > Circumstances under which this bug will appear may vary greatly (because > it is a fairly low-level problem), but I believe it is fixed after last > release. If you can build H2 from the latest code, I would be very > interested in your feedback about whether or not you problem is resolved, > and if you still have a reproducible test case, I'll gladly take it from > there. > > Thanks, > Andrei > >> >> -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
