On 10-11-09 11:09 AM, Richard Yen wrote:
> Hi, does anyone know if slony ever "abandons" connections?  I've had an
> idle transaction for the past 6 hours on one of my subscriber nodes,
> and according to my logs, the transaction was started, but there was
> never any action done in it, except to set the transaction level to
> serializable
>
> Odd thing is--the node is not lagging from the origin when I look at the
> origin's sl_status table
>
> Also, I don't know if this might be relevant, but the backend for the
> transaction has been open since 2010-11-01, and it's been processing
> plenty of transactions successfully up until this point
>
> How else can I diagnose this problem?
> --Richard
>


First I would determine which slon process the connection comes from 
(pg_stat_activity matched to the process id).

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.

Have you changed the time/date on your server recently?
Do you see traffic in the logs from localListener, cleanupThread? the 
sync thread?


If it is a remote connection, then what was the last thing that remote 
listener did.

Slony doesn't normally abandon connections but it is possible something 
went wrong.





>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general