Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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

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

#0 0x00007f0cec7377c4 in __lll_lock_wait () from
#1 0x00007f0cec7325b4 in _L_lock_944 () from
#2 0x00007f0cec7323ca in pthread_mutex_lock () from
#3 0x00007f0ced10eaa0 in ?? () from /usr/lib/
#4 0x00007f0cebb31085 in engine_table_select () from
#5 0x00007f0cebb47228 in EVP_CipherInit_ex () from /lib/

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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group