Patch for LISTEN/NOTIFY race condition? - Mailing list pgsql-bugs

From Meetesh Karia
Subject Patch for LISTEN/NOTIFY race condition?
Date
Msg-id 480E2D9A.4090004@gmail.com
Whole thread Raw
Responses Re: Patch for LISTEN/NOTIFY race condition?
List 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

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Next
From: Gary Doades
Date:
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does