regiond workers can use too many postgres connections

Bug #1703403 reported by Blake Rouse on 2017-07-10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Blake Rouse
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  Edit
Everyone can see this information.

Other bug subscribers