From: | Brian Wipf <brian(at)clickspace(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unsuccessful SIGINT |
Date: | 2006-12-02 00:54:56 |
Message-ID: | F78F5E1F-9510-40A7-AA8A-22EF4DBC1017@clickspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry, I forgot to mention this is on PostgreSQL 8.1.5. The server is
SUSE Linux 10.1, the client is OS X Server 10.4.8.
On 1-Dec-06, at 5:42 PM, Brian Wipf wrote:
> I have a connection that I am unable to kill with a sigint.
>
> ps auxww for the process in question:
> postgres 3578 0.3 3.6 6526396 1213344 ? S Dec01 0:32
> postgres: postgres ssprod 192.168.0.52(49333) SELECT
>
> and gdb shows:
> (gdb) bt
> #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 ()
> #5 0x000000000043e37a in printtup ()
> #6 0x00000000004e9349 in ExecutorRun ()
> #7 0x0000000000567931 in PortalRunSelect ()
> #8 0x00000000005685f0 in PortalRun ()
> #9 0x0000000000565ea8 in PostgresMain ()
> #10 0x0000000000540624 in ServerLoop ()
> #11 0x000000000054131a in PostmasterMain ()
> #12 0x000000000050676e in main ()
>
> lsof on the client machine (192.168.0.52) shows no connections on
> port 49333, so it doesn't appear to be a simple matter of killing
> the client connection. If I have to, I can reboot the client
> machine, but this seems like overkill and I'm not certain this will
> fix the problem. Anything else I can try on the server or the
> client short of restarting the database or rebooting the client?
>
> Brian Wipf
> <brian(at)clickspace(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | a | 2006-12-02 01:09:36 | Highload website database architecture |
Previous Message | Brian Wipf | 2006-12-02 00:42:29 | Unsuccessful SIGINT |