Обсуждение: Re: Getting FATAL: terminating connection due to administrator command

Поиск
Список
Период
Сортировка

Re: Getting FATAL: terminating connection due to administrator command

От
Peter Hopfgartner
Дата:
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
>