[postgis-users] Rare circumstances crash pg

[Simpson]

Greetings,

Using POSTGIS="1.0.0" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004"
DBPROC="0.3.0" RELPROC="0.3.0"

On rare occasions the server crashes with combinations of spatial functions
in the select and where.

-- THIS WORKS
select multi(Buffer(the_geom, 0)) from polygon where polyid = 6088;

-- THIS CRASHES
select multi(Buffer(the_geom, 0)) from polygon where not isvalid(the_geom)
and polyid = 6088;

I was going to package up a re-creatable scenario to include in this email,
so I copied this row to a new table that I was going to dump and include,
but upon creation of the new table, I could not get it to crash with above
query.  If I copy all the rows to the new table it crashes.  Something to do
with indexing?

Below is the data from the_geom column if that helps.

Thanks for any suggestions,
Drew.



select AsEWKT(the_geom) from polygon where polyid = 6088;

asewkt
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----------------------------------------------------------------------
 SRID=4269;MULTIPOLYGON(((-80.402277 33.445738,-80.402687
33.445463,-80.402551 33.444936,-80.402414 33.444638,-80.402114
33.444318,-80.401895 33.444226,-80.401403 33.444203,-80.401321
33.444272,-80.400447 33.443057,-80.400447 33.442986,-80.400034
33.442461,-80.39988 33.442265,-80.40001 33.442163,-80.400065
33.441705,-80.400694 33.441087,-80.400694 33.44072,-80.40053
33.440537,-80.40053 33.440308,-80.400722 33.440056,-80.401214
33.439873,-80.401296 33.439758,-80.401296 33.439254,-80.401023
33.438796,-80.401132 33.437971,-80.401406 33.437857,-80.40157
33.437674,-80.401952 33.43749,-80.402226 33.437078,-80.402254
33.436162,-80.402363 33.436001,-80.402773 33.435772,-80.405096
33.435223,-80.405506 33.434971,-80.406899 33.434651,-80.407664
33.434307,-80.408293 33.433826,-80.40873 33.43362,-80.409359
33.433529,-80.410042 33.43385,-80.410233 33.434056,-80.410096
33.434331,-80.410123 33.43456,-80.410287 33.43472,-80.41097
33.434858,-80.411872 33.435454,-80.412145 33.435798,-80.412281
33.435866,-80.41242 33.436443,-80.412524 33.436661,-80.412705
33.436984,-80.412752 33.437145,-80.412892 33.438283,-80.412949
33.43842,-80.413019 33.438521,-80.412628 33.439014,-80.411404
33.438618,-80.408885 33.441616,-80.407139 33.443694,-80.404327
33.447043,-80.402468 33.446242,-80.402277 33.445738),(-80.405358
33.440444,-80.405158 33.440426,-80.405285 33.440615,-80.405358
33.440444),(-80.408047 33.43911,-80.406924 33.438408,-80.406658
33.438408,-80.405802 33.439605,-80.405685 33.439556,-80.405623
33.439725,-80.405718 33.439662,-80.405802 33.439605,-80.406994
33.440103,-80.408047 33.43911)))
(1 row)