Re: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11 - Mailing list pgsql-bugs

From Ran Ningyu
Subject Re: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11
Date
Msg-id 1334905313.57579.YahooMailNeo@web160601.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> > 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=

pgsql-bugs by date:

Previous
From: Gavin Flower
Date:
Subject: Re: BUG #6605: wrong type cast from timestamp to timestamptz
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6607: Strange select behavior