[Bucardo-general] duplicate key value violates unique constraint "bucardo_sequences_tablename"

Jonathan Brinkman jb at blackskytech.com
Sat Aug 10 03:06:24 UTC 2013


Trying to make a push-delta go to two slaves. 

Getting this error when making a change in the master. The update succeeds
in the first slave, but fails in the second.

Can you point me towards a fix?

Thank you!



>From log.bucardo:


DBI::db=HASH(0xa0bdd24)->disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at /usr/local/share/perl/5.14.2/Bucardo.pm line 3590.

[Fri Aug  9 22:50:05 2013]  KID Marking as done in the q table, notifying

[Fri Aug  9 22:50:05 2013]  KID Finished syncing to cmsfgcc_gate2. Time: 0.
Updates: 0 Inserts: 1 Deletes: 1 Sync: cmsfgcc_pushdelta_main_to_gate2.
Keepalive: 1

[Fri Aug  9 22:50:05 2013]  KID Final database backend PID is 26689

[Fri Aug  9 22:50:05 2013]  KID Kid exiting at cleanup_kid. Reason:
DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique
constraint "bucardo_sequences_tablename"

DETAIL:  Key (tablename)=(17814) already exists. at
/usr/local/share/perl/5.14.2/Bucardo.pm line 4450.



They were originally created with these commands:


bucardo_ctl add herd cmsfgcc_gate1_to_main 

bucardo_ctl add table clientdata.clearanceevents herd=cmsfgcc_gate1_to_main

bucardo_ctl add sync cmsfgcc_pushdelta_gate1_to_main
source=cmsfgcc_gate1_to_main targetdb=cmsfgcc_main type=pushdelta 

bucardo_ctl add herd cmsfgcc_gate2_to_main 

bucardo_ctl add table clientdata.clearanceevents herd=cmsfgcc_gate2_to_main

bucardo_ctl add sync cmsfgcc_pushdelta_gate2_to_main
source=cmsfgcc_gate2_to_main targetdb=cmsfgcc_main type=pushdelta 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130809/6341a1bc/attachment.html>

More information about the Bucardo-general mailing list