Richard Yen dba at richyen.com
Tue Nov 9 08:09:13 PST 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101109/24fcc0bb/attachment.htm 


More information about the Slony1-general mailing list