Marc Munro wrote:
> Often, when we get short-lived network problems (like when our network
> admins break the firewall), postgres client apps will lock-up. They do
> not recover once the network is back to normal, do not time-out, and do
> not fail with any sort of error.
>
> This has been happening since at least postgres 7.4.7. We are currently
> running 8.0.3 (now upgrading to 8.0.8).
>
> As near as we can tell, it looks like libpq blocked inside poll inside
> libpq_gettext.
>
> #0 0xffffe405 in __kernel_vsyscall ()
> #1 0x005a31d4 in poll () from /lib/tls/libc.so.6
> #2 0xf7fd71ff in libpq_gettext () from /usr/lib/libpq.so.3
> #3 0xf7fd7331 in pqWaitTimed () from /usr/lib/libpq.so.3
Wow, that's strange. Maybe it's trying to fetch something in the
message catalogs. What are your locale settings?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
