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 )
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)
Note:
See TracTickets
for help on using tickets.