[postgis-tickets] [PostGIS] #3445: topology: postgres runs out of memory on loading geometry using toTopoGeom

[PostGIS]

#3445: topology: postgres runs out of memory on loading geometry using toTopoGeom
---------------------+---------------------------
 Reporter:  rulus    |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.2.2
Component:  postgis  |    Version:  2.2.x
 Keywords:           |
---------------------+---------------------------
 I first noticed this issue in the 2.2 branch (2.2.2dev) but could
 reproduce using the latest svn-trunk revision.

 When loading a new geometry into an existing topology, the postgres
 process runs out of memory and is eventually killed by my OS (Debian).

 I'm using versions
 {{{
 PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu,
 compiled by gcc (Debian 5.2.1-23) 5.2.1 20151028, 64-bit

 POSTGIS="2.3.0dev r14623" GEOS="3.5.0-CAPI-1.9.0 r4084"
 PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.0.1,
 released 2015/09/15" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY
 RASTER
 }}}

 The statement I'm using to import the geometry:
 {{{
 insert into data.gwl (id, naam, topogeom)
 select 101, localid, topology.toTopoGeom(geom, 'gwl', 1, 0.01)
 from src."RBD_VL" where localid = 'Maas_VL';
 }}}

 Which is killed after a few minutes:
 {{{
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 The connection to the server was lost. Attempting reset: Failed.
 }}}

 Loading the same geometry in an empty topology is succesful.

 Since there is no crash as such, getting a backtrace as described in
 https://trac.osgeo.org/postgis/wiki/DevWikiGettingABackTrace is not
 possible.

 Sharing the full db is difficult, however I'm available to debug the issue
 further. I'm not experienced in debugging memory issues, maybe someone can
 give a hint on how to proceed?

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