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 <[email protected]> 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 > -------------------------------------------------- >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
