[Bucardo-general] adding sync without sequence fail on bucardo5
David E. Wheeler
david at justatheory.com
Fri Nov 2 00:13:38 UTC 2012
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
sudo make install
And then proceed as usual.
More information about the Bucardo-general