regiond workers can use too many postgres connections

Bug #1703403 reported by Blake Rouse
6
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

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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.