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]
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
