On Thu, Sep 12, 2013 at 09:35:42PM +0200, Torbjørn Kristoffersen wrote: > We got about 50 tables replicated with Bucardo - two masters running > PostgreSQL 9.3 > > I don't understand what's going on now, and I can't see anything in the > logs that stands out from what has been going on when things worked 100%. > > Apparently some table has received quite a few thousand updates, perhaps > 50000 new or updated records, and after this Bucardo doesn't seem to > replicate anymore. ... > [Thu Sep 12 21:20:55 2013] KID Target delta count for > public.activities_persons_users: 382900 > > That's quite a high delta but not really uncommon for that specific table.
It might simply be that replication is taking a really long time, and is not stopped. Try turning on PIDS in the log (set log_showpid true), and then trace the KID that has a bunch of those deltas. I suspect you will find it is there and working on parsing that huge chunk of rows. If it's not that, at least you can find out the last action that the KID in question performed. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
