[Bucardo-general] recovering from failed swap sync
Greg Sabino Mullane
greg at endpoint.com
Wed Aug 28 03:09:16 UTC 2013
> How can I determine why Bucardo thinks there's a conflict and,
> more importantly, resolve the conflict without issue?
The bucardo logs should be telling you the offending row. You could try
and find it manually by looking at the bucardo_delta table and grabbing
all the pkeys for the offending table. Do this on both sides and compare
the numbers to find the overlap.
> The row that's causing the conflict existed only on the source side.
> The remote side did not have this row. In an attempt to resolve this,
> I manually inserted the row on the target side.
If I am understanding this correctly, you probably need to remove the
bucardo_delta record manually, probably from the target side. As well
as remove that manually inserted row. At the end of the day, only one
server should mention that pkey, both at the bucardo_delta level and
in the table itself.
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general