[MacPorts] #60662: psql: FATAL: remaining connection slots are reserved for non-replication superuser connections
MacPorts
noreply at macports.org
Tue Jun 16 23:08:40 UTC 2020
#60662: psql: FATAL: remaining connection slots are reserved for non-replication
superuser connections
-----------------------------+---------------------
Reporter: ryandesign | Owner: admin@…
Type: defect | Status: new
Priority: Normal | Milestone:
Component: server/hosting | Version:
Resolution: | Keywords:
Port: |
-----------------------------+---------------------
Comment (by neverpanic):
@Ryan: We limited the number of requests served by a single gunicorn
worker instance to 1000 requests before a new worker is started. This
seems to have improved the situation as evident from our monitoring:
[[Image(https://p.dnnr.de/qOJl19wWQiaIDWnC.png)]]
Did you see any further such issues after Tuesday 20:00 UTC?
In any case, I've also reduced the number of gunicorn workers to 14 now,
and changed to restarting the servers every 500 requests. Let's see
whether this reduces the number of open connections even further without
compromising on Trac's performance.
--
Ticket URL: <https://trac.macports.org/ticket/60662#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list