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

"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
> #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