This is a multi-part message in MIME format.
--------------040003050008050605090407
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Thanks all ... I'm going to do some more digging and see if I can
isolate the problem.
Meetesh
Tom Lane wrote:
> Alvaro Herrera <alvherre@[EMAIL PROTECTED]
> writes:
>
>> Meetesh Karia wrote:
>>
>>> 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?
>>>
>
>
>> Hmm, AFAICS the patch should be present on 8.3.1, because it was tagged
>> on March 14th and the patch was committed on March 12.
>>
>
> Yes, but in any case (a) that's about a race condition not a deadlock,
> and (b) the issue has been there since forever, so it is unlikely to
> explain or fix a problem that you weren't seeing before 8.3.
>
> regards, tom lane
>
--------------040003050008050605090407
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">Thanks all ... I'm going to do
some more digging and see if I can isolate the problem.<br>
<br>
Meetesh<br>
</font></font><br>
Tom Lane wrote:
<blockquote cite="mid:27592.1208900353@[EMAIL PROTECTED]
" type="cite">
<pre wrap="">Alvaro Herrera <a class="moz-txt-link-rfc2396E"
href="mailto:alvherre@[EMAIL PROTECTED]
"><alvherre@[EMAIL PROTECTED]
>
writes:
</pre>
<blockquote type="cite">
<pre wrap="">Meetesh Karia wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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:
<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.
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?
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<pre wrap="">Hmm, AFAICS the patch should be present on 8.3.1, because
it was tagged
on March 14th and the patch was committed on March 12.
</pre>
</blockquote>
<pre wrap=""><!---->
Yes, but in any case (a) that's about a race condition not a deadlock,
and (b) the issue has been there since forever, so it is unlikely to
explain or fix a problem that you weren't seeing before 8.3.
regards, tom lane
</pre>
</blockquote>
</body>
</html>
--------------040003050008050605090407--
|
