[postgis-users] postgres crash on invalid gml in geomfromgml

Willy-Bas Loos willybas at gmail.com
Tue Oct 4 00:59:26 PDT 2011


Hi,

PostgreSQL crashes when i send it an 'invalid' gml in st_geomfromgml(().
In fact the gml is not invalid AFAIK, but it might be considered a
GML-document instead of a GML-fragment.
The server is supposed to throw an error when that happens, but it crashes.

query:
select st_geomfromgml('<OriginalGeometry gml:id="1" srsDimension="2"
srsName="EPSG:28992" xsi:type="gml:PointType"
xmlns:ns="http://willy-bas.nl/yes/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:gml="http://www.opengis.net/gml/3.2">
  <gml:Point>
    <gml:posList>600000 300000</gml:posList>
  </gml:Point>
</OriginalGeometry>')

Response:
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Log:
2011-10-04 09:48:37 CEST pid=995 LOG:  server process (PID 5181) was
terminated by signal 11: Segmentation fault
2011-10-04 09:48:37 CEST pid=995 LOG:  terminating any other active
server processes
2011-10-04 09:48:37 CEST pid=5180 WARNING:  terminating connection
because of crash of another server process
2011-10-04 09:48:37 CEST pid=5180 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.
2011-10-04 09:48:37 CEST pid=5180 HINT:  In a moment you should be
able to reconnect to the database and repeat your command.
2011-10-04 09:48:37 CEST pid=5175 WARNING:  terminating connection
because of crash of another server process
2011-10-04 09:48:37 CEST pid=5175 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.
2011-10-04 09:48:37 CEST pid=5175 HINT:  In a moment you should be
able to reconnect to the database and repeat your command.
2011-10-04 09:48:37 CEST pid=995 LOG:  all server processes
terminated; reinitializing
2011-10-04 09:48:38 CEST pid=5438 LOG:  database system was
interrupted; last known up at 2011-10-04 09:32:41 CEST
2011-10-04 09:48:38 CEST pid=5438 LOG:  database system was not
properly shut down; automatic recovery in progress
2011-10-04 09:48:38 CEST pid=5438 LOG:  record with zero length at 0/201D9A8
2011-10-04 09:48:38 CEST pid=5438 LOG:  redo is not required
2011-10-04 09:48:38 CEST pid=5441 LOG:  autovacuum launcher started
2011-10-04 09:48:38 CEST pid=995 LOG:  database system is ready to
accept connections

Cheers,

WBL
-- 
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw



More information about the postgis-users mailing list