[Slony1-general] sl_log_1 is no longer empty

Steve Singer steve at ssinger.info
Wed Nov 29 18:58:45 UTC 2023


On Mon, 27 Nov 2023, Sebastien Marchand via Slony1-general wrote:

> Hello,
> I have a problem that I've just noticed on several of my replications, 
> my sl_log_1 table no longer empties and keeps incrementing. Where should 
> I look to find the event that breaks the function that's supposed to 
> manage the truncate?

The cleanupEvent handles cleaning up the sl_log tables which slon calls

Is replication to a node behind?
Do you have a subscriber/node that is out of date/abandoned/dropped
Do you have a long running transaction on the system?
Is there a problem getting the confirms floating back from the replica to 
the other nodes?



Steve



> Thanks for your help.
> Sincerely,
> Sébastien Marchand
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> https://lists.slony.info/cgi-bin/mailman/listinfo/slony1-general
>


More information about the Slony1-general mailing list