Re: BUG #18141: sorry, too many clients error occurring very frequently - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #18141: sorry, too many clients error occurring very frequently
Date
Msg-id CAMkU=1zXTm-zAq2jRoscmqDmDGPjRy_18BhOn_-Jb0TuGbHHbg@mail.gmail.com
Whole thread Raw
In response to BUG #18141: sorry, too many clients error occurring very frequently  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18141: sorry, too many clients error occurring very frequently
List 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 by date:

Previous
From: Jorge Soro Domenech
Date:
Subject: Help pg_restore version
Next
From: Michael Paquier
Date:
Subject: Re: BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned