Re: Getting FATAL: terminating connection due to administrator command

From: Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: sergio(dot)segala(at)r3-gis(dot)com
Subject: Re: Getting FATAL: terminating connection due to administrator command
Date: 2010-09-16 15:30:52
Message-ID: 20100916153052.737701678216@mail.r3-gis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--------Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com> wrote--------
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to administrator command
Date: 16.09.2010 16:56

>--------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 17:40
>
>
>
>>Peter Hopfgartner <peter(dot)hopfgartner(at)r3-gis(dot)com> writes:
>
>>> --------Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote--------
>
>>>> This is a result of something sending SIGTERM to the backend process.
>
>>
>
>>> Can I trace where the SIGTERM comes from?
>
>>
>
>>If this is a recent Red-Hat-based release, I think that systemtap could
>
>>probably be used to determine that. There's a script here that solves
>
>>a related problem:
>
>>http://sourceware.org/systemtap/examples/process/sigmon.stp
>

Now we had the error, but systemtap did not report any SIGTERM. Is it possible to have this error without a SIGTERM being involved? As mentioned in a previous mail, I've modified the script to report SIGTERM sent to any process.

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-16 15:37:34 Re: Getting FATAL: terminating connection due to administrator command
Previous Message Christine Penner 2010-09-16 15:05:54 query join issue