[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