[Bucardo-general] add sync error

Frank NJ. njiaga at gmail.com
Fri Sep 14 09:45:42 UTC 2012


Thanks John

Any chance someone understanding why this is happening?

make test and make install result are below...

$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00-release.t .......... skipped: Test skipped unless environment variable
RELEASE_TESTING is set
t/01-basic.t ............ ok
t/02-bctl-customname.t .. ok
t/02-bctl-db.t .......... ok
t/02-bctl-dbg.t ......... ok
t/02-bctl-herd.t ........ ok
t/02-bctl-sync.t ........ ok
t/02-bctl-table.t ....... ok
t/10-fullcopy.t ......... ok
t/20-drizzle.t .......... skipped: Cannot test Drizzle unless the Perl
module DBD::drizzle is installed
t/20-mariadb.t .......... skipped: Cannot test MariaDB as we cannot connect
to a running MariaDB database
t/20-mongo.t ............ skipped: Cannot test mongo unless the Perl module
MongoDB is installed
t/20-mysql.t ............ skipped: Cannot test MySQL as we cannot connect
to a running MySQL database
t/20-oracle.t ........... skipped: Cannot test Oracle unless the Perl
module DBD::Oracle is installed
t/20-postgres.t ......... ok
t/20-redis.t ............ skipped: Cannot test Redis unless the Perl module
Redis is installed
t/20-sqlite.t ........... ok
t/30-delta.t ............ ok
t/98-cleanup.t .......... ok
t/99-lint.t ............. skipped: Test skipped unless environment variable
RELEASE_TESTING is set
t/99-perlcritic.t ....... skipped: Test skipped unless environment variable
RELEASE_TESTING is set
t/99-signature.t ........ skipped: Test skipped unless environment variable
RELEASE_TESTING is set
t/99-spellcheck.t ....... skipped: Test skipped unless environment variable
RELEASE_TESTING is set
t/99-yaml.t ............. skipped: Test skipped unless environment variable
RELEASE_TESTING is set
All tests successful.
Files=24, Tests=943, 403 wallclock secs ( 0.78 usr  0.13 sys + 129.07 cusr
66.91 csys = 196.89 CPU)
Result: PASS

$ sudo make install
Installing /usr/local/share/perl5/Bucardo.pm
Installing /usr/local/share/man/man1/bucardo.1pm
Installing /usr/local/share/man/man3/Bucardo.3pm
Installing /usr/local/bin/bucardo
Installing /usr/local/share/bucardo/bucardo.schema
Appending installation info to /usr/lib/perl5/perllocal.pod


On 14 September 2012 08:21, John Powell <john.powell at emapsite.com> wrote:

>  Hi Frank,
>
> I didn't solve it, I gave up. It is something I have been meaning to go
> back to.
>
> John
>
>
>
>
> On 13/09/2012 22:00, Frank NJ. wrote:
>
> How did you manage to solve this issue please?
>
>  I am facing the exact same situation and i've got no clue on what is
> going on...
>
>  Bucardo 4 used to work perfectly and now that i'm trying the 5, nothing.
>
>  $ bucardo add sync copy herd=camuk dbs=wms_cm:source,wms_uk:target
> Created database group "copy"
> NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect()
> of DBD::Pg::db handle dbname=wms;host=192.168.1.106;port=5432 at line 410.
>
>  CONTEXT:  SQL statement "SELECT validate_sync('copy')"
> 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:  column "sync" does not exist
> LINE 1: ...bucardo.bucardo_delta_targets WHERE tablename=$1 AND sync=$2
>                                                                 ^ at line
> 410. at line 30. at /usr/local/bin/bucardo line 4113.
>
>
>
>
> On 16 December 2011 17:58, John Powell <john.powell at emapsite.com> wrote:
>
>> Hi,
>>
>> I did a drop schema bucardo cascade on both machines and
>> rebuilt/reinstalled bucardo 5.  I'm pretty sure all traces of 4 have gone.
>>
>> Now when I try and add the sync I get,
>>
>> PL/Perl function "validate_sync"
>> Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db
>> selectall_arrayref failed: ERROR:  relation "bucardo.bucardo_sequences"
>> does not exist
>> LINE 1: ...bute WHERE attname = 'targetname'  AND attrelid = 'bucardo.b...
>>                                                               ^ at line
>> 757. at line 30.
>>
>>
>> Thanks.
>>
>> John
>>  _______________________________________________
>> Bucardo-general mailing list
>> Bucardo-general at bucardo.org
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120914/8f7685a6/attachment.html>


More information about the Bucardo-general mailing list