[postgis-tickets] [PostGIS] #3612: ST_ClusterDBSCAN garden crasher

PostGIS trac at osgeo.org
Tue Aug 16 16:23:58 PDT 2016


#3612: ST_ClusterDBSCAN 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 had a chance to dissect this or even check if it fails in lower
 PostgreSQL versions.

 I'm running:


 {{{
 PostgreSQL 9.6beta4, compiled by Visual C++ build 1800, 64-bit
 POSTGIS="2.3.0dev r15043" GEOS="3.5.0-CAPI-1.9.0 r4090" SFCGAL="1.3.0"
 PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.1.0, released 2016/04/25"
 LIBXML="2.7.8" LIBJSON="0.12" RASTER
 }}}

 Query that crashes:


 {{{
 SELECT ST_ClusterDBSCAN(foo1.the_geom, 20.1, 5)OVER()  As result
                                                         FROM ((SELECT geom
 As the_geom
 FROM (VALUES ( ST_GeomFromEWKT('SRID=4326;POLYGONM((-71.1319 42.2503
 1,-71.132 42.2502 3,-71.1323 42.2504 -2,-71.1322 42.2505 1,-71.1319
 42.2503 0))') ),
         ( ST_GeomFromEWKT('SRID=4326;POLYGONM((-71.1319 42.2512 0,-71.1318
 42.2511 20,-71.1317 42.2511 -20,-71.1317 42.251 5,-71.1317 42.2509
 4,-71.132 42.2511 6,-71.1319 42.2512 30))') ) ) As g(geom))) As foo1 LIMIT
 3;
 }}}

 Back trace just


 {{{
 #0  0x00000000696dcb4a in postgis-2.3!ST_ClusterDBSCAN ()
    from
 C:\ming64gcc48\projects\postgresql\rel\pg9.6w64gcc48edb\lib\postgis-2.3.dll
 #1  0x000000014015358f in postgres!WinGetFuncArgCurrent ()
 #2  0x0000000140151f0e in postgres!ExecWindowAgg ()
 Backtrace stopped: previous frame inner to this frame (corrupt stack?)

 }}}

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


More information about the postgis-tickets mailing list