[Bucardo-general] Replication stopped with Bucardo - no idea why

[Greg Sabino Mullane]

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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130912/842610b0/attachment.sig>