Re: Max connections reached without max connections reached

On 11/23/21 15:53, James Sewell wrote:

>
> It's v odd as it happens *sometimes* - having said that it's happening
> right this moment:
>
> [enterprisedb(at)oprpgs001 edb-as-11]$ ps -ef|grep postgres:  | wc -l
> 517
>
> [enterprisedb(at)oprpgs001 ~]$ ps -ef|grep postgres: | grep -i start | wc -l
> 480

The enterprisedb is one of their customized versions?

rundeck_cluster below refers to https://digital.ai/technology/rundeck?

>
> postgres=# select count(*) from pg_stat_activity;
>  count
> -------
>    97
> (1 row)
>
> postgres=# select * from pg_locks where not granted;
>  locktype | database | relation | page | tuple | virtualxid |
> transactionid | classid | objid | objsubid | virtualtransaction | pid |
> mode | granted | fastpath
> ----------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----+------+---------+----------
> (0 rows)
> Logs are showing a stream of:
>
> 2021-11-24 10:50:58 AEDT [869]: [1-1]
> user=u_rundeck_rw,db=rundeck_cluster,client=10.154.19.23
> 10.154.19.23(57122) (0:53300)FATAL:  remaining connection slots are
> reserved for non-replication superuser connections
> 2021-11-24 10:50:58 AEDT [870]: [1-1]
> user=u_rundeck_rw,db=rundeck_cluster,client=10.154.19.23
> 10.154.19.23(57124) (0:53300)FATAL:  remaining connection slots are
> reserved for non-replication superuser connections
> 2021-11-24 10:50:58 AEDT [871]: [1-1]
> user=u_rundeck_rw,db=rundeck_cluster,client=10.154.19.23
> 10.154.19.23(57126) (0:53300)FATAL:  remaining connection slots are
> reserved for non-replication superuser connections
>
> James
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com