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:t...@sss.pgh.pa.us] Inviato: martedì 20 dicembre 2011 17.38 A: Andrea Grassi Cc: harry...@comcast.net; 'Craig Ringer'; 'Pg Bugs'; 'Alvaro Herrera' Oggetto: Re: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function "Andrea Grassi" <andreagra...@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 > #3 0xf770d49d in pqWaitTimed () from /home/pg/pgsql/lib-32/libpq.so.5 > #4 0xf770d513 in pqWait () from /home/pg/pgsql/lib-32/libpq.so.5 > #5 0xf770c6d6 in PQgetResult () from /home/pg/pgsql/lib-32/libpq.so.5 > #6 0xf770c89c in PQexecFinish () from /home/pg/pgsql/lib-32/libpq.so.5 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs