Re: BUG #18141: sorry, too many clients error occurring very frequently

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #18141: sorry, too many clients error occurring very frequently
Дата
Msg-id CAMkU=1zXTm-zAq2jRoscmqDmDGPjRy_18BhOn_-Jb0TuGbHHbg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #18141: sorry, too many clients error occurring very frequently  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #18141: sorry, too many clients error occurring very frequently  (Joe Conway <mail@joeconway.com>)
Список pgsql-bugs
Дерево обсуждения
On Fri, Sep 29, 2023 at 7:55 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18141
Logged by:          Ravi Agrawal
Email address:      ravi.s.agrawal23@gmail.com
PostgreSQL version: 13.11
Operating system:   RHEL
Description:       

Hi Team,

We have updated PostgresSQL from version 13.4 to 13.11 and observing 'sorry,
too many clients' error very frequently.
Connection count is shooting up on performing basic operations  and crossing
the max_connections value. This has not been observed previously on Postgres
v13.4
We need to understand if this issue is caused due to the change in version.
Is there any history of known incidents facing this issue with the specific
version of PostgreSQL.

I think it is unlikely to be a bug.  How did you do the upgrade?  Just install the new binaries, then restart the server?

Can you capture plans from the newly slow queries and compare them to plans from the same queries before the upgrade?

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jorge Soro Domenech
Дата:
Сообщение: Help pg_restore version
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned