[postgis-users] terminated server connection during st_isvalid()

[Nicolas Ribot]

Hi,

Same crash here:
POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.7.3" USE_STATS
PostgreSQL 9.0.1 on x86_64-apple-darwin10.4.0, compiled by GCC
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664),
64-bit

JTS also fails to validate it (in OpenJump)

The buffer(0.0) trick seems to correct the polygon, transforming it to
a Multi PG:
select st_buffer(polygon, 0.0);

It is then valid.

Nicolas

On 7 June 2011 14:19, Birgit Laggner <birgit.laggner at vti.bund.de> wrote:
> Dear list,
>
> I have a polygon (see end of e-mail) which always causes the termination of
> my server connection when I am trying to test it with st_isvalid().
>
> Maybe, anybody has an explanation or a workaround???
>
> PostGIS:
> POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009"
> LIBXML="2.7.3" USE_STATS (procs from 1.5 r5385 need upgrade)
>
> PostgreSQL:
> PostgreSQL 8.4.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (SUSE
> Linux) 4.4.1 [gcc-4_4-branch revision 150839], 64-bit
>
> (translated :-) ) part of the pg_log error messages, related to this:
>
> SELECT: IndexedNestedRingTester.cpp:71: bool
> geos::operation::valid::IndexedNestedRingTester::isNonNested(): assertion
> »innerRingPt!=__null« not erfüllt.
> 2011-06-07 13:21:14 CEST   LOG:  Server process (PID 13483) was terminated
> by signal 6: Aborted
> 2011-06-07 13:21:14 CEST   LOG:  terminating any other active server
> processes
> 2011-06-07 13:21:14 CEST gis laggner_b WARNING:  terminating connection
> because of crash of another server process
> 2011-06-07 13:21:14 CEST gis laggner_b DETAIL:  The postmaster has commanded
> this server process to roll back the current transaction and exit, because
> another server process exited abnormally and possibly corrupted shared
> memory.
> 2011-06-07 13:21:14 CEST gis laggner_b HINT:  In a moment you should be able
> to reconnect to the database and repeat your command.
>
> I really would appreciate any help.
>