pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16232: Database server connection limit exceeding
5+ messages / 4 participants
[nested] [flat]

* BUG #16232: Database server connection limit exceeding
@ 2020-01-26 03:39 PG Bug reporting form <noreply@postgresql.org>
  2020-01-26 06:47 ` Re: BUG #16232: Database server connection limit exceeding David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: PG Bug reporting form @ 2020-01-26 03:39 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: deepakraib@gmail.com

The following bug has been logged on the website:

Bug reference:      16232
Logged by:          DEEPAK RAI B
Email address:      deepakraib@gmail.com
PostgreSQL version: 9.6.9
Operating system:   Core OS
Description:        

Hi Team,

We are getting below error even though total connection in the database
(select count(*) from pg_stat_activity;) is not more than 10 and
max_connections are allowed 300. We are seeing below error most of the time
and only sometime it is impacting our application. Please let me know what
might be the issue?  

"startup",2020-01-23 15:17:25 UTC,1999/7,0,FATAL,53300,"remaining connection
slots are reserved for non-replication superuser connections",,,,,,,,,""



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16232: Database server connection limit exceeding
  2020-01-26 03:39 BUG #16232: Database server connection limit exceeding PG Bug reporting form <noreply@postgresql.org>
@ 2020-01-26 06:47 ` David G. Johnston <david.g.johnston@gmail.com>
  2020-01-26 07:12   ` Re: BUG #16232: Database server connection limit exceeding Deepak Rai <deepakraib@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: David G. Johnston @ 2020-01-26 06:47 UTC (permalink / raw)
  To: deepakraib@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

On Sat, Jan 25, 2020 at 8:40 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      16232
> Logged by:          DEEPAK RAI B
> Email address:      deepakraib@gmail.com
> PostgreSQL version: 9.6.9
> Operating system:   Core OS
> Description:
>
> Hi Team,
>
> We are getting below error even though total connection in the database
> (select count(*) from pg_stat_activity;) is not more than 10 and
> max_connections are allowed 300. We are seeing below error most of the time
> and only sometime it is impacting our application. Please let me know what
> might be the issue?
>
> "startup",2020-01-23 15:17:25 UTC,1999/7,0,FATAL,53300,"remaining
> connection
> slots are reserved for non-replication superuser connections",,,,,,,,,""
>

Not likely to be a bug.  The issue is you've hit the max connections
allowed for non-superuser connections.  You can inspect log files (possibly
after changing log settings) or plug in some active poll-based monitoring
to discover exactly how that is happening.

Follow-on questions or help is more appropriately directed to the -general
email list and not the bug reporting forum.

David J.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16232: Database server connection limit exceeding
  2020-01-26 03:39 BUG #16232: Database server connection limit exceeding PG Bug reporting form <noreply@postgresql.org>
  2020-01-26 06:47 ` Re: BUG #16232: Database server connection limit exceeding David G. Johnston <david.g.johnston@gmail.com>
@ 2020-01-26 07:12   ` Deepak Rai <deepakraib@gmail.com>
  2020-01-26 16:04     ` Re: BUG #16232: Database server connection limit exceeding Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Deepak Rai @ 2020-01-26 07:12 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; pgsql-jdbc@lists.postgresql.org

Hi Team,

We are actively monitoring database connections and total connection count
was not more than 14. Max connections are allowed in the database is 300.
May i know why this is occurring even though connection is not crossing its
threshold.
We are seeing below error from last 7 days and application was working fine
but yday application was not able to connect the database.Why are we
observing this behavior?

,"remaining connection
slots are reserved for non-replication superuser connections"



Regards,
Deepak

