[postgis-users] Signal 11

[Nicklas Avén]

Hallo Martin

I get this error, but no crash.

NOTICE:  TopologyException: found non-noded intersection between
LINESTRING (-73.6737 41.0346, -73.6731 41.0339) and LINESTRING (-73.6734
41.0342, -73.6733 41.0341) at -73.6734 41.0342


ERROR:  GEOS difference() threw an error!

********** Error **********

ERROR: GEOS difference() threw an error!
SQL state: XX000




Select postgis_full_version() :
"POSTGIS="1.5.2" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.7.7" USE_STATS"

and postgresql 9.0.1


Regards
Nicklas


On Mon, 2010-12-20 at 21:56 +0000, Martin Spott wrote:
> Hi folks,
> I'm having a case where a certain statement reproducibly crashes the
> server process. The system is running Solaris10 on Intel Xeons, all
> specific software is compiled into 64-bit binaries using GCC-3.4.3:
> 
>  - PROJ.4 4.7.0
>  - GEOS 3.2.2
>  - libiconv 1.13.1
>  - PostgreSQL 9.0.1
>  - PostGIS 1.5.2
> 
> I have created a (rather largish) SQL script, containing just one
> single "ST_Difference" statement plus two POLYGON's, which reproducibly
> segfaults the server:
> 
>   http://mapserver.flightgear.org/CrashTheDB_2.sql.gz
> 
> Would anyone do me the honour of checking wether it works correctly on
> their system ?
> 
> Thanks,
> 	Martin.