[Bucardo-general] Error that keep repeating at 5.4.1

[Michael Ben-Nes]

More info,

Connection using the user bucardo is working to both ends.
Data is not synced

--------------------------------------------------
Michael Ben-Nes - Linux Web Environment Expert.
http://www.epoch.co.il - LinkedIn <http://www.linkedin.com/in/michaelbennes>
Cellular: +972-54-4848113
--------------------------------------------------

On Wed, Feb 24, 2016 at 10:06 PM, Michael Ben-Nes <miki at epoch.co.il> wrote:

> Hi,
>
> I installed bucardo from source and the following error keep poping:
>
> (15661) [Wed Feb 24 14:56:49 2016] MCP Starting check_sync_health
> (18330) [Wed Feb 24 14:57:00 2016] KID (sa_sync) New kid, sync "sa_sync"
> alive=1 Parent=15676 PID=18330 kicked=1
> (18330) [Wed Feb 24 14:57:00 2016] KID (sa_sync) Delta count for
> sa_master.public.chat_entries      : 425
> (18330) [Wed Feb 24 14:57:00 2016] KID (sa_sync) Warning! Aborting due to
> exception for public.chat_entries:? Error was DBD::Pg::db pg_result failed:
> ERROR:  malformed array literal: "ARRAY(0x2087200)"\nLINE 1: ...E
> ("tag_id","private_to","seq_id") IN ( ('487216','ARRAY(0x2...\n
>                                                 ^\nDETAIL:  Array value
> must start with "{" or dimension information. at
> /usr/local/share/perl5/Bucardo.pm line 9536.
> (18330) [Wed Feb 24 14:57:00 2016] KID (sa_sync) Kid has died, error is:
> DBD::Pg::db pg_result failed: ERROR:  malformed array literal:
> "ARRAY(0x2087200)"\nLINE 1: ...E ("tag_id","private_to","seq_id") IN (
> ('487216','ARRAY(0x2...\n
>           ^\nDETAIL:  Array value must start with "{" or dimension
> information. at /usr/local/share/perl5/Bucardo.pm line 9536. Line: 5041
> Main DB state: ? Error: none DB sa_master state: ? Error: none DB sa_slave
> state: 22P02 Error: 7
> (18330) [Wed Feb 24 14:57:00 2016] KID (sa_sync) Kid 18330 exiting at
> cleanup_kid. Sync "sa_sync" public.chat_entries Reason: DBD::Pg::db
> pg_result failed: ERROR:  malformed array literal: "ARRAY(0x2087200)"\nLINE
> 1: ...E ("tag_id","private_to","seq_id") IN ( ('487216','ARRAY(0x2...\n
>                                                         ^\nDETAIL:  Array
> value must start with "{" or dimension information. at
> /usr/local/share/perl5/Bucardo.pm line 9536. Line: 5041 Main DB state: ?
> Error: none DB sa_master state: ? Error: none DB sa_slave state: 22P02
> Error: 7
>
> The system is: Scientific Linux release 6.5
> DBD ver: perl-DBD-Pg-2.15.1-4.el6_3.x86_64
>
> And the setting:
>
> first copy scheme.
>
> bucardo add database sa_master dbname=db1 dbpass=mypass
> bucardo add database sa_slave host=rds.amazonaws.com dbname=db1
> dbpass=mypass
> bucardo add all tables db=sa_master herd=sa_herd --verbose  ##total 2
> tables with primary key##
> bucardo add sync sa_sync relgroup=sa_herd
> dbs=sa_master:source,sa_slave:target onetimecopy=0
> bucardo start
>
> Run script that lock table and copy all data (take less then 5 seconds)
>
>
>
> --------------------------------------------------
> Michael Ben-Nes - Linux Web Environment Expert.
> http://www.epoch.co.il - LinkedIn
> <http://www.linkedin.com/in/michaelbennes>
> Cellular: +972-54-4848113
> --------------------------------------------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160224/3f776389/attachment.html>