On Sun, Jan 26, 2020 at 12:18 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Sat, Jan 25, 2020 at 8:40 PM PG Bug reporting form <
> noreply@postgresql.org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference:      16232
>> Logged by:          DEEPAK RAI B
>> Email address:      deepakraib@gmail.com
>> PostgreSQL version: 9.6.9
>> Operating system:   Core OS
>> Description:
>>
>> Hi Team,
>>
>> We are getting below error even though total connection in the database
>> (select count(*) from pg_stat_activity;) is not more than 10 and
>> max_connections are allowed 300. We are seeing below error most of the
>> time
>> and only sometime it is impacting our application. Please let me know what
>> might be the issue?
>>
>> "startup",2020-01-23 15:17:25 UTC,1999/7,0,FATAL,53300,"remaining
>> connection
>> slots are reserved for non-replication superuser connections",,,,,,,,,""
>>
>
> Not likely to be a bug.  The issue is you've hit the max connections
> allowed for non-superuser connections.  You can inspect log files (possibly
> after changing log settings) or plug in some active poll-based monitoring
> to discover exactly how that is happening.
>
> Follow-on questions or help is more appropriately directed to the -general
> email list and not the bug reporting forum.
>
> David J.
>
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16232: Database server connection limit exceeding
  2020-01-26 03:39 BUG #16232: Database server connection limit exceeding PG Bug reporting form <noreply@postgresql.org>
  2020-01-26 06:47 ` Re: BUG #16232: Database server connection limit exceeding David G. Johnston <david.g.johnston@gmail.com>
  2020-01-26 07:12   ` Re: BUG #16232: Database server connection limit exceeding Deepak Rai <deepakraib@gmail.com>
@ 2020-01-26 16:04     ` Tom Lane <tgl@sss.pgh.pa.us>
  2020-01-28 08:43       ` Re: BUG #16232: Database server connection limit exceeding Deepak Rai <deepakraib@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2020-01-26 16:04 UTC (permalink / raw)
  To: Deepak Rai <deepakraib@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-jdbc@lists.postgresql.org

Deepak Rai <deepakraib@gmail.com> writes:
> We are actively monitoring database connections and total connection count
> was not more than 14. Max connections are allowed in the database is 300.
> May i know why this is occurring even though connection is not crossing its
> threshold.

Over-aggressive setting for superuser_reserved_connections, perhaps?
Another possibility is a whole lot of uncommitted prepared transactions.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16232: Database server connection limit exceeding
  2020-01-26 03:39 BUG #16232: Database server connection limit exceeding PG Bug reporting form <noreply@postgresql.org>
  2020-01-26 06:47 ` Re: BUG #16232: Database server connection limit exceeding David G. Johnston <david.g.johnston@gmail.com>
  2020-01-26 07:12   ` Re: BUG #16232: Database server connection limit exceeding Deepak Rai <deepakraib@gmail.com>
  2020-01-26 16:04     ` Re: BUG #16232: Database server connection limit exceeding Tom Lane <tgl@sss.pgh.pa.us>
@ 2020-01-28 08:43       ` Deepak Rai <deepakraib@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Deepak Rai @ 2020-01-28 08:43 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-jdbc@lists.postgresql.org

Hi Team,

Any update on this?

Regards,
Deepak

On Sun, Jan 26, 2020 at 9:36 PM Deepak Rai <deepakraib@gmail.com> wrote:

> Hi Tom,
>
> Super user reserved is 3, it was default value and we have not done any
> changes.
>
> Regards,
> Deepak
>
> On Sun, 26 Jan, 2020, 9:34 pm Tom Lane, <tgl@sss.pgh.pa.us> wrote:
>
>> Deepak Rai <deepakraib@gmail.com> writes:
>> > We are actively monitoring database connections and total connection
>> count
>> > was not more than 14. Max connections are allowed in the database is
>> 300.
>> > May i know why this is occurring even though connection is not crossing
>> its
>> > threshold.
>>
>> Over-aggressive setting for superuser_reserved_connections, perhaps?
>> Another possibility is a whole lot of uncommitted prepared transactions.
>>
>>                         regards, tom lane
>>
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2020-01-28 08:43 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-26 03:39 BUG #16232: Database server connection limit exceeding PG Bug reporting form <noreply@postgresql.org>
2020-01-26 06:47 ` David G. Johnston <david.g.johnston@gmail.com>
2020-01-26 07:12   ` Deepak Rai <deepakraib@gmail.com>
2020-01-26 16:04     ` Tom Lane <tgl@sss.pgh.pa.us>
2020-01-28 08:43       ` Deepak Rai <deepakraib@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox