[Bucardo-general] adding sync without sequence fail on bucardo5

[David E. Wheeler]

On Nov 1, 2012, at 4:34 PM, "Frank NJ." <njiaga at gmail.com> wrote:

> did a git pull
> then a bucardo stop
> and a bucardo upgrade
> but no luck:
> 
> [lond@ ~]$ bucardo add sync xxxxxxx herd=cameroon dbs=wisms_cm:source,wisms_uk:source
> Created database group "xxxxxxxx"
> NOTICE:  Dropping older version of bucardo_sequences, then recreating empty
> CONTEXT:  SQL statement "SELECT validate_sync('xxxxxxx')"
> NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=wms;host=88.xx.xx.132;port=5432 at line 807.
> 
> CONTEXT:  SQL statement "SELECT validate_sync('xxxxxx')"
> Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl function "validate_sync": error from Perl function "validate_sync": DBD::Pg::db do failed: ERROR:  table "bucardo_sequences" does not exist at line 807. at line 30. at /usr/local/bin/bucardo line 4110.

That's still using /usr/local/bin/bucardo. Try running

    perl -I. bucardo add sync xxxxxxx herd=cameroon dbs=wisms_cm:source,wisms_uk:source

That should at least help me to find the proper line number of the failure.

Alternately, you can

    perl Makefile.PL
    make
    sudo make install

And then proceed as usual.

Best,

David