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-10 16:02:35
Message-ID: CAMkU=1z9ojM-iqe_TmaOLWrHyo4OMOX8kd8EayD0L9-q8AeFJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 9, 2014 at 7:03 PM, zhangzq <z204126_maillist(at)163(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2014-06-10 18:29:11 Re: BUG #10589: hungarian.stop file spelling error
Previous Message Serge Negodyuck 2014-06-10 14:06:49 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby