Re: Many processes blocked at ProcArrayLock!

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Many processes blocked at ProcArrayLock!
Дата
Msg-id CAMkU=1xf2aJceFP5i6+8=5oyfnV6cAyb-OMzF2kxmwkCcDavDA@mail.gmail.com
обсуждение исходный текст
Ответ на Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
Ответы Re: Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: uninterruptable loop: concurrent delete in progress within table
Следующее
От: Matheus de Oliveira
Дата:
Сообщение: Re: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages