server process (PID 1122308) exited with exit code 245 when using ST_RemEdgeNewFace

[larsop]

When using ST_RemEdgeNewFace postgres core dumps, but not with ST_RemEdgeModFace .

The server is running POSTGIS="3.3.0dev 3.1.0alpha2-1416-ged023e8ff" [EXTENSION] PGSQL="120" GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" TOPOLOGY

2022-02-27 07:15:40.132 UTC [751831] LOG:  server process (PID 1122308) exited with exit code 245
2022-02-27 07:15:40.132 UTC [751831] LOG:  terminating any other active server processes

NOTICE:  ccccommand_string 
            SELECT r2.edge_id, r2.small_bb FROM (
                    SELECT edge_id, small_bb, edge_length, geom  FROM (                                                     
                    SELECT edge_id, ST_length(geom)  AS edge_length, ST_Expand(ST_LineInterpolatePoint(geom,0.5),'0.1') AS small_bb, geom 
                    FROM test_ar50_flate_lars_04.edge_data 
                    WHERE left_face != 0 AND right_face != 0 AND  
                    (('1394' = left_face AND left_face != right_face) OR ('1394' = right_face AND left_face != right_face)) 
                    ORDER BY edge_length desc
                    ) AS a1
            ) AS r2
            WHERE (
            SELECT count(*) FROM 
            (SELECT * FROM (SELECT artype, arskogbon, artreslag, arjordbr, arveget, count(DISTINCT gid) num_unique_id FROM sl_esh.ar50_uten_topologi_flate_utvalg s WHERE ST_Intersects(geo,r2.small_bb) GROUP BY artype, arskogbon, artreslag, arjordbr, arveget) AS r WHERE num_unique_id = 2) AS re
            ) = 1
            ORDER BY r2.edge_length desc LIMIT 1
NOTICE:  remove_edge <NULL> edge_geo <NULL>
NOTICE:  ccccommand_string 
            SELECT r2.edge_id, r2.small_bb FROM (
                    SELECT edge_id, small_bb, edge_length, geom  FROM (                                                     
                    SELECT edge_id, ST_length(geom)  AS edge_length, ST_Expand(ST_LineInterpolatePoint(geom,0.5),'0.1') AS small_bb, geom 
                    FROM test_ar50_flate_lars_04.edge_data 
                    WHERE left_face != 0 AND right_face != 0 AND  
                    (('8' = left_face AND left_face != right_face) OR ('8' = right_face AND left_face != right_face)) 
                    ORDER BY edge_length desc
                    ) AS a1
            ) AS r2
            WHERE (
            SELECT count(*) FROM 
            (SELECT * FROM (SELECT artype, arskogbon, artreslag, arjordbr, arveget, count(DISTINCT gid) num_unique_id FROM sl_esh.ar50_uten_topologi_flate_utvalg s WHERE ST_Intersects(geo,r2.small_bb) GROUP BY artype, arskogbon, artreslag, arjordbr, arveget) AS r WHERE num_unique_id = 2) AS re
            ) = 1
            ORDER BY r2.edge_length desc LIMIT 1
NOTICE:  remove_edge <NULL> edge_geo <NULL>
NOTICE:  Done 3 resolve polygons based on attribute type for face_table_name test_ar50_flate_lars_04.face at 2022-02-27 07:15:40.121629+00 used_time: 1.873857
NOTICE:  Work done for cell 7 (0103000020E9640000010000000500000000000000E0C8304100000000FBB45D4100000000E0C830410000008015BB5D410000000015D530410000008015BB5D410000000015D5304100000000FBB45D4100000000E0C8304100000000FBB45D41) at 2022-02-27 07:15:40.122126+00 topologgy test_ar50_flate_lars_04 and cell_job_type 6 , using 1.906648 sec
NOTICE:  leave work at timeofday:Sun Feb 27 07:15:40.122798 2022 UTC for layer <NULL>, with _cell_job_type 6 for cell 7
2022-02-27 07:15:40.124 UTC [1122291] postgres@aeg_02_lars LOG:  duration: 1934.595 ms
2022-02-27 07:15:40.132 UTC [751831] LOG:  server process (PID 1122308) exited with exit code 245
2022-02-27 07:15:40.132 UTC [751831] LOG:  terminating any other active server processes
2022-02-27 07:15:40.132 UTC [1122396] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122394] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122393] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122397] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122392] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122391] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122395] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122390] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122389] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122388] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122387] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122386] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122381] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process
2022-02-27 07:15:40.132 UTC [1122377] postgres@aeg_02_lars WARNING:  terminating connection because of crash of another server process

When doing the below postgres crashes

time psql -h geolab02.nibio.no -p 5532 -U postgres aeg_02_lars -c"CALL resolve_overlap_gap_run(
(null,null,null, -- The simple line feature info with attributtes
'sl_esh.ar50_uten_topologi_flate_utvalg','gid','geo',-- The simple polygons feature info with attributtes
25833,true,
null,null,null,null),
('test_ar50_flate_lars_04',1e-01 -- 1e-01 tolerance
,false,null,null),
resolve_overlap_data_clean_type_func(

  300,  -- if this a polygon  is below this limit it will merge into a neighbour polygon. The area is sqare meter.
  
  resolve_based_on_attribute_type_func('artype, arskogbon, artreslag, arjordbr, arveget',10,100000000), -- resolve_based_on_attribute_type for attributes that have equal values

  9, -- is this is more than zero simply will called with

  500, -- _max_average_vertex_length, in meter both for utm and deegrees, this used to avoid running ST_simplifyPreserveTopology for long lines lines with few points

  1, -- IF 0 NO CHAKINS WILL BE DONE A big value here make no sense because the number of points will increaes exponential )

  10000, --edge that are longer than this value will not be touched by _chaikins_min_degrees and _chaikins_max_degrees 

  120, -- The angle has to be less this given value, This is used to avoid to touch all angles.

  240, -- OR the angle has to be greather than this given value, This is used to avoid to touch all angles

  35, -- The angle has to be less this given value, This is used to avoid to touch all angles.

  325 -- OR The angle has to be greather than this given value, This is used to avoid to touch all angles

),
30,1000)"

[larsop]

With this commit it does not core crash