Re: Getting FATAL: terminating connection due to administrator command - Mailing list pgsql-general

From Peter Hopfgartner
Subject Re: Getting FATAL: terminating connection due to administrator command
Date
Msg-id 20101014123958.D22F51678227@mail.r3-gis.com
Whole thread Raw
List 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@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@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
>


pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Adding a New Column Specifically In a Table
Next
From: "Reuven M. Lerner"
Date:
Subject: Re: Passing refcursors between pl/pgsql functions