Hi, Hm, I couldn't reproduce the problem so far. What I did was run you test with the H2 trunk. At first, I got an exception because Geometry serialization for the MVTableEngine wasn't implemented yet, I guess you used a patched version of H2. But then I have implemented that missing piece (it is committed in the trunk), and now the test works with the following output:
0 store.getUnsavedPageCount()==616 1 store.getUnsavedPageCount()==5 2 store.getUnsavedPageCount()==5 ... 34 store.getUnsavedPageCount()==5 35 store.getUnsavedPageCount()==5 36 store.getUnsavedPageCount()==3 37 store.getUnsavedPageCount()==3 38 store.getUnsavedPageCount()==2 39 store.getUnsavedPageCount()==22 40 store.getUnsavedPageCount()==2 41 store.getUnsavedPageCount()==2 42 store.getUnsavedPageCount()==2 43 store.getUnsavedPageCount()==2 44 store.getUnsavedPageCount()==3 45 store.getUnsavedPageCount()==4 Regards, Thomas On Monday, July 15, 2013, Nicolas Fortin (OrbisGIS) wrote: > Hi Thomas, > > About the MVStore corruption,I finally found a test case that raise a > traceback in the org.h2.store.WriterThread, about 45s after the last sql > request.. > > You can clone the following repo: > https://github.com/nicolas-f/h2database/tree/patch-merge > > The test case is here: > > https://github.com/nicolas-f/h2database/blob/ec0c6f745f6f34e291cc6b7e00528a1d81a7afc1/h2/src/test/org/h2/test/db/TestSpatial.java#L380 > > Thanks for support. > > Best regards, > > -Nicolas Fortin > GIS Workshop > IRSTV FR CNRS 2488 > > Le jeudi 11 juillet 2013 11:20:09 UTC+2, Thomas Mueller a écrit : >> >> Hi, >> >> About "envelope query", you wrote "With index and Envelope union it take >> more than 100s." - do you mean the following line in IndexCursor. >> getSpatialSearchRo**w is called: "v = ((ValueGeometry) v).union(vg);"? >> If yes, how is it possible, because the method is only ever called with the >> parameter "isIntersects" set to true. The method is only called within >> IndexCursor.find, where isIntersect is set to true. >> >> About "Corrupt page count": I don't think it's because you directly use >> a map. More likely is a bug within the MVStore, for example related to >> concurrency. I do know that currently, the MVTableEngine doesn't always >> work correctly when using multiple threads, so maybe there is a concurrency >> problem in the MVStore that needs to be fixed. If not, then more likely is >> another problem in the MVStore. I could have a look if I have a test case. >> >> Regards, >> Thomas >> > -- > 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:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
