Opened 6 years ago

Last modified 5 years ago

#4282 closed defect

ST_LineToCurve hangs indefintely — at Version 1

Reported by: robe Owned by: pramsey
Priority: blocker Milestone: PostGIS 3.0.0
Component: postgis Version: master
Keywords: Cc:

Description (last modified by robe)

I thought I had tested this in 2.5 and garden tests ran to completion.

On trunk branch however, for PostgreSQL 12, this test hangs indefinitely. I let it sit there and woke up 5 hrs later and it was still stuck.

SELECT ST_Area(foo1.the_geom) As result FROM ((SELECT ST_LineToCurve(ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)) As the_geom FROM generate_series(-10,50,10) As i CROSS JOIN generate_series(40,70, 20) As j ORDER BY i, j, i*j) ) As foo1 LIMIT 10;

I'm guessing it's not the ST_Area and most likely the ST_LineToCurve at fault here. In addition to hanging indefinitely, it's not cancellable

I'll isolate it down to that and if it's a pg12 issue or a PostGIS 3.0 issue.

This I ran against PostgreSQL 12 head as of 12/27/2018

                                                             version
---------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-posix-seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit
(1 row)

                                                                                     postgis_full_version
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 POSTGIS="3.0.0dev r17118" [EXTENSION] PGSQL="120" GEOS="3.7.0-CAPI-1.11.0 673b9939" SFCGAL="1.3.2" PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1"
(1 row)

Change History (1)

comment:1 by robe, 6 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.