The default RHEL 7 and 8 postgresql.conf ships with "max_connections = 100".
RHEL 7's httpd uses the prefork MPM by default, and RHEL 8's httpd
uses the event MPM by default instead.
It seems that RHEL 8 opens many more simultaneous connections to the
database, and it's very easy to hit PostgreSQL's 100 max_connections
limit. In my tests, it's possible to get ServerOffline errors with
just one or two clients. For example, running kojira with kojiweb will
hit ServerOffline.
When I bump postgresql.conf to "max_connections = 500" I cannot reach
the limit on el8.
Before we tell users to bump this number in the Server HowTo guide,
I'm wondering if there is a better way to improve this in Koji's code.
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
recommends connection pooling instead of opening more connections, but
I don't know how to implement this.
- Ken
As a first step after yesterday's community meeting I've enabled
koji-testing build in copr. It is a step ahead compared to my original
"master" repo. So, now you can use:
Repo which uses master branch and is built once per four hours if there is
anything new in git
https://copr.fedorainfracloud.org/coprs/tkopecek/koji/
Repo which uses master branch + merged all "testing-ready" PRs. This build
is used by our internal QE for testing actual content. (Can be often broken
due to automatic merging)
https://copr.fedorainfracloud.org/coprs/tkopecek/koji-testing/
--
Tomas Kopecek <tkopecek(a)redhat.com>
RHEL Build Development, RedHat
Hi,
this is Koji Community Meeting Reminder:
*Meeting docs: *https://pad.mozilla.org/p/KojiMay2020
*Meeting Time:* May 13 2020 11:00-12:00AM US/ET
*Where: * https://bluejeans.com/7644926294
*Proposed Agenda:*
- Koji update:
- Koji 1.20.1 released
- https://pagure.io/koji/roadmap/1.20.1/
- Feedback or retrospective
- Koji 1.21 released
- https://pagure.io/koji/roadmap/1.21/
- Feedback or retrospective
- Koji 1.22
- Proposed issues so far -
- https://pagure.io/koji/roadmap/1.22/
- Others you want to talk:
Feel free to add more topics you want to talk about. See you this
Wednesday.
Best wishes,
JANA ČUPOVÁ
Software Engineer
Red Hat Czech, s.r.o. <https://www.redhat.com/>
Purkyňova 99
612 00 Brno, Czech Republic
jcupova(a)redhat.com IM: #jcupova
<https://red.ht/sig>
