Re: Many processes blocked at ProcArrayLock!

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: zhangzq <z204126_maillist(at)163(dot)com>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Many processes blocked at ProcArrayLock!
Date: 2014-06-09 15:57:35
Message-ID: CAMkU=1xf2aJceFP5i6+8=5oyfnV6cAyb-OMzF2kxmwkCcDavDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 9, 2014 at 2:52 AM, zhangzq <z204126_maillist(at)163(dot)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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matheus de Oliveira 2014-06-09 18:58:17 Re: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages
Previous Message Andres Freund 2014-06-09 15:22:15 Re: uninterruptable loop: concurrent delete in progress within table