[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