[PostGIS] #6061: segmentation fault when loading geometries

[PostGIS]

#6061: segmentation fault when loading geometries
---------------------------+---------------------------
 Reporter:  maxsynytsky1v  |      Owner:  pramsey
     Type:  defect         |     Status:  new
 Priority:  medium         |  Milestone:  PostGIS 3.6.2
Component:  postgis        |    Version:  3.6.x
 Keywords:                 |
---------------------------+---------------------------
 I have a set of data extracted from Oracle database with ora2pg.
 The source geometries are Esri's ST_GEOMETRY and they are exported into
 WKT using SDE functions (SDE.ST_ASTEXT).

 During import I experience a crash of PostgreSQL cluster.
 {{{
 2026-03-25 17:39:30.083 GMT,,,1245799,,69bad932.130267,27,,2026-03-18
 16:56:18 GMT,,0,LOG,00000,"server process (PID 1293403) was terminated by
 signal 11: Segmentation fault","Failed process was running: COPY
 <redacted> FROM STDIN;",,,,,,,,"","postmaster",,0
 2026-03-25 17:39:30.083 GMT,,,1245799,,69bad932.130267,28,,2026-03-18
 16:56:18 GMT,,0,LOG,00000,"terminating any other active server
 processes",,,,,,,,,"","postmaster",,0
 2026-03-25 17:39:30.091 GMT,,,1245799,,69bad932.130267,29,,2026-03-18
 16:56:18 GMT,,0,LOG,00000,"all server processes terminated;
 reinitializing",,,,,,,,,"","postmaster",,0
 2026-03-25 17:39:30.122 GMT,,,1293440,,69c41dd2.13bc80,1,,2026-03-25
 17:39:30 GMT,,0,LOG,00000,"database system was interrupted; last known up
 at 2026-03-25 17:38:57 GMT",,,,,,,,,"","startup",,0
 2026-03-25 17:39:31.277 GMT,,,1293440,,69c41dd2.13bc80,2,,2026-03-25
 17:39:30 GMT,,0,LOG,00000,"database system was not properly shut down;
 automatic recovery in progress",,,,,,,,,"","startup",,0
 }}}

 I am pretty sure the problem is not in the geometry extracted because the
 rows are always different but the problem can be reproduced consistently.
 For example:

 {{{
 psql:data/data.sql:7114983: SSL SYSCALL error: EOF detected
 invalid socket
 psql:data/data.sql:7114983: error: connection to server was lost
 ERROR: an error occurs when importing file ./data/data.sql.

 psql:data/data.sql:7115021: SSL SYSCALL error: EOF detected
 invalid socket
 psql:data/data.sql:7115021: error: connection to server was lost
 ERROR: an error occurs when importing file ./data/data.sql.

 psql:data/data.sql:7115004: SSL SYSCALL error: EOF detected
 invalid socket
 psql:data/data.sql:7115004: error: connection to server was lost
 ERROR: an error occurs when importing file ./data/data.sql.

 psql:data/data.sql:7115055: SSL SYSCALL error: EOF detected
 invalid socket
 psql:data/data.sql:7115055: error: connection to server was lost
 ERROR: an error occurs when importing file ./data/data.sql.
 }}}

 I am using PostgreSQL 16.13 and PostGIS 3.6.2, OS is Debian 12.5.
 I will be uploading a gdb core debug and I made sure that PostgreSQL and
 PostGIS debug symbol packages are installed but I am running a release
 PostgreSQL.

 I redacted the debug to remove sensitive data but if you feel that this is
 necessary I will talk to the manager(s) if we can disclose this.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6061>
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.