Re: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11

> > This month, we upgrade the libpq5 from=A0 8.4.7 to 8.4.11.(libpq-dev

> > 8.4.11-0ubuntu0.11.04) Our service program become unstable after upgrad=
ing.

> > After search the mailing list, we found someone else have the similar
> > problem:
> > http://archives.postgresql.org/pgsql-general/2011-03/msg00895.php=20

> I can't help observing that that person is also using ubuntu, and that
> we have not heard similar complaints from anybody else.=A0 Ubuntu-specific
> glibc bug perhaps?=A0 A slightly different theory is an ubuntu-specific
> openssl bug; if there were something wrong in the internal locking
> in libcrypto, it could well lead to a backtrace like this.

Thank you for you advice. We move back from Ubuntu 11.04 x64 to Ubuntu 10.0=
4 x64, but the problem still exist.

We finally FIX that deadlock by install a older version of openssl using th=
e following command

apt-get install libssl0.9.8=3D0.9.8k-7ubuntu8

Our program=A0 runs 6 Days 21:55:30 till now without any problem.

The conclusion is :

Deadlock bug in openssl version 0.9.8k-7ubuntu8.10, newer version of ubuntu=
 (we tested 11.04, 11.10) still have this bug.
The working version of openssl is 0.9.8k-7ubuntu8=