[Bucardo-general] Error that keep repeating at 5.4.1

[Michael Ben-Nes]

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/d279be3a/attachment-0001.html>