I also have a client suffering an occasional 'application hang' running
Suse 11.2 and postgressql 8.4 on an 8 core box which is not reproducable
in a VMWare test environment.
Access to postgres is libpq 127.0.0.1 as well. Unfortunately the client
must restart ASAP and I have not produced a 'test case'.
On 12/20/2011 1:01 AM, Andrea Grassi wrote:
Sorry if I insist, but now I have the case at hand (my test program is now
blocked), so I can check and verify all what you want.
I would like to know if it can be a libpq bug or if you think the fault is due
to a system bug or to a machine issue and in this case I would be grateful if
you could give me a hint on what could be.
Regards, Andrea
-----Messaggio originale-----
Da: Craig Ringer [mailto:ring...@ringerc.id.au]
Inviato: sabato 17 dicembre 2011 7.19
A: Andrea Grassi
Cc: pgsql-bugs@postgresql.org
Oggetto: Re: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function
On 16/12/2011 10:10 PM, Andrea Grassi wrote:
The client program and the postgres server are on the same host, client
connects to 127.0.0.1.
In the meantime, my original program blocks (not my example but very probably
the reasons are the same).
I typed "ps -C testprogramname -o wchan:80=" and the output was only a single dash (
"-" ).
That means it's not waiting in a kernel call right now. Was the program
in the hung state you've observed at the time you ran the command? Its
output would only be interesting when it's hung.
I searched for the complete stack in /proc/$pid/stack (where $pid) was the pid
of my process but this file doesn't exists !! Why ?
Old kernel, maybe? You're running on some kind of enterprise-y distro,
so who knows how ancient half the stuff in there is.
--
Craig Ringer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs