> On Sep 24, 2018, at 12:19 PM, Paul Tader <[email protected]> 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 [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
