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

Michelle Sullivan michelle at sorbs.net
Tue Jun 22 17:23:18 UTC 2010


Michelle Sullivan wrote:
> Greg Sabino Mullane wrote:
>   
>>
>>> Bug?
>>>     
>>>       
>> Sure looks that way. Can you tell me the exact git revision you are using, 
>> or what line 5677 of Bucardo.pm is on your version? I can't tell from 
>> here exactly which execute is causing the problem.
>>
>>   
>>     
> How do I tell that...? (I'm an SVN girl ;-))
>
>                 if ($g->{does_target_makedelta}) {
>                     if
> ($sync->{does_target_makedelta_triggers}{$targetdb}) {
>                         $targetdbh->do(q{SET session_replication_role =
> 'origin'});
>                     }
>                     for (@tgtdelete2) {
> 5677:>>>>>                       
> $sth{target}{$g}{insertdelta}->execute($toid,@$_);
>                         $g->{target_makedelta_inserts}++;
>                         $self->glog("Adding in target bucardo_delta row
> (delete) for $toid and $_", 6);
>                     }
>
> __
I should add at this present moment I have:

aumaster
usmaster
backup_server

Where aumaster and usmaster are in sync, and backup_server is not...

To get them in sync I sent the following to the auserver:

delete from audit where pk = 114761246;
delete from evid2raw where rawid = 1 and evidid = 1;
delete from rawevidence where rawid = 1;
delete from nets2evid where evidid = 1 and netid = 1;
delete from networks where netid = 1;


My intention is to re-insert them if the deletion put the DBs back in
sync.....


Michelle


More information about the Bucardo-general mailing list