[Bucardo-general] Validate_sync error while adding new sync

[Csaba Simon]

You were right, old Bucardo database stuff caused the problem. I dropped
bucardo schema in master db and dropped bucardo database, then I reran
bucardo install and now it works!

Thanks for your tip.

Csaba

On 15 February 2013 20:18, Csaba Simon <simocsab at gmail.com> wrote:

> Oh, I might really import an old bucardo schema with the master database.
> What can I do know? Should I drop the old bucardo schema and rerun bucardo
> install? Should I drop the bucardo database too?
>
> Csaba
>
> On 15 February 2013 19:59, Greg Sabino Mullane <greg at endpoint.com> wrote:
>
>> On Fri, Feb 15, 2013 at 07:08:39PM +0100, Csaba Simon wrote:
>> > CONTEXT:  SQL statement "SELECT validate_sync('sync_b2infra_b2kma')"
>> > Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl
>> > function "validate_sync": error from Perl function "validate_sync":
>> > DBD::Pg::st execute failed: ERROR:  null value in column "targetdb"
>> > violates not-null constraint at line 432. at line 30. at
>> > /usr/local/bin/bucardo line 3865.
>>
>> Odd - there is no longer a 'targetdb' column in Bucardo. Could you have
>> some older Bucardo stuff around?
>>
>> --
>> Greg Sabino Mullane greg at endpoint.com
>> End Point Corporation
>> PGP Key: 0x14964AC8
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130215/6a3690bc/attachment.html>