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