Re: Getting FATAL: terminating connection due to administrator command

From: Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com>
To: postgis-devel(at)postgis(dot)refractions(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting FATAL: terminating connection due to administrator command
Date: 2010-10-14 12:39:58
Message-ID: 20101014123958.D22F51678227@mail.r3-gis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)pgh(dot)pa(dot)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(dot)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
>

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-10-14 13:17:22 Re: Copying data files to new hardware?
Previous Message Thom Brown 2010-10-14 12:20:23 Re: Adding a New Column Specifically In a Table