Re: Getting FATAL: terminating connection due to administrator command
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@sss.pgh.pa.us> wrote--------
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to administrator command
Date: 15.09.2010 21:34
Show quoted text
"Joshua J. Kugler" <joshua@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