R: R: R: BUG #6342: libpq blocks forever in "poll" function - Mailing list pgsql-bugs

From Andrea Grassi
Subject R: R: R: BUG #6342: libpq blocks forever in "poll" function
Date
Msg-id 001701ccbf34$72480970$56d81c50$@com
Whole thread Raw
In response to Re: R: R: BUG #6342: libpq blocks forever in "poll" function  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: R: R: R: BUG #6342: libpq blocks forever in "poll" function
List pgsql-bugs
You wrote:

> I also have a client suffering an occasional 'application hang' running S=
use 11.2 and postgressql 8.4=20
> on an 8 core box which is not reproducable in a VMWare test environment.=
=20
> Access to postgres is libpq 127.0.0.1 as well.=20
> Unfortunately the client must restart ASAP and I have not produced a 'tes=
t case'.

But you examined the stack ? It's similar to mine ?

#0  0xffffe410 in __kernel_vsyscall ()
No symbol table info available.
#1  0xf76539cb in poll () from /lib/libc.so..
#2  0xf770d39a in pqSocketCheck () from /home/pg/pgsql/lib-32/libpq.so.5=20
#3  0xf770d49d in pqWaitTimed () from /home/pg/pgsql/lib-32/libpq.so.5=20
#4  0xf770d513 in pqWait () from /home/pg/pgsql/lib-32/libpq.so.5=20
#5  0xf770c6d6 in PQgetResult () from /home/pg/pgsql/lib-32/libpq.so.5=20
#6  0xf770c89c in PQexecFinish () from /home/pg/pgsql/lib-32/libpq.so.5=20

Can you specify the details of hardware and platform of your machine to und=
erstand if it can have something in common with the mine and so to understa=
nd the reason/origin of the bug?=20
Thanks.

Andrea

pgsql-bugs by date:

Previous
From: "Andrea Grassi"
Date:
Subject: R: R: R: BUG #6342: libpq blocks forever in "poll" function
Next
From: Tom Lane
Date:
Subject: Re: R: R: R: BUG #6342: libpq blocks forever in "poll" function