[postgis-devel] [GENERAL] Getting FATAL: terminating connection due to administrator command

Peter Hopfgartner peter.hopfgartner at r3-gis.com
Thu Oct 14 05:39:58 PDT 2010


If I do:

SELECT St_Buffer('0101000020E8640000000000000000F8FF000000000000F8FF', 50);

the PostgreSQL process leaves with:

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.

The geometry looks like:
POINT(nan nan)

Regards,

Peter Hopfgartner
 
R3 GIS Srl - GmbH
http://www.r3-gis.com


--------Tom Lane <tgl at sss.pgh.pa.us> wrote--------
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to administrator command 
Date: 15.09.2010 21:34

>"Joshua J. Kugler" <joshua at eeinternet.com> writes:
>> On Wednesday 15 September 2010, Peter Hopfgartner elucidated thus:
>>> The server is a rather bare bone server for web mapping, so basically
>>> PostgreSQL/PostGIS, Apache, PHP, Tomcat and little other stuff. The
>>> Dell software was the only which did not come from
>>> CentOS/EPEL/argeo/in-house RPM packages. I've removed the Dell stuff
>>> completely, but the problem is still there.
>
>> Are you running out of memory and getting killed by the OOM killer?
>
>The OOM killer hits its victims with SIGKILL (kill -9), so we can rule
>that out as not matching Peter's symptoms.  This is definitely an
>unwanted SIGTERM not SIGKILL.
>
>			regards, tom lane
>




More information about the postgis-devel mailing list