Обсуждение: Many processes blocked at ProcArrayLock!

aGVsbG8sIApNeSBtYW55IHByb2Nlc3NlcyBpcyBibG9ja2VkLCBhbmQgY2FuJ3QgbG9naW4sIEkg
ZHVtcCB0aGUgY2FsbCBzdGFjayBieSBwc3RhY2ssIGFuZCBmb3VuZCB0aGVzZSBwcm9jZXNzZXMg
aXMgYmxvY2tlZCBhdDogTFdMb2NrQWNxdWlyZShQcm9jQXJyYXlMb2NrLCBMV19FWENMVVNJVkUp
LApXaG8gaGF2ZSBlbmNvdW50ZXJlZCB0aGlzIHNpdHVhdGlvbj8gCnRoYW5rcyEKCgogICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIHpoaXFpYW5nIHpoYW5nCiA=

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?

aGksIAp0aGFua3MuCm15IHZlcnNpb24gaXMgOS4zLjIuCnRoZXJlIHdlcmUgMjIxIHByb2Nlc3Nl
cyBibG9ja2VkIGF0ICJjb21taXQiLCAgYW5kIDExNCBwcm9jZXNzZXMgYmxvY2tlZCBhdCAgImlu
c2VydCIuICgsZm91bmQgaXQgYnkgcHMgY29tbWFuZCkuCgoKCgoKCtTaIDIwMTQtMDYtMDkgMTE6
NTc6MzWjrCJKZWZmIEphbmVzIiA8amVmZi5qYW5lc0BnbWFpbC5jb20+INC0tcCjugoKT24gTW9u
LCBKdW4gOSwgMjAxNCBhdCAyOjUyIEFNLCB6aGFuZ3pxIDx6MjA0MTI2X21haWxsaXN0QDE2My5j
b20+IHdyb3RlOgoKaGVsbG8sIApNeSBtYW55IHByb2Nlc3NlcyBpcyBibG9ja2VkLCBhbmQgY2Fu
J3QgbG9naW4sIEkgZHVtcCB0aGUgY2FsbCBzdGFjayBieSBwc3RhY2ssIGFuZCBmb3VuZCB0aGVz
ZSBwcm9jZXNzZXMgaXMgYmxvY2tlZCBhdDogTFdMb2NrQWNxdWlyZShQcm9jQXJyYXlMb2NrLCBM
V19FWENMVVNJVkUpLApXaG8gaGF2ZSBlbmNvdW50ZXJlZCB0aGlzIHNpdHVhdGlvbj8gCnRoYW5r
cyEKCgpXaGF0IHZlcnNpb24/ICBUaGlzIG1heSBiZSBhbiBpc3N1ZSBmaXhlZCBpbiA5LjMuNCwg
OS4yLjgsIDkuMS4xMywgOS4wLjE3LCBzZWUgY29tbWl0IDAwMjgzY2FlMWI3ODE3NGUyN2IzOWMg
YW5kIHNpYmxpbmdzLiAgRG8geW91IGhhdmUgYSBsb3Qgb2YgaW5zZXJ0ZWQgYnV0IG5vdCB5ZXQg
Y29tbWl0dGVkIHR1cGxlcz8KCgoK

On Mon, Jun 9, 2014 at 7:03 PM, zhangzq <z204126_maillist@163.com> wrote:

> 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).
>


You should upgrade to 9.3.4, it is an easy upgrade.  Also, 335
simultaneously active connections is just going to exacerbate the problem,
no matter what the root cause of the problem is.

Cheers,

Jeff