[Bucardo-general] slow swap sync debug?
Greg Sabino Mullane
greg at endpoint.com
Sun May 13 00:11:35 UTC 2012
On Fri, May 11, 2012 at 09:17:34AM -0400, Jonathan Brinkman wrote:
> I have a swap sync that should only take 3-4 seconds to run, but is WAITING
> for 30-45 seconds every time. This causes down-line problems as the user
> must wait that long, and thinks something is broken so they "try again"
> causing additional problems.
> Is there a way to debug a swap sync to see what is causing the delay?
> Using bucardo 4.4.8 ubuntu 10.04LTS postgresql 8.4
> Every second bucardo is sending a KICK to that sync, and the log.bucardo
> repeatedly replies that it can't add to q:
You can ignore those. What you need to do is look at the active KID and see
where it is spending all of its time. The KID in question should show
some timestamps that are 30-45 seconds apart.
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 163 bytes
Desc: not available
More information about the Bucardo-general