From: | Brian Wipf <brian(at)clickspace(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unsuccessful SIGINT - More Info |
Date: | 2006-12-02 16:32:31 |
Message-ID: | CBBACA86-F20C-49BC-A352-E6C186EC4326@clickspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2-Dec-06, at 6:27 AM, Martijn van Oosterhout wrote:
> On Fri, Dec 01, 2006 at 08:26:53PM -0700, Brian Wipf wrote:
>> Now I know the cause at least. If anyone has an idea on how to kill a
>> similar hung connection without rebooting the server, I would
>> appreciate any suggestions.
>
> I'm unsure about why it wouldn't respond to a sigint, but did you try
> try stronger signals?
I tried a SIGHUP, SIGINT and SIGQUIT.
Do you believe a postgres process in the following:
#0 0x00002ba62c18f085 in send () from /lib64/libc.so.6
#1 0x0000000000504765 in internal_flush ()
#2 0x0000000000504896 in internal_putbytes ()
#3 0x00000000005048fc in pq_putmessage ()
#4 0x0000000000505ea4 in pq_endmessage ()
...
is listening for some other signal? I, of course, didn't try a
SIGKILL. This is a production database.
Brian Wipf
<brian(at)clickspace(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-12-02 19:01:18 | Re: 8.1.5 installation problem with initdb on WinXP Home |
Previous Message | Ragnar | 2006-12-02 15:30:14 | Re: Data corruption problem... |