Changes between Initial Version and Version 1 of Ticket #5293, comment 6


Ignore:
Timestamp:
Feb 22, 2023, 10:02:48 PM (15 months ago)
Author:
Lars Aksel Opsahl

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5293, comment 6

    initial v1  
    55}}}
    66
     7This are also the same error messages related to this error [https://gitlab.com/nibioopensource/resolve-overlap-and-gap/-/issues/46]
     8
    79When I run the command below with test.sql a couple of times this, I see the log below.
    8 
    9 This are also the same error messages related to this error [https://gitlab.com/nibioopensource/resolve-overlap-and-gap/-/issues/46]
    1010
    1111{{{
    … …  
    1717{{{
    1818
    19 psql:/tmp/test.sql:1: NOTICE:  00000: Dropping all layers from topology 'postgis_ticket_5293_topo' (3)
    20 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    21 psql:/tmp/test.sql:1: NOTICE:  00000: drop cascades to 6 other objects
    22 DETAIL:  drop cascades to table postgis_ticket_5293_topo.face
    23 drop cascades to table postgis_ticket_5293_topo.node
    24 drop cascades to table postgis_ticket_5293_topo.edge_data
    25 drop cascades to view postgis_ticket_5293_topo.edge
    26 drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
    27 drop cascades to table postgis_ticket_5293_topo.relation
    28 LOCATION:  reportDependentObjects, dependency.c:1216
    29 psql:/tmp/test.sql:74: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    30 LOCATION:  pg_error, lwgeom_pg.c:342
    31 psql:/tmp/test.sql:79: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    32 LOCATION:  pg_error, lwgeom_pg.c:342
    33 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for coincident nodes
    34 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    35 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges crossing nodes
    36 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    37 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for invalid or not-simple edges
    38 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    39 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for crossing edges
    40 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    41 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges start_node mismatch
    42 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    43 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges end_node mismatch
    44 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    45 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for faces without edges
    46 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    47 psql:/tmp/test.sql:111: NOTICE:  00000: Checking edge linking
    48 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    49 psql:/tmp/test.sql:111: NOTICE:  00000: Building edge rings
    50 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    51 psql:/tmp/test.sql:111: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    52 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    53 psql:/tmp/test.sql:111: NOTICE:  00000: Constructing geometry of all faces
    54 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    55 psql:/tmp/test.sql:111: NOTICE:  00000: Checking faces
    56 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    57 psql:/tmp/test.sql:111: NOTICE:  00000: Checked 63 faces
    58 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    59 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for holes coverage
    60 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    61 psql:/tmp/test.sql:111: NOTICE:  00000: Finished checking for coverage of 32 holes
    62 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    63 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for node containing_face correctness
    64 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    65 psql:/tmp/test.sql:112: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 52)
    66 LOCATION:  pg_error, lwgeom_pg.c:342
    67 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for coincident nodes
    68 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    69 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges crossing nodes
    70 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    71 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for invalid or not-simple edges
    72 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    73 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for crossing edges
    74 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    75 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges start_node mismatch
    76 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    77 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges end_node mismatch
    78 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    79 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for faces without edges
    80 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    81 psql:/tmp/test.sql:113: NOTICE:  00000: Checking edge linking
    82 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    83 psql:/tmp/test.sql:113: NOTICE:  00000: Building edge rings
    84 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    85 psql:/tmp/test.sql:113: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    86 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    87 psql:/tmp/test.sql:113: NOTICE:  00000: Constructing geometry of all faces
    88 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    89 psql:/tmp/test.sql:113: NOTICE:  00000: Checking faces
    90 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    91 psql:/tmp/test.sql:113: NOTICE:  00000: Checked 63 faces
    92 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    93 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for holes coverage
    94 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    95 psql:/tmp/test.sql:113: NOTICE:  00000: Finished checking for coverage of 32 holes
    96 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    97 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for node containing_face correctness
    98 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    99 Larss-MacBook-Pro:resolve-overlap-and-gap lop$ gzip /tmp/test.sql
    100 Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
    101 psql:/tmp/test.sql:1: NOTICE:  00000: Dropping all layers from topology 'postgis_ticket_5293_topo' (3)
    102 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    103 psql:/tmp/test.sql:1: NOTICE:  00000: drop cascades to 6 other objects
    104 DETAIL:  drop cascades to table postgis_ticket_5293_topo.face
    105 drop cascades to table postgis_ticket_5293_topo.node
    106 drop cascades to table postgis_ticket_5293_topo.edge_data
    107 drop cascades to view postgis_ticket_5293_topo.edge
    108 drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
    109 drop cascades to table postgis_ticket_5293_topo.relation
    110 LOCATION:  reportDependentObjects, dependency.c:1216
    111 psql:/tmp/test.sql:74: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    112 LOCATION:  pg_error, lwgeom_pg.c:342
    113 psql:/tmp/test.sql:79: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    114 LOCATION:  pg_error, lwgeom_pg.c:342
    115 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for coincident nodes
    116 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    117 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges crossing nodes
    118 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    119 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for invalid or not-simple edges
    120 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    121 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for crossing edges
    122 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    123 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges start_node mismatch
    124 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    125 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges end_node mismatch
    126 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    127 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for faces without edges
    128 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    129 psql:/tmp/test.sql:111: NOTICE:  00000: Checking edge linking
    130 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    131 psql:/tmp/test.sql:111: NOTICE:  00000: Building edge rings
    132 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    133 psql:/tmp/test.sql:111: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    134 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    135 psql:/tmp/test.sql:111: NOTICE:  00000: Constructing geometry of all faces
    136 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    137 psql:/tmp/test.sql:111: NOTICE:  00000: Checking faces
    138 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    139 psql:/tmp/test.sql:111: NOTICE:  00000: Checked 63 faces
    140 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    141 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for holes coverage
    142 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    143 psql:/tmp/test.sql:111: NOTICE:  00000: Finished checking for coverage of 32 holes
    144 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    145 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for node containing_face correctness
    146 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    147 psql:/tmp/test.sql:112: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 52)
    148 LOCATION:  pg_error, lwgeom_pg.c:342
    149 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for coincident nodes
    150 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    151 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges crossing nodes
    152 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    153 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for invalid or not-simple edges
    154 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    155 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for crossing edges
    156 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    157 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges start_node mismatch
    158 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    159 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges end_node mismatch
    160 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    161 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for faces without edges
    162 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    163 psql:/tmp/test.sql:113: NOTICE:  00000: Checking edge linking
    164 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    165 psql:/tmp/test.sql:113: NOTICE:  00000: Building edge rings
    166 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    167 psql:/tmp/test.sql:113: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    168 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    169 psql:/tmp/test.sql:113: NOTICE:  00000: Constructing geometry of all faces
    170 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    171 psql:/tmp/test.sql:113: NOTICE:  00000: Checking faces
    172 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    173 psql:/tmp/test.sql:113: NOTICE:  00000: Checked 63 faces
    174 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    175 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for holes coverage
    176 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    177 psql:/tmp/test.sql:113: NOTICE:  00000: Finished checking for coverage of 32 holes
    178 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    179 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for node containing_face correctness
    180 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    181 Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
    182 psql:/tmp/test.sql:1: NOTICE:  00000: Dropping all layers from topology 'postgis_ticket_5293_topo' (3)
    183 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    184 psql:/tmp/test.sql:1: NOTICE:  00000: drop cascades to 6 other objects
    185 DETAIL:  drop cascades to table postgis_ticket_5293_topo.face
    186 drop cascades to table postgis_ticket_5293_topo.node
    187 drop cascades to table postgis_ticket_5293_topo.edge_data
    188 drop cascades to view postgis_ticket_5293_topo.edge
    189 drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
    190 drop cascades to table postgis_ticket_5293_topo.relation
    191 LOCATION:  reportDependentObjects, dependency.c:1216
    192 psql:/tmp/test.sql:74: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    193 LOCATION:  pg_error, lwgeom_pg.c:342
    194 psql:/tmp/test.sql:79: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    195 LOCATION:  pg_error, lwgeom_pg.c:342
    196 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for coincident nodes
    197 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    198 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges crossing nodes
    199 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    200 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for invalid or not-simple edges
    201 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    202 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for crossing edges
    203 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    204 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges start_node mismatch
    205 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    206 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges end_node mismatch
    207 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    208 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for faces without edges
    209 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    210 psql:/tmp/test.sql:111: NOTICE:  00000: Checking edge linking
    211 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    212 psql:/tmp/test.sql:111: NOTICE:  00000: Building edge rings
    213 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    214 psql:/tmp/test.sql:111: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    215 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    216 psql:/tmp/test.sql:111: NOTICE:  00000: Constructing geometry of all faces
    217 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    218 psql:/tmp/test.sql:111: NOTICE:  00000: Checking faces
    219 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    220 psql:/tmp/test.sql:111: NOTICE:  00000: Checked 63 faces
    221 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    222 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for holes coverage
    223 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    224 psql:/tmp/test.sql:111: NOTICE:  00000: Finished checking for coverage of 32 holes
    225 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    226 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for node containing_face correctness
    227 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    228 psql:/tmp/test.sql:112: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 52)
    229 LOCATION:  pg_error, lwgeom_pg.c:342
    230 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for coincident nodes
    231 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    232 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges crossing nodes
    233 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    234 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for invalid or not-simple edges
    235 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    236 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for crossing edges
    237 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    238 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges start_node mismatch
    239 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    240 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges end_node mismatch
    241 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    242 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for faces without edges
    243 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    244 psql:/tmp/test.sql:113: NOTICE:  00000: Checking edge linking
    245 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    246 psql:/tmp/test.sql:113: NOTICE:  00000: Building edge rings
    247 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    248 psql:/tmp/test.sql:113: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    249 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    250 psql:/tmp/test.sql:113: NOTICE:  00000: Constructing geometry of all faces
    251 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    252 psql:/tmp/test.sql:113: NOTICE:  00000: Checking faces
    253 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    254 psql:/tmp/test.sql:113: NOTICE:  00000: Checked 63 faces
    255 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    256 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for holes coverage
    257 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    258 psql:/tmp/test.sql:113: NOTICE:  00000: Finished checking for coverage of 32 holes
    259 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    260 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for node containing_face correctness
    261 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    262 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    263 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    264 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    265 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    266 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    267 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    268 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    269 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    270 Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
    271 psql:/tmp/test.sql:1: NOTICE:  00000: Dropping all layers from topology 'postgis_ticket_5293_topo' (3)
    272 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    273 psql:/tmp/test.sql:1: NOTICE:  00000: drop cascades to 6 other objects
    274 DETAIL:  drop cascades to table postgis_ticket_5293_topo.face
    275 drop cascades to table postgis_ticket_5293_topo.node
    276 drop cascades to table postgis_ticket_5293_topo.edge_data
    277 drop cascades to view postgis_ticket_5293_topo.edge
    278 drop cascades to sequence postgis_ticket_5293_topo.layer_id_seq
    279 drop cascades to table postgis_ticket_5293_topo.relation
    280 LOCATION:  reportDependentObjects, dependency.c:1216
    281 psql:/tmp/test.sql:74: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    282 LOCATION:  pg_error, lwgeom_pg.c:342
    283 psql:/tmp/test.sql:79: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 0)
    284 LOCATION:  pg_error, lwgeom_pg.c:342
    285 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for coincident nodes
    286 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    287 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges crossing nodes
    288 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    289 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for invalid or not-simple edges
    290 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    291 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for crossing edges
    292 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    293 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges start_node mismatch
    294 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    295 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for edges end_node mismatch
    296 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    297 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for faces without edges
    298 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    299 psql:/tmp/test.sql:111: NOTICE:  00000: Checking edge linking
    300 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    301 psql:/tmp/test.sql:111: NOTICE:  00000: Building edge rings
    302 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    303 psql:/tmp/test.sql:111: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    304 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    305 psql:/tmp/test.sql:111: NOTICE:  00000: Constructing geometry of all faces
    306 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    307 psql:/tmp/test.sql:111: NOTICE:  00000: Checking faces
    308 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    309 psql:/tmp/test.sql:111: NOTICE:  00000: Checked 63 faces
    310 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    311 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for holes coverage
    312 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    313 psql:/tmp/test.sql:111: NOTICE:  00000: Finished checking for coverage of 32 holes
    314 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    315 psql:/tmp/test.sql:111: NOTICE:  00000: Checking for node containing_face correctness
    316 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    317 psql:/tmp/test.sql:112: ERROR:  XX000: Corrupted topology: adjacent edges -64 and -64 bind different face (45 and 52)
    318 LOCATION:  pg_error, lwgeom_pg.c:342
    319 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for coincident nodes
    320 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    321 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges crossing nodes
    322 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    323 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for invalid or not-simple edges
    324 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    325 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for crossing edges
    326 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    327 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges start_node mismatch
    328 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    329 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for edges end_node mismatch
    330 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    331 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for faces without edges
    332 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    333 psql:/tmp/test.sql:113: NOTICE:  00000: Checking edge linking
    334 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    335 psql:/tmp/test.sql:113: NOTICE:  00000: Building edge rings
    336 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    337 psql:/tmp/test.sql:113: NOTICE:  00000: Found 95 rings, 63 valid shells, 32 valid holes
    338 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    339 psql:/tmp/test.sql:113: NOTICE:  00000: Constructing geometry of all faces
    340 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    341 psql:/tmp/test.sql:113: NOTICE:  00000: Checking faces
    342 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    343 psql:/tmp/test.sql:113: NOTICE:  00000: Checked 63 faces
    344 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    345 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for holes coverage
    346 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    347 psql:/tmp/test.sql:113: NOTICE:  00000: Finished checking for coverage of 32 holes
    348 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    349 psql:/tmp/test.sql:113: NOTICE:  00000: Checking for node containing_face correctness
    350 LOCATION:  exec_stmt_raise, pl_exec.c:3873
    351 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    352 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    353 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    354 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    355 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    356 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    357 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    358 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    359 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    360 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    361 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    362 Larss-MacBook-Pro:resolve-overlap-and-gap lop$
    36319Larss-MacBook-Pro:resolve-overlap-and-gap lop$ cat /tmp/error.out
    36420psql:/tmp/test.sql:1: NOTICE:  00000: Dropping all layers from topology 'postgis_ticket_5293_topo' (3)