[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