[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
Greetings
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!
Jonathan
>From log.bucardo:
[LOG]
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
controller
[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.
[/LOG].
They were originally created with these commands:
[CODE]
bucardo_ctl add herd cmsfgcc_gate1_to_main
bucardo_ctl add table clientdata.clearanceevents herd=cmsfgcc_gate1_to_main
db=cmsfgcc_gate1
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
db=cmsfgcc_gate2
bucardo_ctl add sync cmsfgcc_pushdelta_gate2_to_main
source=cmsfgcc_gate2_to_main targetdb=cmsfgcc_main type=pushdelta
[/CODE]
-------------- 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