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

From Andrea Grassi
Subject R: R: R: R: BUG #6342: libpq blocks forever in "poll" function
Date
Msg-id 002301ccbf3c$cc34b110$649e1330$@com
Whole thread Raw
In response to Re: R: R: R: BUG #6342: libpq blocks forever in "poll" function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: R: R: R: R: BUG #6342: libpq blocks forever in "poll" function
List pgsql-bugs
This is the server side stack kept by gdb:

(gdb) bt full
#0  0x00002b6488588ae5 in recv () from /lib64/libc.so.6
No symbol table info available.
#1  0x0000000000550cd2 in secure_read ()
No symbol table info available.
#2  0x00000000005563a4 in pq_recvbuf ()
No symbol table info available.
#3  0x00000000005567a7 in pq_getbyte ()
No symbol table info available.
#4  0x00000000005d33e6 in PostgresMain ()
No symbol table info available.
#5  0x00000000005a9708 in ServerLoop ()
No symbol table info available.
#6  0x00000000005aa2b7 in PostmasterMain ()
No symbol table info available.
#7  0x00000000005580be in main ()
No symbol table info available.

The netstat command on client and server connection has this output:
The first line should be the server, the second the client.

Proto Recv-Q Send-Q Local Address           Foreign Address         State
PID/Program name
tcp        0      0 127.0.0.1:5432          127.0.0.1:53129
ESTABLISHED -
tcp       48      0 127.0.0.1:53129         127.0.0.1:5432
ESTABLISHED 29802/g_mrprun.e


Regards, Andrea

-----Messaggio originale-----
Da: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
Inviato: marted=EC 20 dicembre 2011 17.38
A: Andrea Grassi
Cc: harrywr2@comcast.net; 'Craig Ringer'; 'Pg Bugs'; 'Alvaro Herrera'
Oggetto: Re: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll"
function=20

"Andrea Grassi" <andreagrassi@sogeasoft.com> writes:
> #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

What about a stack trace from the connected server process?  libpq
clearly thinks it's waiting for a message from the server, but I wonder
what the server thinks.  Also, what connection status does netstat
show on each side?

            regards, tom lane

pgsql-bugs by date:

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