Unsuccessful SIGINT

From: Brian Wipf <brian(at)clickspace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Unsuccessful SIGINT
Date: 2006-12-02 00:42:29
Message-ID: 217F2C8A-D097-4845-8F0B-E3011809A0A4@clickspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Wipf 2006-12-02 00:54:56 Re: Unsuccessful SIGINT
Previous Message Derrick Stensrud 2006-12-01 23:21:57 best way to setup raid array in this situation