[Bucardo-general] [HELP] bucardo: sync status "Begin txn" and tables are not updated

[Saiful Muhajir]

We have configured the master in RDS to slave in EC server.
Upon initialisation the replication seems to be working. But once the
initialisation is completed, the status is only saying '
​*​*
*Begin txn (KID 123)*".
The problem is there was no error in the bucardo log but the tables on
slave are updated very slowly. And the update happened after I restart
bucardo.

This only happened on sync2 where I have 34 tables to replicate. And they
are busy tables.

The detail configuration and log can be seen here:
https://paste.fedoraproject.org/paste/w183SKLGfKk8UHDthCOm615M1UNdIG
YhyRLivL9gydE=/raw

======================================================================
Last good                : May 05, 2017 13:15:27 (time to run: 5m 31s)
Rows deleted/inserted    : 163,084 / 412,628
Last bad                 : May 05, 2017 09:47:09 (time until fail: 3h 28m
7s)
Sync name                : sync2
Current state            : Begin txn (KID 15211)
Source relgroup/database : herd2 / rds_source
Tables in sync           : 34
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:              : Ended (CTL 13228)
======================================================================



--
Regards,

Saiful Muhajir <http://saifulmuhajir.web.id>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170505/d0524434/attachment.html>