From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Sean Chittenden <sean(at)chittenden(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_stat_get_backen_last_activity() ??? |
Date: | 2003-04-23 22:52:13 |
Message-ID: | 8989.1051138333@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sean Chittenden <sean(at)chittenden(dot)org> writes:
> (gdb) bt
> #0 0x283d0c58 in recvfrom () from /usr/lib/libc.so.4
> #1 0x283c092b in recv () from /usr/lib/libc.so.4
> #2 0x80f11c6 in secure_read ()
> #3 0x80f4557 in StreamConnection ()
> #4 0x80f4935 in pq_getbyte ()
> #5 0x81377b0 in PostgresMain ()
> #6 0x811a63c in PostmasterMain ()
> #7 0x8119e5b in PostmasterMain ()
> #8 0x811934b in PostmasterMain ()
> #9 0x8118e94 in PostmasterMain ()
> #10 0x80f53d7 in main ()
> #11 0x8069b3e in _start ()
> Any ideas on how I can figure out what the mystery query/app/lib is
> that's causing my backend to hang with a zillion connections that are
> all idle?
Well, that particular backend is not hung: the stack trace proves it's
waiting for a command from its frontend. Perhaps you need to look
through your other Postgres processes.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Chittenden | 2003-04-23 23:20:23 | Re: pg_stat_get_backen_last_activity() ??? |
Previous Message | Ron Johnson | 2003-04-23 22:13:04 | Backing up 16TB of data (was Re: > 16TB worth of data question) |