[postgis-tickets] [PostGIS] #3516: ST_Voronoi garden crasher

[PostGIS]

#3516: ST_Voronoi garden crasher
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 I haven't been able to dissect this into something simpler that still
 crashes:


 {{{
 SELECT ST_Voronoi(foo1.the_geom, foo2.the_geom, 20.1, false) As result,
 ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As
 ref2_geom FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As the_geom FROM
 (SELECT a*1.11111111 FROM generate_series(-10,50,2) As a) As i(i) CROSS
 JOIN generate_series(40,70, 5) j ORDER BY i,j )) As foo1 CROSS JOIN
 ((SELECT ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom
 FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i)
 CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As foo2
 LIMIT 2;

 }}}

 This is running with

 {{{
  POSTGIS="2.3.0dev r14758" GEOS="3.5.0-CAPI-1.9.0 r4090" SFCGAL="1.3.0"
 PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15"
 LIBXML="2.7.8" LIBJSON="0.12" RASTER PostgreSQL 9.5.1, compiled by Visual
 C++ build 1800, 64-bit
 }}}

 It crashes so badly that the backend doesn't recover and I have to
 manually restart.

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