On Thu, Oct 22, 2015 at 11:08:12PM +0800, [email protected] wrote: > sync1 mydb1: source mydb2: source > sync2 mydb1: source mydb3: source > sync3 mydb1: source mydb4: source > …… > Until sync18 > the db mydb1 makedelta=1 > now the database size is 25G+ > Now there is a difficult problem. > When I add a new sync to bucardo is long times than 20Days and State is > always by "Begin txn"
When exactly does the "begin txn" show up? Adding the sync, validating the sync, or after bucardo starts? It sounds like a lock is blocking the query from going any further, so you should examine pg_stat_activity (look for waiting='t') and pg_locks. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
