Reserved connections weird issue

From: Petr Novak <petr(dot)novak23(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Reserved connections weird issue
Date: 2016-08-04 15:32:31
Message-ID: CAB+GdvC3QqOZaHzq+4H6i1Sm6NjHa-6H4ZrdHRZ5zz3bWqYv6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I'm having strange problem with one of our PG servers.

We're running legacy application (written in .NET) on several servers, it
creates large number of connections to a PG cluster (9.3.10), running on
CentOS 6. Lately the app team changed the deployment strategy in a way,
that in peaks it generated almost twice as much connections as before.

Strange thing is, that the connections filled all the way up to
max_connections and started to block the new connections with:

FATAL: sorry, too many clients already

related non-default settings:

max_connections = 800
superuser_reserved_connections = 10

It surprised me, that it didn't kept the reserved connections for the
superuser, as the application user is not superuser (got the Create DB
though). So I couldn't connect to the server to find out, what is going on.
I have verified that no superuser connections were on the server running in
that time.

In the process list majority of processes was in "authentication" state and
they were not shown in the numbackends of the pg_stat_database view
(collectd have had connections already established, so metrics were
gathered)

Any idea what I got wrong?

Thanks
Petr

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-08-04 18:02:16 Re: Reserved connections weird issue
Previous Message ghiureai 2016-08-03 22:20:06 PG 9.5 same SQL 2 different plans