[Bucardo-general] Validate_sync error while adding new sync
simocsab at gmail.com
Fri Feb 15 19:38:44 UTC 2013
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.
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?
> 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...
More information about the Bucardo-general