[Bucardo-general] Inserts when deleting?

Gabriel Weinberg yegg at alum.mit.edu
Tue May 3 06:44:39 UTC 2011

I'm new to bucardo so please excuse the possibly basic question. I've
searched through all the documentation and list archives and cannot find an

I have a pushdelta sync set up on one db to a dbgroup of 4 slaves. I tried
deleting a bunch of rows via DELETE FROM x WHERE ..... Watching the sync, it
showed a bunch of inserts in addition to the deletes and the slaves were
left with some rows matching the WHERE clause.

Confused, I backed up and tried something simpler. I added one row, and
watched it get added by the sync. Then I deleted that one row. The row was
deleted in the sync (verified on the slaves), but the log shows there was
one insert as well. There should only be the one delete. Why is that?

(21272) [Tue May  3 02:31:08 2011]  KID Finished syncing. Time: 1. Updates:
0 Inserts: 1 Deletes: 1 Sync: ddg_sync. Keepalive: 1

[root at flash ~]# bucardo_ctl status ddg_sync
Days back: 3  User: bucardo  Database: bucardo
Sync name:            ddg_sync
Current state:        idle (PID = 21270)
Type:                 pushdelta
Source herd/database: ddg / flash
Target group:         slaves (ec2,thor,tmbg,vpc)
Tables in sync:       2
Last good:            11m 45s (time to run: 1s)
Last good time:       May 03, 2011 02:31:08  Target: ec2
Ins/Upd/Del:          1 / 0 / 1
Last bad:             unknown
PID file:             /var/run/bucardo/bucardo.ctl.sync.ddg_sync.pid
PID file created:     Tue May  3 01:55:35 2011
Status:               active
Limitdbs:             0
Priority:             0
Checktime:            none
Overdue time:         00:00:00
Expired time:         00:00:00
Stayalive:            yes      Kidsalive: yes
Rebuild index:        0        Do_listen: no
Ping:                 yes      Makedelta: no
Onetimecopy:          0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110503/04db93a8/attachment.html 

More information about the Bucardo-general mailing list