[Bucardo-general] Validate_sync error while adding new sync

Csaba Simon simocsab at gmail.com
Fri Feb 15 18:08:39 UTC 2013


Hi,


I use Bucardo version 4.99.6 and I would like to add syncs to the
configuration, I use the same configuration in another server environment
and it works.

I add dbs, dbgroups, tables, customnames, relgroups succesfully with the
next commands:

--add dbs
bucardo --dbhost 192.168.30.243 add db b2infra_test dbname=b2infra_test
host=192.168.30.243
bucardo --dbhost 192.168.30.243 add db b2kma_test dbname=b2kma_test
host=192.168.30.243
bucardo --dbhost 192.168.30.243 add db b2sug_test dbname=b2sug_test
host=192.168.30.243
bucardo --dbhost 192.168.30.243 add db b2tig_test dbname=b2tig_test
host=192.168.30.243

--add db groups
bucardo --dbhost 192.168.30.243 add dbgroup dbgroup_b2infra_b2kma
b2infra_test:source b2kma_test:target
bucardo --dbhost 192.168.30.243 add dbgroup dbgroup_b2infra_b2sug
b2infra_test:source b2sug_test:target
bucardo --dbhost 192.168.30.243 add dbgroup dbgroup_b2infra_b2tig
b2infra_test:source b2tig_test:target

--add tables
bucardo --dbhost 192.168.30.243 add table b2infra.felhasznalo
db=b2infra_test
bucardo --dbhost 192.168.30.243 add table b2infra.modul db=b2infra_test
bucardo --dbhost 192.168.30.243 add table b2infra.szemely db=b2infra_test
bucardo --dbhost 192.168.30.243 add table b2infra.telephely db=b2infra_test
bucardo --dbhost 192.168.30.243 add table b2infra.rendszerparameter
db=b2infra_test

--add customnames
bucardo --dbhost 192.168.30.243 add customname b2infra.felhasznalo
b2kma.felhasznalo db=b2kma_test
bucardo --dbhost 192.168.30.243 add customname b2infra.felhasznalo
b2sug.felhasznalo db=b2sug_test
bucardo --dbhost 192.168.30.243 add customname b2infra.felhasznalo
b2tig.felhasznalo db=b2tig_test
bucardo --dbhost 192.168.30.243 add customname b2infra.modul b2kma.modul
db=b2kma_test
bucardo --dbhost 192.168.30.243 add customname b2infra.modul b2sug.modul
db=b2sug_test
bucardo --dbhost 192.168.30.243 add customname b2infra.modul b2tig.modul
db=b2tig_test
bucardo --dbhost 192.168.30.243 add customname b2infra.szemely
b2kma.szemely db=b2kma_test
bucardo --dbhost 192.168.30.243 add customname b2infra.szemely
b2sug.szemely db=b2sug_test
bucardo --dbhost 192.168.30.243 add customname b2infra.szemely
b2tig.szemely db=b2tig_test
bucardo --dbhost 192.168.30.243 add customname b2infra.telephely
b2kma.telephely db=b2kma_test
bucardo --dbhost 192.168.30.243 add customname b2infra.telephely
b2sug.telephely db=b2sug_test
bucardo --dbhost 192.168.30.243 add customname b2infra.telephely
b2tig.telephely db=b2tig_test
bucardo --dbhost 192.168.30.243 add customname b2infra.rendszerparameter
b2kma.rendszerparameter db=b2kma_test
bucardo --dbhost 192.168.30.243 add customname b2infra.rendszerparameter
b2sug.rendszerparameter db=b2sug_test
bucardo --dbhost 192.168.30.243 add customname b2infra.rendszerparameter
b2tig.rendszerparameter db=b2tig_test

--add relgroups
bucardo --dbhost 192.168.30.243 add relgroup relgroup_b2infra
b2infra.felhasznalo b2infra.modul b2infra.szemely b2infra.telephely
b2infra.rendszerparameter


Then I want to add a new sync like this:

bucardo --dbhost 192.168.30.243 add sync sync_b2infra_b2kma
dbs=dbgroup_b2infra_b2kma relgroup=relgroup_b2infra

I get the following error:

NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect() of
DBD::Pg::db handle dbname=b2infra_test;host=192.168.30.243 at line 432.

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.


Please, help me!


Csaba
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130215/f6209747/attachment.html>


More information about the Bucardo-general mailing list