[Openstack] Keystone "Too many connections" Error on Icehouse

Sushma Korati sushma_korati at persistent.co.in
Mon Aug 18 06:07:56 UTC 2014


I suppose the issue is because all the openstack components are trying to connect to a single Mysql.
Please try updating value of "max_connections" in /etc/mysql/my.cnf file, and restart the mysql service.

Sushma Korati
sushma_korati at persistent.co.in
Persistent Systems Ltd. |  Partners in Innovation | www.persistentsys.com

From: ZHOU TAO A <tao.a.zhou at alcatel-lucent.com>
Sent: Friday, August 15, 2014 1:50 PM
To: openstack at lists.openstack.org
Subject: [Openstack] Keystone "Too many connections" Error on Icehouse

Hi all,

Has anyone met the 'too many connections' error on IceHouse.
In my case, it only happen to cinder and heat; nova is fine. And after
restarting keystone, everything works fine. But after some while, it
will happen again.

I have another deployment which also has the same issue.

heat stack-delete ieccf301-stg
ERROR: Remote error: OperationalError (OperationalError) (1040, 'Too
many connections') None None


[u'Traceback (most recent call last):\n', u'  File
line 462, in _process_data\n    **args)\n', u'  File
line 172, in dispatch\n    result = getattr(proxyobj, method)(ctxt,
**kwargs)\n', u'  File
"/usr/lib/python2.6/site-packages/heat/engine/service.py", line 63, in
wrapped\n    return func(self, ctx, *args, **kwargs)\n', u'  File
"/usr/lib/python2.6/site-packages/heat/engine/service.py", line 407, in
list_stacks\n    sort_dir, filters, tenant_safe) or []\n', u' File
"/usr/lib/python2.6/site-packages/heat/db/api.py", line 125, in
stack_get_all\n    marker, sort_dir, filters, tenant_safe)\n', u' File
"/usr/lib/python2.6/site-packages/heat/db/sqlalchemy/api.py", line 346,
in stack_get_all\n    marker, sort_dir, filters).all()\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2241,
in all\n    return list(self)\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2353,
in __iter__\n    return self._execute_and_instances(context)\n', u'
File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line
2366, in _execute_and_instances\n    close_with_result=True)\n', u' File
"/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2357,
in _connection_from_session\n    **kw)\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line
799, in connection\n    close_with_result=close_with_result)\n', u' File
"/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line
805, in _connection_for_bind\n    return
engine.contextual_connect(**kwargs)\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line
1661, in contextual_connect\n    self.pool.connect(),\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 272, in
connect\n    return _ConnectionFairy(self).checkout()\n', u' File
"/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 431, in
__init__\n    rec = self._connection_record = pool._do_get()\n', u'
File "/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 772,
in _do_get\n    return self._create_connection()\n', u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 225, in
_create_connection\n    return _ConnectionRecord(self)\n', u' File
"/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 318, in
__init__\n    self.connection = self.__connect()\n', u' File
"/usr/lib64/python2.6/site-packages/sqlalchemy/pool.py", line 379, in
__connect\n    connection = self.__pool._creator()\n', u' File
line 80, in connect\n    return dialect.connect(*cargs, **cparams)\n',
u'  File
"/usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py", line
283, in connect\n    return self.dbapi.connect(*cargs, **cparams)\n',
u'  File "/usr/lib64/python2.6/site-packages/MySQLdb/__init__.py", line
81, in Connect\n    return Connection(*args, **kwargs)\n', u'  File
"/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 187,
in __init__\n    super(Connection, self).__init__(*args, **kwargs2)\n',
u"OperationalError: (OperationalError) (1040, 'Too many connections')
None None\n"

Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to     : openstack at lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

More information about the Openstack mailing list