regiond workers can use too many postgres connections
Bug #1703403 reported by
Blake Rouse
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MAAS |
Fix Released
|
High
|
Blake Rouse | ||
2.2 |
Fix Released
|
High
|
Blake Rouse |
Bug Description
Each regiond worker can use 20 postgres connections plus 1 dedicated to the listener. So that is 21 connections per regiond worker.
Each regiond controller uses 4 workers:
21 * 4 = 84 connections
When you have 2 regiond controllers:
84 * 2 = 168 connections
Postgresql by default only allows 100 connections. That is more connections then Postgresql allows just to run 2 region controllers. It should be possible to run 2 region controllers without having to increase the number of postgresql connections that is allowed.
Related branches
~blake-rouse/maas:lower-max-conns-per-worker-2.2
- Blake Rouse (community): Approve
-
Diff: 20 lines (+8/-1)1 file modifiedsrc/maasserver/utils/threads.py (+8/-1)
~blake-rouse/maas:lower-max-conns-per-worker
Merged
into
maas:master
- Newell Jensen (community): Approve
-
Diff: 20 lines (+8/-1)1 file modifiedsrc/maasserver/utils/threads.py (+8/-1)
Changed in maas: | |
status: | In Progress → Fix Committed |
Changed in maas: | |
milestone: | 2.3.0 → 2.3.0alpha1 |
Changed in maas: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.