[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