Hi Thomas,
Just for additional information, I have this also in trace.db file:
07-12 09:10:38 database: flush
> java.lang.IllegalStateException: Corrupt page count -2 [1.3.172]
> at
> org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:632)
> at org.h2.mvstore.MVStore.applyFreedPages(MVStore.java:1004)
> at org.h2.mvstore.MVStore.store(MVStore.java:871)
> at org.h2.mvstore.MVStore.beforeWrite(MVStore.java:1489)
> at org.h2.mvstore.MVMap.beforeWrite(MVMap.java:929)
> at org.h2.mvstore.rtree.MVRTreeMap.putOrAdd(MVRTreeMap.java:220)
> at org.h2.mvstore.rtree.MVRTreeMap.put(MVRTreeMap.java:205)
> at org.h2.mvstore.rtree.MVRTreeMap.put(MVRTreeMap.java:25)
> at org.h2.mvstore.MVStore.copyLive(MVStore.java:1235)
> at org.h2.mvstore.MVStore.compact(MVStore.java:1194)
> at
> org.h2.mvstore.db.MVTableEngine$Store.store(MVTableEngine.java:132)
> at org.h2.engine.Database.flush(Database.java:1818)
> at org.h2.store.WriterThread.run(WriterThread.java:87)
> at java.lang.Thread.run(Thread.java:662)
>
I currently fail to reproduce it in unit test. This corruption lead to an
incomplete MVRTreeMap.
Regards,
-Nicolas Fortin
GIS Workshop
IRSTV FR CNRS 2488
Le mardi 21 mai 2013 10:07:39 UTC+2, Nicolas Fortin (OrbisGIS) a écrit :
>
> Discussion about user defined index on OTHER type.
>
> In spatial SQL the following request on an indexed geometry column would
> use spatial index:
>
> select * from spatialTable where ST_Intersects(the_geom,
>> ST_PolyFromText('POLYGON ((67 13, 67 18, 59 18, 59 13, 67 13))',1));
>>
>
> Usage of ST_Intersects filter the_geom field by using BoundingBox stored
> index of the spatialTable, then the method is applied on filtered rows.
>
> Can I do this by creating my own TableEngine ? There is an easier way
> without modifying the sql request ? Maybe a way to let special kind of
> function to alter the execution plan ?
>
> Thanks for your support.
>
>
--
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.
