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

[Sandro Santilli]

Willy-Bas,
could you please file a ticket for this issue on
http://trac.osgeo.org/postgis ?

Thanks in advance.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

On Tue, Oct 04, 2011 at 09:59:26AM +0200, Willy-Bas Loos wrote:
> 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