[postgis-tickets] [PostGIS] #5293: toTopoGeom: corrupted topology: face xxx could not be constructed only from edges knowing about it (like edge yyy).
PostGIS
trac at osgeo.org
Wed Feb 22 06:39:17 PST 2023
#5293: toTopoGeom: corrupted topology: face xxx could not be constructed only from
edges knowing about it (like edge yyy).
-----------------------+---------------------------
Reporter: strk | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.0
Component: topology | Version: master
Resolution: | Keywords:
-----------------------+---------------------------
Comment (by laopsahl):
I am testing on
{{{
POSTGIS="3.2.3 2f97b6c" [EXTENSION] PGSQL="140" GEOS="3.11.0-CAPI-1.17.0"
PROJ="9.0.1" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1"
WAGYU="0.5.0 (Internal)" TOPOLOGY
}}}
When I run the command below with test.sql a couple of times this, I see
the log below.
This are also the same error messages related to this error
[https://gitlab.com/nibioopensource/resolve-overlap-and-gap/-/issues/46]
{{{
rm /tmp/error.out; psql nibio_reg -f /tmp/test.sql 2>/tmp/error.out; cat
/tmp/error.out
}}}
I find this in error.out file.
{{{
psql:/tmp/test.sql:1: NOTICE: 00000: Dropping all layers from topology
'postgis_ticket_5293_topo' (3)
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:1: NOTICE: 00000: drop cascades to 6 other objects
DETAIL: drop cascades to table postgis_ticket_5293_topo.face
drop cascades to table postgis_ticket_5293_topo.node
drop cascades to table postgis_ticket_5293_topo.edge_data
drop cascades to view postgis_ticket_5293_topo.edge
drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
drop cascades to table postgis_ticket_5293_topo.relation
LOCATION: reportDependentObjects, dependency.c:1216
psql:/tmp/test.sql:74: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:79: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:112: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 52)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
Larss-MacBook-Pro:resolve-overlap-and-gap lop$ gzip /tmp/test.sql
Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
psql:/tmp/test.sql:1: NOTICE: 00000: Dropping all layers from topology
'postgis_ticket_5293_topo' (3)
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:1: NOTICE: 00000: drop cascades to 6 other objects
DETAIL: drop cascades to table postgis_ticket_5293_topo.face
drop cascades to table postgis_ticket_5293_topo.node
drop cascades to table postgis_ticket_5293_topo.edge_data
drop cascades to view postgis_ticket_5293_topo.edge
drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
drop cascades to table postgis_ticket_5293_topo.relation
LOCATION: reportDependentObjects, dependency.c:1216
psql:/tmp/test.sql:74: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:79: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:112: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 52)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
psql:/tmp/test.sql:1: NOTICE: 00000: Dropping all layers from topology
'postgis_ticket_5293_topo' (3)
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:1: NOTICE: 00000: drop cascades to 6 other objects
DETAIL: drop cascades to table postgis_ticket_5293_topo.face
drop cascades to table postgis_ticket_5293_topo.node
drop cascades to table postgis_ticket_5293_topo.edge_data
drop cascades to view postgis_ticket_5293_topo.edge
drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
drop cascades to table postgis_ticket_5293_topo.relation
LOCATION: reportDependentObjects, dependency.c:1216
psql:/tmp/test.sql:74: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:79: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:112: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 52)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
psql:/tmp/test.sql:1: NOTICE: 00000: Dropping all layers from topology
'postgis_ticket_5293_topo' (3)
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:1: NOTICE: 00000: drop cascades to 6 other objects
DETAIL: drop cascades to table postgis_ticket_5293_topo.face
drop cascades to table postgis_ticket_5293_topo.node
drop cascades to table postgis_ticket_5293_topo.edge_data
drop cascades to view postgis_ticket_5293_topo.edge
drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
drop cascades to table postgis_ticket_5293_topo.relation
LOCATION: reportDependentObjects, dependency.c:1216
psql:/tmp/test.sql:74: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:79: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:112: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 52)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$
Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
psql:/tmp/test.sql:1: NOTICE: 00000: Dropping all layers from topology
'postgis_ticket_5293_topo' (3)
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:1: NOTICE: 00000: drop cascades to 6 other objects
DETAIL: drop cascades to table postgis_ticket_5293_topo.face
drop cascades to table postgis_ticket_5293_topo.node
drop cascades to table postgis_ticket_5293_topo.edge_data
drop cascades to view postgis_ticket_5293_topo.edge
drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
drop cascades to table postgis_ticket_5293_topo.relation
LOCATION: reportDependentObjects, dependency.c:1216
psql:/tmp/test.sql:74: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:79: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 0)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:111: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:112: ERROR: XX000: Corrupted topology: adjacent edges
-64 and -64 bind different face (45 and 52)
LOCATION: pg_error, lwgeom_pg.c:342
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for coincident nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges crossing nodes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for invalid or not-simple
edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for crossing edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges start_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for edges end_node
mismatch
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for faces without edges
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking edge linking
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Building edge rings
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Found 95 rings, 63 valid shells,
32 valid holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Constructing geometry of all faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checked 63 faces
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for holes coverage
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Finished checking for coverage of
32 holes
LOCATION: exec_stmt_raise, pl_exec.c:3873
psql:/tmp/test.sql:113: NOTICE: 00000: Checking for node containing_face
correctness
LOCATION: exec_stmt_raise, pl_exec.c:3873
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5293#comment:6>
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