Re: [GENERAL] Help debugging a hung postgresql client connection

2007-04-23 Thread Tom Lane
"Venkatraju T.V." <[EMAIL PROTECTED]> writes: > The backtrace for the postgresql backend process at that time: > (gdb) bt > #0 0x00321e6cc5e5 in recv () from /lib64/libc.so.6 > #1 0x005004f6 in secure_read (port=0xa0e0f0, ptr=0x7dc8c0, > len=8192) at /usr/include/bits/socket2.h:35 >

[GENERAL] Help debugging a hung postgresql client connection

2007-04-23 Thread Venkatraju T.V.
Hi, We have a Python application that spawns multiple threads the write the the database. We are seeing an intermittent problem where one of the threads will "block" seemingly for ever. We saw a similar problem twice with the same signature in a C++ based program as well (but that seems harder to