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

From: Ran Ningyu <rnysmile(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11
Date: 2012-04-20 07:01:53
Message-ID: 1334905313.57579.YahooMailNeo@web160601.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

> > 8.4.11-0ubuntu0.11.04) Our service program become unstable after upgrading.

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

> I can't help observing that that person is also using ubuntu, and that
> we have not heard similar complaints from anybody else.  Ubuntu-specific
> glibc bug perhaps?  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.04 x64, but the problem still exist.

We finally FIX that deadlock by install a older version of openssl using the following command

apt-get install libssl0.9.8=0.9.8k-7ubuntu8

Our program  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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ljwilson 2012-04-20 15:23:07 Re: BUG #6204: Using plperl functions generate crash
Previous Message Peter Eisentraut 2012-04-19 20:15:39 Re: BUG #6602: concurrent psql session clobbers history