[postgis-tickets] [PostGIS] #5122: Crash on aurora postgres topology add_polygon

[PostGIS]

#5122: Crash on aurora postgres topology add_polygon
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  robe
      Type:  defect    |     Status:  assigned
  Priority:  medium    |  Milestone:  PostGIS 3.1.6
 Component:  topology  |    Version:  3.1.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by robe):

 Okay further investigation, it is not crashing at the building of topology
 it seems but instead on the ROLLBACK.

 Taking out the commit/rollback on my test Aurora, it completes in 2 hrs.
 On RDS it completes in about 10-11 minutes.  Working with Amazon engineer
 to troubleshoot the issue further.

 So this actually works, my mistake:


 {{{
 SELECT topology.CreateTopology('topoperf', 4269) ;
 CREATE TABLE topoperf.polygon
 AS SELECT (ST_Dump(geom)).geom AS g FROM (SELECT the_geom AS geom FROM
 tiger.state) AS f;

 SELECT topology.TopoGeo_addPolygon('topoperf', g)
   FROM topoperf.polygon;
 }}}


 But the test is really doing more like below which crashes


 {{{
 BEGIN TRANSACTION;
 SELECT topology.CreateTopology('topoperf', 4269) ;
 CREATE TABLE topoperf.polygon
 AS SELECT (ST_Dump(geom)).geom AS g FROM (SELECT the_geom AS geom FROM
 tiger.state) AS f;

 SELECT topology.TopoGeo_addPolygon('topoperf', g)
   FROM topoperf.polygon;

 ROLLBACK;
 }}}

 So I am guessing it is how the Aurora storage engine works (since that is
 what makes it a fork the plumbing under the storage engine) something it
 doesn't like.  I think I have just one reader node in addition to the
 writer, where as RDS has no extra nodes to contend with.

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