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

From: rnysmile(at)yahoo(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6578: Deadlock in libpq after upgrading from 8.4.7 to 8.4.11
Date: 2012-04-10 10:34:15
Message-ID: E1SHYOt-0004vu-08@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6578
Logged by: Deadlock in libpq
Email address: rnysmile(at)yahoo(dot)com
PostgreSQL version: 8.4.11
Operating system: Ubuntu 11.04
Description:

We wrote a C++ program using libpq to access postgres. it is a heavy load
service, about 100 concurrent postgres access. It works very well for two
years.

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.

gdb shows that everything is halt at libpq (100 threads halt at the same
position).

#0 0x00007f0cec7377c4 in __lll_lock_wait () from
/lib/x86_64-linux-gnu/libpthread.so.0
#1 0x00007f0cec7325b4 in _L_lock_944 () from
/lib/x86_64-linux-gnu/libpthread.so.0
#2 0x00007f0cec7323ca in pthread_mutex_lock () from
/lib/x86_64-linux-gnu/libpthread.so.0
#3 0x00007f0ced10eaa0 in ?? () from /usr/lib/libpq.so.5
#4 0x00007f0cebb31085 in engine_table_select () from
/lib/libcrypto.so.0.9.8
#5 0x00007f0cebb47228 in EVP_CipherInit_ex () from /lib/libcrypto.so.0.9.8

we tried to upgraded the libpq to 9.1.3, it will not deadlock but crash from
time to time.

After search the mailing list, we found someone else have the similar
problem:

http://archives.postgresql.org/pgsql-general/2011-03/msg00895.php

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Simon Willett 2012-04-10 11:01:29 Re: BUG #6204: Using plperl functions generate crash
Previous Message Amit Kapila 2012-04-10 06:15:25 Re: [BUGS] BUG #6522: PostgreSQL does not start