[Bucardo-general] excuseme why the State is always by "Begin txn"

Greg Sabino Mullane greg at endpoint.com
Thu Nov 5 15:04:11 UTC 2015


On Thu, Oct 22, 2015 at 11:08:12PM +0800, 928150342 at qq.com 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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151105/74aa363a/attachment.sig>


More information about the Bucardo-general mailing list