[Bucardo-general] Bucardo sync not working

[Naveen Kumar]

Hello Experts,

I am upgrading RDS pg9.3 instance to pg10 RDS instance using bucardo. I
have sucessfylly upgraded test instances. Productions it is failed.

Below are the steps I fallowed.

bucardo add db source_db
bucardo add db target_db
bucardo add all tables db=source_db pkonly relgroup=relgroup_name
bucardo add all sequences db=source_db relgroup
bucardo add dbgroup db_group_name source_db:source target_db:target
bucardo add sync syncname relgroup=relgroup_name dbs=db_group_name
autokick=0

taken dump from source and restored it on target

bucardo add sync syncname relgroup=relgorup_name dbs=db_group_name
autokick=1

bucardo start.

bucardo status
PID of Bucardo MCP: 31743
 Name           State    Last good    Time    Last I/D    Last bad    Time
==============+========+============+=======+===========+===========+============
 syncname | Bad    | none       |       |           | 06:53:01  | 1h 24m 10s

bucardo validate syncname
Validating sync syncname ... OK

(31743) [Fri Oct  5 06:52:59 2018] MCP Active syncs: 1
(31743) [Fri Oct  5 06:52:59 2018] MCP Entering main loop
(31746) [Fri Oct  5 06:52:59 2018] VAC New VAC daemon. PID=31746
(31746) [Fri Oct  5 06:52:59 2018] VAC Connected to database "source_db"
with backend PID of 52659
(31743) [Fri Oct  5 06:52:59 2018] MCP Created VAC 31746
(31748) [Fri Oct  5 06:52:59 2018] CTL New controller for sync "syncname".
Relgroup is " relgroup_name ", dbs is " db_group_name ". PID=31748
(31748) [Fri Oct  5 06:52:59 2018] CTL   stayalive: 1 checksecs: 0 kicked: 1
(31748) [Fri Oct  5 06:52:59 2018] CTL   kidsalive: 1 onetimecopy: 0
lifetimesecs: 0 (NULL) maxkicks: 0
(31748) [Fri Oct  5 06:52:59 2018] CTL Database "source_db" backend PID:
52660
(31748) [Fri Oct  5 06:52:59 2018] CTL Database "target_db" backend PID:
3097
(31743) [Fri Oct  5 06:52:59 2018] MCP Created controller 31748 for sync
"offerup_sync". Kick is 1
(31750) [Fri Oct  5 06:53:01 2018] KID (offerup_sync) New kid, sync
"offerup_sync" alive=1 Parent=31748 PID=31750 kicked=1
(30855) [Fri Oct  5 06:53:01 2018] KID (offerup_sync) Kid 30855 exiting at
cleanup_kid. Sync "offerup_sync" public.account_follower Reason: CTL
request Line: 5001
(30855) [Fri Oct  5 06:53:01 2018] KID (offerup_sync) File
/var/run/bucardo/bucardo.kid.sync.offerup_sync.pid contained foreign PID
31750, so will not remove
(31743) [Fri Oct  5 06:53:01 2018] MCP Starting check_sync_health
(31750) [Fri Oct  5 06:56:49 2018] KID (offerup_sync) Delta count for
source_db.public.table1                                      :  2452231
(31750) [Fri Oct  5 06:56:49 2018] KID (offerup_sync) Delta count for
source_db.public.table2                                 :    15036
(31750) [Fri Oct  5 06:56:49 2018] KID (offerup_sync) Delta count for
source_db.public.table3                              :      412


root at ubuntu:/home/ubuntu# bucardo status syncname
======================================================================
Last bad                 : Oct 05, 2018 06:53:01 (time until fail: 1s)
Sync name                : offerup_sync
Current state            : Bad
Source relgroup/database :  relgroup_name / source_db
Tables in sync           : 333
Status                   : Active
Check time               : None
Overdue time             : 00:00:00
Expired time             : 00:00:00
Stayalive/Kidsalive      : Yes / Yes
Rebuild index            : No
Autokick                 : Yes
Onetimecopy              : No
Post-copy analyze        : Yes
Last error:              : Failed : CTL request Line: 5001  (KID 30855)
======================================================================

 Can any one please help me. Thanks in advance.


Thanks & Regards,
Naveen Kumar .M,
*My attitude will always be based on how you treat me. *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20181005/c122592f/attachment.html>