Postgres Pro
Downloads
Home   >   mailing lists

Re: Many processes blocked at ProcArrayLock! - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Many processes blocked at ProcArrayLock!
Date
Msg-id CAMkU=1xf2aJceFP5i6+8=5oyfnV6cAyb-OMzF2kxmwkCcDavDA@mail.gmail.com
Whole thread Raw
In response to Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
Responses Re: Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
List pgsql-bugs
Tree view 
On Mon, Jun 9, 2014 at 2:52 AM, zhangzq <z204126_maillist@163.com> wrote:

> hello,
> My many processes is blocked, and can't login, I dump the call stack by
> pstack, and found these processes is blocked
> at: LWLockAcquire(ProcArrayLock, LW_EXCLUSIVE),
> Who have encountered this situation?
> thanks!
>

What version?  This may be an issue fixed in 9.3.4, 9.2.8, 9.1.13, 9.0.17,
see commit 00283cae1b78174e27b39c and siblings.  Do you have a lot of
inserted but not yet committed tuples?

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: uninterruptable loop: concurrent delete in progress within table
Next
From: Matheus de Oliveira
Date:
Subject: Re: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages