[Bucardo-general] Unable to add sync

[Shepard, Ric (DFG)]

On 09/16/2019 08:35 AM, David Christensen wrote:
> 
> 
>> 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?
> 
> 

The bucardo database was removed.  The bucardo schema in each replicated database was left in place.

Thank you.

-- 
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>