<div dir="ltr">Wow, Thanks a lot, that bug definitely what we experience. Will prepare for upgrade.</div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 17, 2015 at 8:40 PM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 04/16/2015 11:44 PM, Soni M wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello All,<br>
2 nodes configured for slony 2.0.7, on RHEL 6.5 using postgres 9.1.14.<br>
Each slon manage local postgres.<br>
Slony and RHEL installed from postgres yum repo.<br>
<br>
</blockquote>
<br></span>
Slony 2.0.x is no longer supported and was never properly supported against PG 9.1 +. You should upgrade to 2.2<br>
<br>
Your issue looks a lot like bug 258 (<br>
<a href="http://www.slony.info/bugzilla/show_bug.cgi?id=258" target="_blank">http://www.slony.info/bugzilla/show_bug.cgi?id=258</a>) which was fixed in the 2.1 and 2.2 series.<br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
On some occasion, on master db, the cleanupEvent last for long time, up<br>
to 5 minutes, normally it finish for a few seconds. The 'truncate<br>
sl_log_x' is waiting for a lock which takes most time. This make all<br>
write operation to postgres have to wait also, some get failed. As I<br>
inspected, what makes truncate wait is another slon transaction made by<br>
slon slave process, that is transaction which run 'fetch 500 from LOG'.<br>
This transaction left 'idle on transaction' for a long time on some<br>
occasion.<br>
<br>
Why is this happen ? Is this due to network latency between nodes ? Is<br>
there any work around for this?<br>
<br>
Many thanks, cheers...<br>
<br>
--<br>
Regards,<br>
<br>
Soni Maula Harriz<br>
<br>
<br></span>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br>
</blockquote>
<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div></div>
</div>