[Bucardo-general] Bucardo problem with Kids

Ben Allen bsa at lanl.gov
Thu Apr 23 01:22:50 UTC 2009


Can you copy and paste the statements you added to your bucardo  
database to setup the sync? Otherwise all I can say is make sure you  
did all the steps in the Bucardo documentation.

Ben

On Apr 22, 2009, at 1:16 PM, Stevens.Lebas wrote:

> Hi Ben,
>
> I've just two little database to test  with only one table with only
> two column (Table 'user' with column generated oid and column 'name').
>
> The target database contains no user, but when i add user in source
> database, nothing happened,only controller add new line in table q.
>
> All request of type
>
> "UPDATE bucardo.q
> SET    started=timeofday()::timestamptz, pid = ?
> WHERE  sync=?
> AND    targetdb=?
> AND    started IS NULL"
>
> always return 0 (in table q there is matched row).
> When i delete 'started is null', update return not 0.
>
> When a 'is null' is done on column text,time... (not on integer
> column,that's fine),result of update was 0.
>
> Thank you for your help,
>
> Stevens
>
> 2009/4/22, Ben Allen <bsa at lanl.gov>:
>> Is there actually any new data on either side of the of the sync to  
>> be
>> copied over? Usually this message means, as long as everything is
>> setup correct, quite literal there's nothing for Bucardo to do.
>>
>> Ben
>>
>> On Apr 22, 2009, at 11:01 AM, Stevens.Lebas wrote:
>>
>>> Hello,
>>>
>>> i'm trying to replicate two databases with bucardo. Bucardo is  
>>> launch
>>> and bucardo database is correctly filled. When i change a column in
>>> table to replicate, CTL detected but KID do nothing. Table q is  
>>> filled
>>> by Controller, but kids do nothing.
>>>
>>> When i stop bucardo and restart it, KID says "Nothing to do: no  
>>> entry
>>> found in the q table for this sync", but table q is filled. After
>>> investigation, that's come from line 3682 in file Bucardo.pm on
>>> request "qsetstart".
>>> This update return already 0E0 in variable $count.
>>>
>>> So i try to modify the request and problem come from 'started is
>>> null'. When i delete this,the update return a value different from  
>>> 0.
>>>
>>> I do a perl script with this request an DBD::pg, and it's ok.
>>> Perhaps the DBIx::Safe?
>>>
>>> Has someone an idea ?
>>>
>>> Thanks,
>>>
>>> Best regards,
>>>
>>> Stevens
>>> _______________________________________________
>>> Bucardo-general mailing list
>>> Bucardo-general at bucardo.org
>>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>>
>>



More information about the Bucardo-general mailing list