[PostGIS] #5929: Spatial exception Postgis Topology missing info

[PostGIS]

#5929: Spatial exception Postgis Topology missing info
-------------------------------+---------------------------
 Reporter:  Lars Aksel Opsahl  |      Owner:  strk
     Type:  enhancement        |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 3.5.4
Component:  topology           |    Version:  3.5.x
 Keywords:                     |
-------------------------------+---------------------------
 When I get the errors I have
 {{{
 EXCEPTION WHEN OTHERS THEN
 }}}

 Her is a sample

 {{{
 Spatial exception - geometry intersects edge 3808 detail
 }}}

 I have the line I add in the log but in the catch block I now also run
 this cmd to egde geom causing a problem.


 {{{
 SELECT geom FROM grunnkart_037_1.edge_data WHERE edge_id = 3808

 }}}

 The I try reproduce the problem on the same server I got the error, but
 that does note work. This errors does happen every time so I also added a
 for loop.


 {{{
 do
 $$
 begin
         for counter in 1..100 loop
                 PERFORM topology.CreateTopology ('grunnkart_037_1', 4258 ,
 0);
                 PERFORM
 topology.TopoGeo_addLinestring('grunnkart_037_1','0102000020A21000000700000081DDF71D56D51640FCD776A6B2764D40838A94D44ED516401A04CEAFB2764D405F754DA659D51640B606DA1DBB764D400F54CA495CD51640E0F0D471BD764D40B166D1495CD51640299BDA71BD764D400D582F7062D5164010F157F4C1764D40D77E307062D5164096C658F4C1764D40',0);
                 PERFORM
 topology.TopoGeo_addLinestring('grunnkart_037_1','0102000020A210000067000000D8CFF5F1B1D51640C6B04EFFB7764D404456FC7CA0D5164026DE67BAB7764D407C299E2C90D51640E382B6E9B8764D40A20AB22D78D5164098058D3EC4764D409026945B6FD516402A366046C5764D40899B741667D516409AC3F347C5764D40D77E307062D5164096C658F4C1764D400D582F7062D5164010F157F4C1764D40B166D1495CD51640299BDA71BD764D400F54CA495CD51640E0F0D471BD764D405F754DA659D51640B606DA1DBB764D40838A94D44ED516401A04CEAFB2764D4020A2FBB14ED51640725DFAAFB2764D407F8CEF2B4AD51640FFC9C7B5B2764D400C52A5714CD51640C62EA476B4764D40D391B0DF4ED51640CECA2F5CB6764D40097FC12452D516406834A4F1B8764D40AA7887FD54D516400757E623BB764D400FD955A157D5164032B92978BD764D4035705D945AD5164056FD569DBF764D4016A097C85DD5164097C345FBC1764D40C739C78560D516408C5307E4C3764D4052A28B7A61D51640C114219CC4764D40C94BDCA962D5164027674571C5764D4078BAC96165D516400C7D016BC7764D4066D9E26F68D516408F3A3556C9764D405E64F5636BD51640C8293DA4CB764D40058EA62B6ED516403181AF9FCD764D40DCA017D771D51640F45817B8CF764D4006A1D2C974D51640A2A59F8FD1764D404F15785478D5164063771EEED3764D4059C3214A7DD5164005937779D6764D400E27882482D51640DEDABE37D9764D407C04991F85D516404D0EA7E6DA764D40CFB5BE3789D51640BA422EF7DC764D403CDEE5168DD516405E3128DCDE764D40BDA50C0194D5164024767F17E2764D403191187099D516400A2DC9A3E4764D40D8DD43C29CD516406884BD26E6764D4064A10168A1D5164099570A06E8764D406DBA07C1A5D516403FF1DCC9E9764D400F81EF39A9D516409AEC666EEB764D4025EA7E5CAED51640EF9FB763ED764D40BA0DDC93B4D5164008A06F6BEF764D4070D293F7BAD51640734D5CAFF1764D403CCD7572BFD51640D4F7EE28F3764D40E3FC043DC4D5164031E13DDBF4764D40D619B800CAD51640701EB5A6F6764D40A66BAC2DD9D51640C57CFC2CFB764D40F3B75D74DED51640E441EBC9FC764D403B1342AEE2D516408FFD9627FE764D40CB8032BCE8D51640CAFD1CC4FF764D402135C761F0D51640FEB43BD201774D40775CFF3EF7D51640644628AC03774D40382EB4BAFFD516409A272DB905774D407729A67A06D6164082231E5C07774D4098D1ABD30FD616401EDA788B09774D407D94311510D61640DB9DC99A09774D40D5A3CAAC11D616408821CFF309774D40F208A73A19D6164083B12C9A0B774D407DA1766620D616406E79824A0D774D4096335F512AD61640CCC435670F774D4047AB568D33D616401DAAD93E11774D40C88BB5533BD61640A5D65BDB12774D40D47F647F46D61640DBC1210915774D400F5AB33A52D61640DFFDD43417774D40E16203DE5CD616404690861619774D4085C62A7F6AD616408B11F97F1B774D40D635417577D61640CDE07EA71D774D40C3C2394C84D61640C94E55CC1F774D4052DBEE9C90D616409394A3D021774D405C65A0329DD6164032024FC523774D4042BA59E2A8D61640E3B86D8D25774D40F94B3842B6D61640A98E758427774D4004BB3004BCD6164076D7B76728774D404C547BB8D2D61640649828A72B774D4003AFDA36DDD61640ABC222122D774D40B1BB1D45E9D616404F0B2DBF2E774D4082699A48F6D61640BBE4378830774D40ED51E35703D71640DCDA5F3932774D40F42FFE3B10D71640CFC7CBDA33774D40C4FB32E213D716400874F65034774D405F28A9DA20D7164082F9A21536774D40F9312E182DD71640B8D2D18E37774D40541C327B35D71640B6B37D8538774D40F6850A923AD7164072E6F72639774D403EFBE0C243D71640A4CBB3453A774D40C04BD67C48D71640C97D90D83A774D409CA2764649D71640D9466FF03A774D4081A0077556D716406F8AE26E3C774D406EBB7A6D64D716403A8B60153E774D40E7D2A1CE6CD7164015399AF93E774D40BD3FD02271D716406F76806F3F774D400E27237A7ED7164060336DEE40774D406ED85A9C8BD7164021B5CC5142774D4033ECC07697D71640F9A8869443774D40BB54414AA5D7164020E4E80B45774D40FFBF6C8DB2D7164055C2F35846774D4047ED3011BFD71640873824A647774D40F63E64B1CED7164042B8892F49774D40D43DEAE3DFD71640FA200AD54A774D400A439B1AF1D716409803A87D4C774D40E72FE50FF3D716401C7A07AE4C774D40',0);
                 PERFORM topology.DropTopology ('grunnkart_037_1');
         end loop;
 end;
 $$;

 }}}

 Is this expected ?

 I will try to change code in catch block to get more info.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5929>
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.