[postgis-tickets] [PostGIS] #2366: Cancelling query with ST_Union crashes PostgreSQL server

PostGIS trac at osgeo.org
Thu Jun 20 06:54:35 PDT 2013


#2366: Cancelling query with ST_Union crashes PostgreSQL server
---------------------+------------------------------------------------------
 Reporter:  dbaston  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 When I cancel a query with ST_Union after realizing that it will take a
 long time, my Windows PostgreSQL server crashes.

 "POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March
 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" TOPOLOGY RASTER"

 "PostgreSQL 9.2.1, compiled by Visual C++ build 1600, 64-bit"

 An example query is something like
 SELECT city, ST_Union(geom) FROM cities GROUP BY city

 Geometries in the table are multipolygons.

 Please let me know if there is more useful information that I can provide.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2366>
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.


More information about the postgis-tickets mailing list