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@xxxxxxxxxxx
