[postgis-tickets] [PostGIS] #4652: Postgres crash with ST_GeomFromGML

PostGIS trac at osgeo.org
Fri Mar 27 05:52:24 PDT 2020


#4652: Postgres crash with ST_GeomFromGML
----------------------------+---------------------
 Reporter:  mwjhartogs      |      Owner:  pramsey
     Type:  defect          |     Status:  new
 Priority:  critical        |  Milestone:
Component:  postgis         |    Version:  2.5.x
 Keywords:  ST_GeomFromGML  |
----------------------------+---------------------
 Hi,

 Currently I have a quite large GMl which needs to be parsed to geometry.
 When I run the attached query the Postgres db will crash.

 I've tested this in Linux (Centos), Windows 10 and Windows server.
 Everywhere the same crash. I've increased the work mem to 1 GB. increased
 the shared mem.

 Error log Postgres:
 2020-03-27 13:22:16 CET LOG:  00000: server process (PID 6704) was
 terminated by exception 0xC0000374
 2020-03-27 13:22:16 CET DETAIL:  Failed process was running: select
 ST_GeomFromGML('<gml:Curve id="id-69b216c9-2c07-434d-8664-e321b3697725-0"
 srsDimension="2" srsName="urn:x-ogc:def:crs:EPSG:28992"> <gml:segments>
 <gml:LineStringSegment>
         <gml:posList>119675.91899999976 526436.1209999993
 119676.54699999839 526439.4930000007 119676.44299999997 526439.5130000003
 119676.03299999982 526439.6220000014
         119675.38500000164 526439.868999999</gml:posList>
 </gml:LineStringSegment> <gml:LineStringSegment>
 <gml:posList>119675.38500000164 526439.868999999
         119675.15500452081 526439.9735735222 119674.92922525379
 526440.0869634049 119674.70800000057 526440.2089999989</gml:posList>
 </gml:LineStringSegment>
         <gml:LineStringSegment> <gml:posList>119674.70800000057
 526440.2089999989 119674.01347910661 526440.6575801083 119673.38748824484
 526441.1976901226
         119672.84200000018 526441.8189999983</gml:posList>
 </gml:LineStringSegment> <gml:LineStringSegment>
 <gml:posList>119672.84200000018 526441.8189999983
         119671.85700000077 526442.8630000018 119670.99599999934
 526443.2149999999 119660.08
 2020-03-27 13:22:16 CET HINT:  See C include file "ntstatus.h" for a
 description of the hexadecimal value.
 2020-03-27 13:22:16 CET LOCATION:  LogChildExit, postmaster.c:3492
 2020-03-27 13:22:16 CET LOG:  00000: terminating any other active server
 processes
 2020-03-27 13:22:16 CET LOCATION:  HandleChildCrash, postmaster.c:3223
 2020-03-27 13:22:16 CET WARNING:  57P02: terminating connection because of
 crash of another server process
 2020-03-27 13:22:16 CET DETAIL:  The postmaster has commanded this server
 process to roll back the current transaction and exit, because another
 server process exited abnormally and possibly corrupted shared memory.
 2020-03-27 13:22:16 CET HINT:  In a moment you should be able to reconnect
 to the database and repeat your command.
 2020-03-27 13:22:16 CET LOCATION:  quickdie, postgres.c:2601
 2020-03-27 13:22:16 CET WARNING:  57P02: terminating connection because of
 crash of another server process
 2020-03-27 13:22:16 CET DETAIL:  The postmaster has commanded this server
 process to roll back the current transaction and exit, because another
 server process exited abnormally and possibly corrupted shared memory.
 2020-03-27 13:22:16 CET HINT:  In a moment you should be able to reconnect
 to the database and repeat your command.
 2020-03-27 13:22:16 CET LOCATION:  quickdie, postgres.c:2601
 2020-03-27 13:22:16 CET WARNING:  57P02: terminating connection because of
 crash of another server process
 2020-03-27 13:22:16 CET DETAIL:  The postmaster has commanded this server
 process to roll back the current transaction and exit, because another
 server process exited abnormally and possibly corrupted shared memory.
 2020-03-27 13:22:16 CET HINT:  In a moment you should be able to reconnect
 to the database and repeat your command.
 2020-03-27 13:22:16 CET LOCATION:  quickdie, postgres.c:2601
 2020-03-27 13:22:16 CET LOG:  00000: all server processes terminated;
 reinitializing
 2020-03-27 13:22:16 CET LOCATION:  PostmasterStateMachine,
 postmaster.c:3747
 2020-03-27 13:22:16 CET LOG:  00000: database system was interrupted; last
 known up at 2020-03-27 13:21:58 CET
 2020-03-27 13:22:16 CET LOCATION:  StartupXLOG, xlog.c:6019

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4652>
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