Hmm, that seems to make sense. Given that Daylight Savings Time just ended, that might explain the reason why it got abandoned, since my slon procs run on a central/remote server<div><br></div><div>Leads me to a separate question: are there pros/cons to running the slon app on a remote server rather than on the local server? Seems like it makes administration easer--but at the cost of increased network traffic?</div>
<div><br></div><div>Do you have any insight to this?</div><div><br></div><div>--Richard<br><div><br><div class="gmail_quote">On Tue, Nov 9, 2010 at 2:38 PM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info">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;"><div><div></div><div class="h5">On 10-11-09 11:09 AM, Richard Yen wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi, does anyone know if slony ever "abandons" connections? I've had an<br>
idle transaction for the past 6 hours on one of my subscriber nodes,<br>
and according to my logs, the transaction was started, but there was<br>
never any action done in it, except to set the transaction level to<br>
serializable<br>
<br>
Odd thing is--the node is not lagging from the origin when I look at the<br>
origin's sl_status table<br>
<br>
Also, I don't know if this might be relevant, but the backend for the<br>
transaction has been open since 2010-11-01, and it's been processing<br>
plenty of transactions successfully up until this point<br>
<br>
How else can I diagnose this problem?<br>
--Richard<br>
<br>
</blockquote>
<br>
<br></div></div>
First I would determine which slon process the connection comes from (pg_stat_activity matched to the process id).<br>
<br>
If the slon is the 'local' to the slave database (that is, this is the slon servicing the node that is reporting the idle connection) then you need to figure out which thread the has stopped.<br>
<br>
Have you changed the time/date on your server recently?<br>
Do you see traffic in the logs from localListener, cleanupThread? the sync thread?<br>
<br>
<br>
If it is a remote connection, then what was the last thing that remote listener did.<br>
<br>
Slony doesn't normally abandon connections but it is possible something went wrong.<br>
<br>
<br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
_______________________________________________<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>
</blockquote>
<br>
</blockquote></div><br></div></div>