[Bucardo-general] Residual records in bucardo.bucardo_delta!?

[Greg Sabino Mullane]

> Is this a known issue? I can provide more information if someone could guide me through this.

Yes, this is a known issue. Still not solved yet, but it's definitely the 
doubled entries that are causing the problem. It's usually caused by multiple 
updates to the same table within the same transaction. I don't recall 
the exact issue of the top of my head, but the bucardo_purge_delta function 
has some underlying assumption that one there is one entry in bucardo_delta 
for a transaction, a table, and a primary key. And that bucardo_track has a 
single txntime entry per remote target, e.g. matching the number in the 
bucardo_delta_targets table. Said assumptions wrong with multiple updates 
of course.

Until someone fixes this, you can manually clear those out by simply removing 
all entries older than a certain date for that table, where "certain date" is 
older than the last known successful sync.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110623/13b6816d/attachment.bin