Hi, 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.
-HTH, Sushma Korati sushma_kor...@persistent.co.in Persistent Systems Ltd. | Partners in Innovation | www.persistentsys.com ________________________________________ From: ZHOU TAO A <tao.a.z...@alcatel-lucent.com> Sent: Friday, August 15, 2014 1:50 PM To: openstack@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 heat-api.log: [u'Traceback (most recent call last):\n', u' File "/usr/lib/python2.6/site-packages/heat/openstack/common/rpc/amqp.py", line 462, in _process_data\n **args)\n', u' File "/usr/lib/python2.6/site-packages/heat/openstack/common/rpc/dispatcher.py", 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 "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/strategies.py", 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@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack DISCLAIMER ========== 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. _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
