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 ( "-" ).
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 ?
I'm waiting for my example to block in order to send you what you request me about the test program (even if the output almost surely will be the same).
Da: Craig Ringer [mailto:ringerc(at)ringerc(dot)id(dot)au]
Inviato: venerdì 16 dicembre 2011 9.24
Oggetto: Re: [BUGS] BUG #6342: libpq blocks forever in "poll" function
On 12/16/2011 03:45 PM, andreagrassi(at)sogeasoft(dot)com wrote:
> The following bug has been logged on the website:
> Bug reference: 6342
> Logged by: Andrea Grassi
> Email address: andreagrassi(at)sogeasoft(dot)com
> PostgreSQL version: 8.4.8
> Operating system: SUSE SLES 10 SP4 64 BIT
> I have a big and strange problem. Sometimes, libpq remains blocked in “poll”
> function even if the server has already answered to the query. If I attach
> to the process using kdbg I found this stack:
> poll() from /lib/libc.so.6
Given all you described (thanks for all the detail!) then if client and
server are on different hosts this could easily be a NIC driver or HW
issue. It'd be interesting to see the output of:
ps -C testprogramname -o wchan:80=
In response to
pgsql-bugs by date
|Next:||From: kojiro||Date: 2011-12-16 15:33:18|
|Subject: BUG #6343: PGTYPES library missing qualifiers|
|Previous:||From: Pavel Holec||Date: 2011-12-16 13:21:43|
|Subject: Re: user names & non-ASCII|