[Bucardo-general] add sync error

[John Powell]

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 
> <mailto: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 <mailto: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/ebdc4dff/attachment-0001.html>