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
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 |