[Bucardo-general] Master-Master->slave working?

[Michelle Sullivan]

Greg Sabino Mullane wrote:
>> I have setup a master-master and master-slave replication set with 3
>> servers.
>>     
> ...
>   
>> Checking the DBs the aumaster <-> usmaster replication worked no
>> problem, but it appears nothing happened with usmaster -> backup_server
>>     
>
> You must turn "makedelta" on, so that rows coming from aumaster to the 
> usmaster are put into the bucardo_delta table and can thus be moved 
> on to the backup_server. You can do this at the database level:
>
> bucardo_ctl update db usmaster makedelta=on
>
> or at the sync level:
>
> bcuardo_ctl update sync sorbs2_swap target_makedelta=on
>
>
>   
Great, thank you very much.

When I get time I'm going to write up some doco for this - the current
doco is not easy to find, so I'm thinking a howto with 3-4 (real word)
examples might be in order
.

...

That said...

[Tue Jun 22 11:42:06 2010]  KID New kid, syncs "usmaster" to
"backup_server" for sync "sorbs2_delta" alive=1 Parent=88342
Type=pushdelta PID=88346
[Tue Jun 22 11:42:06 2010]  KID New kid, syncs "aumaster" to "usmaster"
for sync "sorbs2_swap" alive=1 Parent=88343 Type=swap PID=88347
[Tue Jun 22 11:53:25 2010]  KID Source delta count for public.evid2raw: 1
[Tue Jun 22 11:53:27 2010]  KID Source delta count for public.audit: 1
[Tue Jun 22 11:53:27 2010]  KID Source delta count for public.nets2evid: 1
[Tue Jun 22 11:53:28 2010]  KID Source delta count for public.networks: 1
[Tue Jun 22 11:53:29 2010]  KID Source delta count for public.rawevidence: 1
[Tue Jun 22 11:53:34 2010]  KID Source delta count for public.changes: 1
DBI::db=HASH(0x803998228)->disconnect invalidates 5 active statement
handles (either destroy statement handles or call finish on them before
disconnecting) at /usr/local/lib/perl5/site_perl/5.10.1/Bucardo.pm line
3663.
[Tue Jun 22 11:53:34 2010]  KID Kid exiting at cleanup_kid. Sync
"sorbs2_swap", Target "usmaster" public.evid2raw pk: 1|1 Reason:
DBD::Pg::st execute failed: called with 1 bind variables when 3 are
needed at /usr/local/lib/perl5/site_perl/5.10.1/Bucardo.pm line 5677.
 main error: none source error: none target error: -1 States://
[Tue Jun 22 11:53:36 2010]  CTL Rows updated child 88347 to aborted in q: 1
[Tue Jun 22 11:53:36 2010]  CTL Warning! Kid 88347 seems to have died.
Sync "sorbs2_swap"


Bug?

Michelle