Re: BUG #14588: Postgres process blocked on semop

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: diabloneo(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14588: Postgres process blocked on semop
Date: 2017-03-12 04:53:10
Message-ID: 24075.1489294390@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

diabloneo(at)gmail(dot)com writes:
> During the daytime, there are about 300 postgres processes running, work as
> expected. On 00:00 each day, there will be about 200 more postgresql
> processes created, now totally about 500. And from that time, thoese working
> processes are all blocked on semop function. I check this using pstack
> command, and also check the output of ipcs -s [-i]. After this has happened,
> all new connection will stay in state authentication.

And your authentication setup is ...?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neo Liu 2017-03-12 06:21:31 Re: BUG #14588: Postgres process blocked on semop
Previous Message Neo Liu 2017-03-12 04:30:52 Re: BUG #14588: Postgres process blocked on semop