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

Patch for LISTEN/NOTIFY race condition?

From: Meetesh Karia <meetesh(dot)karia(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Patch for LISTEN/NOTIFY race condition?
Date: 2008-04-22 18:25:30
Message-ID: 480E2D9A.4090004@gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi all,

After upgrading to 8.3 and Slony 1.2.13, one of our import processes 
started constantly failing because of deadlock.  Our import process 
(pl/pgsql function) just uses COPY FROM to populate a temp table and 
then inserts from that (without any special locks, etc).  And, the 
deadlock error showed that the import process was waiting on sl_event 
and a slon process was waiting on pg_listener.

I found the following thread in the archives: 
http://archives.postgresql.org/pgsql-bugs/2008-03/msg00117.php and it 
seemed like it could be the cause of the problem.

Is the patch available anywhere?  Also, if it will be available in 
8.3.2, is there any information on when that will be released?

Thanks and sorry if I missed this information posted somewhere,

Meetesh

Responses

pgsql-bugs by date

Next:From: Gary DoadesDate: 2008-04-22 19:04:02
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Previous:From: Stefan KaltenbrunnerDate: 2008-04-22 17:21:41
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does

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