Hi,
Nice, thank you for this fix.
-Nicolas
Atelier SIG, FR CNRS 2488
Le vendredi 24 janvier 2014 16:01:11 UTC+1, Thomas Mueller a écrit :
>
> Hi,
>
> This is now fixed in the trunk. It was a bug in the R-Tree implementation:
> when overwriting existing entries in the index, a page would be freed up
> multiple times. It does not affect in-memory indexes.
>
> Regards,
> Thomas
>
>
>
> On Thu, Jan 23, 2014 at 9:24 PM, Thomas Mueller
> <thomas.to...@gmail.com<javascript:>
> > wrote:
>
>> Hi,
>>
>> Yes, I can reproduce it. I assume it's a bug in the R-Tree
>> implementation. I have shortened the test case to:
>>
>> drop all objects;
>> create table coords as select rand()*50 x, rand()*50 y from
>> system_range(1, 5000);
>> create table geoms(id identity, the_geom geometry);
>> create spatial index on geoms(the_geom);
>> insert into geoms(the_geom) select 'polygon(('||(1+x)||' '||(1+y)||', '||
>> (2+x)||' '||(2+y)||', '||(3+x)||' '||(1+y)||', '||(1+x)||' '||(1+y)||'))'
>> from coords;
>>
>> Regards,
>> Thomas
>>
>>
>> On Thu, Jan 23, 2014 at 10:56 AM, Nicolas Fortin (OrbisGIS) <
>> nico....@gmail.com <javascript:>> wrote:
>>
>>> Hi,
>>>
>>> Using H2 Version 1.3.175 (2014-01-18) with options
>>> ;MV_STORE=TRUE;MVCC=TRUE. There is a problem with spatial index when I is
>>> used in combination with mvstore. To following sql requests lead to an
>>> exception:
>>>
>>> create table coords as select (RAND() * 50 ) X, (RAND() * 50 ) Y from
>>> system_range(1, 20000);
>>>
>>> create table geoms (id integer primary key auto_increment, the_geom
>>> geometry);
>>> create spatial index on geoms(the_geom);
>>> insert into GEOMS(the_geom) select ('POLYGON((' || (1 + X)::varchar || '
>>> ' || (1 + Y )::varchar || ', ' || (2 + X )::varchar || ' ' || (2 + Y
>>> )::varchar || ', ' || (3 + X )::varchar || ' ' || (1 + Y )::varchar || ',
>>> ' || (1 + X)::varchar || ' ' || (1 + Y )::varchar || '))')::geometry
>>> the_geom from COORDS;
>>>
>>>
>>> insert into GEOMS(the_geom) select ('POLYGON((' || (1 + X)::varchar || '
>>> ' || (1 + Y )::varchar || ', ' || (2 + X )::varchar || ' ' || (2 + Y
>>> )::varchar || ', ' || (3 + X )::varchar || ' ' || (1 + Y )::varchar || ',
>>> ' || (1 + X)::varchar || ' ' || (1 + Y )::varchar || '))')::geometry
>>> the_geom from COORDS;
>>>
>>>
>>>
>>> The exception:
>>>
>>>
>>>>
>>>>
>>>> insert into GEOMS(the_geom) select ('POLYGON((' || (1 + X)::varchar ||
>>>> ' ' || (1 + Y )::varchar || ', ' || (2 + X )::varchar || ' ' || (2 + Y
>>>> )::varchar || ', ' || (3 + X )::varchar || ' ' || (1 + Y )::varchar || ',
>>>> ' || (1 + X)::varchar || ' ' || (1 + Y )::varchar || '))')::geometry
>>>> the_geom from COORDS;
>>>> General error: "java.lang.IllegalStateException: Corrupt page count
>>>> -635 [1.3.175/3]"
>>>> [50000-175]<https://localhost:8082/query.do?jsessionid=2084f6859c202b6be4b35e8d86f708da#>HY000/50000
>>>>
>>>> (Aide)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c50000>
>>>> org.h2.jdbc.JdbcSQLException: General error:
>>>> "java.lang.IllegalStateException: Corrupt page count -635 [1.3.175/3]"
>>>> [50000-175]
>>>> at
>>>> org.h2.message.DbException.getJdbcSQLException(DbException.java:332<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=332&build=175>
>>>> )
>>>> at
>>>> org.h2.message.DbException.get(DbException.java:161<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=161&build=175>
>>>> )
>>>> at
>>>> org.h2.message.DbException.convert(DbException.java:284<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=284&build=175>
>>>> )
>>>> at
>>>> org.h2.message.DbException.toSQLException(DbException.java:257<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=257&build=175>
>>>> )
>>>> at
>>>> org.h2.message.TraceObject.logAndConvert(TraceObject.java:368<http://h2database.com/html/source.html?file=org/h2/message/TraceObject.java&line=368&build=175>
>>>> )
>>>> at
>>>> org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=158&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebApp.getResult(WebApp.java:1321<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1321&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebApp.query(WebApp.java:1010<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1010&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebApp$1.next(WebApp.java:972<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=972&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebApp$1.next(WebApp.java:959<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=959&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebThread.process(WebThread.java:167<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=167&build=175>
>>>> )
>>>> at
>>>> org.h2.server.web.WebThread.run(WebThread.java:94<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=94&build=175>
>>>> )
>>>> at java.lang.Thread.run(Thread.java:744)
>>>> Caused by: java.lang.IllegalStateException: Corrupt page count -635
>>>> [1.3.175/3]
>>>> at
>>>> org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:716<http://h2database.com/html/source.html?file=org/h2/mvstore/DataUtils.java&line=716&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVStore.applyFreedSpace(MVStore.java:1060<http://h2database.com/html/source.html?file=org/h2/mvstore/MVStore.java&line=1060&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVStore.storeNow(MVStore.java:893<http://h2database.com/html/source.html?file=org/h2/mvstore/MVStore.java&line=893&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVStore.commitAndSave(MVStore.java:831<http://h2database.com/html/source.html?file=org/h2/mvstore/MVStore.java&line=831&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVStore.beforeWrite(MVStore.java:1669<http://h2database.com/html/source.html?file=org/h2/mvstore/MVStore.java&line=1669&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVMap.beforeWrite(MVMap.java:902<http://h2database.com/html/source.html?file=org/h2/mvstore/MVMap.java&line=902&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.MVMap.put(MVMap.java:107<http://h2database.com/html/source.html?file=org/h2/mvstore/MVMap.java&line=107&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.db.TransactionStore.commit(TransactionStore.java:327<http://h2database.com/html/source.html?file=org/h2/mvstore/db/TransactionStore.java&line=327&build=175>
>>>> )
>>>> at
>>>> org.h2.mvstore.db.TransactionStore$Transaction.commit(TransactionStore.java:746<http://h2database.com/html/source.html?file=org/h2/mvstore/db/TransactionStore.java&line=746&build=175>
>>>> )
>>>> at
>>>> org.h2.engine.Session.commit(Session.java:482<http://h2database.com/html/source.html?file=org/h2/engine/Session.java&line=482&build=175>
>>>> )
>>>> at
>>>> org.h2.command.Command.stop(Command.java:151<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=151&build=175>
>>>> )
>>>> at
>>>> org.h2.command.Command.executeUpdate(Command.java:283<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=283&build=175>
>>>> )
>>>> at
>>>> org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=181&build=175>
>>>> )
>>>> at
>>>> org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=156&build=175>
>>>> )
>>>> ... 7 more
>>>
>>>
>>>
>>> Thanks for support
>>>
>>> Nicolas Fortin
>>> -Atelier SIG, FR CNRS 2488
>>>
>>> --
>>> 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...@googlegroups.com <javascript:>.
>>> To post to this group, send email to h2-da...@googlegroups.com<javascript:>
>>> .
>>> 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 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.
For more options, visit https://groups.google.com/groups/opt_out.
