[Bucardo-general] Long delay before changes on remote master propogate to local

[Greg Sabino Mullane]

On Thu, Sep 19, 2013 at 12:59:55PM -0700, Paul Theodoropoulos wrote:
> Eliding lots of repetitious log output, the times are bothersome:
> 
> start Bucardo:
> (23733) [Thu Sep 19 12:12:02 2013] MCP Starting Bucardo version 5.0.0
> Almost ten minutes later, Bucardo begins inspecting the local db
> groups on one dbgroup:
> (23734) [Thu Sep 19 12:21:31 2013] MCP   Inspecting source table
> "public.alarm_notification_history" on database "local_trumgr_group"
> Bucardo goes quiet again, then begin inspecting another dbgroup
> seven minutes later:

Yeah, that's pretty extreme. Even with an insane number of tables 
and/or columns and/or targets, it should not be taking that long. 
So Bucardo is doing nothing at all for those first ten minutes according 
to the logs? Can you check the database logs and see if there is any 
query that might be extra-long running or blocked? Barring that, you might 
try stracing the MCP process during those gaps and seeing if you can figure 
out exactly what it is doing.

-- 
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/20130922/face6925/attachment.sig>