[Bucardo-general] Which way does the sync run?

[David Christensen]

> On Sep 24, 2018, at 12:19 PM, Paul Tader <ptader at spoton.com> wrote:
> 
> Just checking. Burcardo is running but I see some concerning messages in the logs likes it’s modifying or deleting data in the source database. The source database is called “qaec2” and the destination is called “qards”
> 
> I see these messages in the bucardo logs while its running. Should I be concerned?
> 
> ...
> (1946) [Mon Sep 24 17:11:38 2018] KID (qasync) Deleting from target qaec2.db.table_name (round 140 of 141)
> (1946) [Mon Sep 24 17:11:38 2018] KID (qasync) Deleting from target qaec2.db.table_name (round 141 of 141)
> (1946) [Mon Sep 24 17:11:38 2018] KID (qasync) Rows deleted from qaec2.db.table_name: 1126007
> 

Deleting in a target is normal behavior for either source deletions or updates; basically any rows that Bucardo has noted in the delta tables will be attempted be deleted in the target with any existing source versions copied over afterwards.  Since it does these in a single transaction this will be an atomic action so the target will end up with the rows inserted/updated in the source actions and will remove any of the ones deleted.

If there has been a batch update or delete that would have touched that many rows there is no cause for concern.

Best,

David
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180924/08d76f9a/attachment.sig>