Opened 3 years ago

Closed 3 years ago

#3516 closed defect (fixed)

ST_Voronoi garden crasher

Reported by: robe Owned by: dbaston
Priority: blocker Milestone: PostGIS 2.3.0
Component: postgis Version: trunk
Keywords: Cc:

Description

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.

Change History (3)

comment:1 Changed 3 years ago by robe

Owner: changed from pramsey to dbaston

comment:2 Changed 3 years ago by dbaston

Should be fixed at r14810

comment:3 Changed 3 years ago by dbaston

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.