[Bucardo-general] Unable to add sync
David Christensen
david at endpoint.com
Mon Sep 16 16:35:06 UTC 2019
> On Sep 15, 2019, at 6:19 PM, Shepard, Ric (DFG) <ric.shepard at alaska.gov> wrote:
>
> I have been using Bucardo since 2008 (ver 4.0.3) for multi-master replication on production servers and have been frozen at version 4.5.0 since its release.
>
> Now, in attempting to upgrade to Bucardo 5.5.0, I am at a standstill.
>
> On PostgreSQL 9.6.15, with Bucardo 5.5.0, I am unable to create a sync. Period. I have uninstalled. Reinstalled. Checked versions of perl, DBI, DBD::Pg, DBIx::Safe, etc. I have tried every combination of specifying goats, herds, dbgroups, etc. All attempts at creating a sync result in:
>
> Failed to add sync: DBD::Pg::st execute failed: ERROR: DBD::Pg::st execute failed: ERROR: null value in column "targetdb" violates not-null constraint
> DETAIL: Failing row contains (4234640, null, Sun Sep 15 14:36:46.367424 2019 AKDT, dbgroup tsync). at line 828. at line 30.
> CONTEXT: PL/Perl function "validate_sync" at /usr/local/bin/bucardo line 4670.
>
> On a fresh Bucardo install:
>
> bucardo add db dutobs dbname=obsdata host=database_host1 port=5432
> Added database "dutobs"
>
> bucardo add db kodobs dbname=obsdata host=database_host2 port=5432
> Added database "kodobs"
>
> bucardo add all tables
> New tables added: 136
Just to confirm, this is in a totally new environment, so no old “bucardo” database it’s trying to reuse?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20190916/a776276e/attachment.sig>
More information about the Bucardo-general
mailing list