[postgis-tickets] [PostGIS] #4282: ST_LineToCurve hangs indefintely

[PostGIS]

#4282: ST_LineToCurve hangs indefintely
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.0.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by robe:

Old description:

> 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 work 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)
>
> }}}

New description:

 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)

 }}}

--

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4282#comment:1>
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.