From: | zhangzq <z204126_maillist(at)163(dot)com> |
---|---|
To: | "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> |
Cc: | "Pg Bugs" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Many processes blocked at ProcArrayLock! |
Date: | 2014-06-10 02:03:55 |
Message-ID: | 6bf21001.1d933.1468384787d.Coremail.z204126_maillist@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
hi,
thanks.
my version is 9.3.2.
there were 221 processes blocked at "commit", and 114 processes blocked at "insert". (,found it by ps command).
在 2014-06-09 11:57:35,"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> 写道:
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?
From | Date | Subject | |
---|---|---|---|
Next Message | zsoros | 2014-06-10 08:19:36 | BUG #10589: hungarian.stop file spelling error |
Previous Message | Tom Lane | 2014-06-10 01:39:19 | Re: BUG #10587: ERROR: variable not found in subplan target list |