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@oprpgs001 edb-as-11]$ ps -ef|grep postgres:  | wc -l
> 517
> 
> [enterprisedb@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.klaver@aklaver.com