This is a multi-part message in MIME format.
--------------080509090603090907000701
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Hi all,
After upgrading to 8.3 and Slony 1.2.13, one of our im****t processes
started constantly failing because of deadlock. Our im****t 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 im****t 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
--------------080509090603090907000701
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">Hi all,<br>
<br>
After upgrading to 8.3 and Slony 1.2.13, one of our im****t processes
started constantly failing because of deadlock. Our im****t 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 im****t process was waiting on sl_event
and a slon process was waiting on pg_listener.<br>
<br>
I found the following thread in the archives:
<a class="moz-txt-link-freetext"
href="http://archives.postgresql.org/pgsql-bugs/2008-03/msg00117.php">http://archives.postgresql.org/pgsql-bugs/2008-03/msg00117.php</a>
and it
seemed like it could be the cause of the problem.<br>
<br>
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?<br>
<br>
Thanks and sorry if I missed this information posted somewhere,<br>
<br>
Meetesh<br>
</font></font>
</body>
</html>
--------------080509090603090907000701--
|
