[postgis-tickets] [PostGIS] #2975: ST_Intersects with a LineString and MultiPolygon crashes PostgreSQL

[PostGIS]

#2975: ST_Intersects with a LineString and MultiPolygon crashes PostgreSQL
----------------------------------------+-----------------------------------
 Reporter:  royseto                     |       Owner:  pramsey      
     Type:  defect                      |      Status:  new          
 Priority:  high                        |   Milestone:  PostGIS 2.1.5
Component:  postgis                     |     Version:  2.1.x        
 Keywords:  st_intersects crash memory  |  
----------------------------------------+-----------------------------------
 ST_Intersects with a LineString that has 52229 points and a MultiPolygon
 that has 509 points exhausts all the memory on our PostgreSQL server until
 the database crashes. On our server with 72GB of memory, this happens in
 20-60 minutes.

 I am attaching a test case with the LineString and MultiPolygon encoded as
 HEX WKB text files. It includes a SQL version of the test case as well as
 a standalone test case that calls GEOSIntersects() from the GEOS C API.

 PostgreSQL version:
 PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc
 (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

 PostGIS full version:
 POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8"
 LIBJSON="UNKNO
 WN" RASTER

 OS: Ubuntu 12.04

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2975>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.