Heat Stack Causes MariaDB Too Many Connections
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
kolla |
Fix Released
|
High
|
Daneyon Hansen |
Bug Description
OpenStack works just fine until creating a Heat stack. Creating the stack appears too creates too many connections to the DB, causing the DB to reach the max_connection count. Therefore, the DB blocks all connections from the source IP for a specific period of time. Since all OpenStack services are running on the same host, all services are blocked.
From the Heat Engine logs:
heatengine_1 | six.reraise(
heatengine_1 | File "/usr/lib/
heatengine_1 | return fn()
heatengine_1 | File "/usr/lib64/
heatengine_1 | return _ConnectionFair
heatengine_1 | File "/usr/lib64/
heatengine_1 | fairy = _ConnectionReco
heatengine_1 | File "/usr/lib64/
heatengine_1 | rec = pool._do_get()
heatengine_1 | File "/usr/lib64/
heatengine_1 | return self._create_
heatengine_1 | File "/usr/lib64/
heatengine_1 | return _ConnectionReco
heatengine_1 | File "/usr/lib64/
heatengine_1 | self.connection = self.__connect()
heatengine_1 | File "/usr/lib64/
heatengine_1 | connection = self.__
heatengine_1 | File "/usr/lib/
heatengine_1 | raise original_exception
heatengine_1 | OperationalError: (OperationalError) (1040, 'Too many connections') None None
Increasing the max_connection count fixes this problem.
Changed in kolla: | |
status: | In Progress → Fix Committed |
Changed in kolla: | |
status: | Fix Committed → Fix Released |
Fix proposed to branch: master /review. openstack. org/192011
Review: https:/