[Bucardo-general] Unable to add sync
Shepard, Ric (DFG)
ric.shepard at alaska.gov
Sun Sep 15 23:19:58 UTC 2019
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
bucardo add sync tsync tables=table,table2,table3 dbs=dutobs:source,kodobs:target
WARNING: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=obsdata;host=database_host1;port=5432 at line 828.
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.
I have tried many other combinations of supplying info to add sync: using pre-created herds, dbgroups, ... BUT ... most every attempt results in this error.
Any help or direction would be great appreciated.
- Ric Shepard
--
Ric Shepard, Analyst/Programmer
Alaska Department of Fish and Game
Commercial Fisheries, Westward Region
351 Research Court, Kodiak, AK 99615
907-486-1862 <ric.shepard at alaska.gov>
More information about the Bucardo-general
mailing list