回复 45# zhanghao001122 不好意思,我还有个问题想请教下:
我昨天用另外两台刀片搭建的测试环境本来运行好好的,今天发现一个奇怪的现象
在控制节点上,运行nova-manage或nova list等nova查看命令时,出现报错(隔几个小时就会这样,重启控制节点后会正常几个小时,过几个小时就报错了)
root@hwnode6:/home/ubuntu# nova-manage service list
Command failed, please check log for more info
2015-05-26 17:10:47.924 21851 CRITICAL nova [req-dbd34fff-ca47-4019-b4a0-b30ed19c971d None None] OperationalError: (OperationalError) (1040, 'Too many connections') None None
2015-05-26 17:10:47.924 21851 TRACE nova Traceback (most recent call last):
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/bin/nova-manage", line 10, in
2015-05-26 17:10:47.924 21851 TRACE nova sys.exit(main())
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1376, in main
2015-05-26 17:10:47.924 21851 TRACE nova ret = fn(*fn_args, **fn_kwargs)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 687, in list
2015-05-26 17:10:47.924 21851 TRACE nova services = db.service_get_all(ctxt)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 111, in service_get_all
2015-05-26 17:10:47.924 21851 TRACE nova return IMPL.service_get_all(context, disabled)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 146, in wrapper
2015-05-26 17:10:47.924 21851 TRACE nova return f(*args, **kwargs)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 451, in service_get_all
2015-05-26 17:10:47.924 21851 TRACE nova query = model_query(context, models.Service)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 234, in model_query
2015-05-26 17:10:47.924 21851 TRACE nova session = kwargs.get('session') or get_session(use_slave=use_slave)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 122, in get_session
2015-05-26 17:10:47.924 21851 TRACE nova facade = _create_facade_lazily(use_slave)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 104, in _create_facade_lazily
2015-05-26 17:10:47.924 21851 TRACE nova **dict(CONF.database.iteritems())
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 839, in __init__
2015-05-26 17:10:47.924 21851 TRACE nova retry_interval=kwargs.get('retry_interval', 10))
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 652, in create_engine
2015-05-26 17:10:47.924 21851 TRACE nova engine.connect()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1641, in connect
2015-05-26 17:10:47.924 21851 TRACE nova return self._connection_cls(self, **kwargs)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 59, in __init__
2015-05-26 17:10:47.924 21851 TRACE nova self.__connection = connection or engine.raw_connection()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1699, in raw_connection
2015-05-26 17:10:47.924 21851 TRACE nova return self.pool.unique_connection()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 220, in unique_connection
2015-05-26 17:10:47.924 21851 TRACE nova return _ConnectionFairy(self).checkout()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 431, in __init__
2015-05-26 17:10:47.924 21851 TRACE nova rec = self._connection_record = pool._do_get()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 772, in _do_get
2015-05-26 17:10:47.924 21851 TRACE nova return self._create_connection()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 225, in _create_connection
2015-05-26 17:10:47.924 21851 TRACE nova return _ConnectionRecord(self)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in __init__
2015-05-26 17:10:47.924 21851 TRACE nova self.connection = self.__connect()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 379, in __connect
2015-05-26 17:10:47.924 21851 TRACE nova connection = self.__pool._creator()
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
2015-05-26 17:10:47.924 21851 TRACE nova return dialect.connect(*cargs, **cparams)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 283, in connect
2015-05-26 17:10:47.924 21851 TRACE nova return self.dbapi.connect(*cargs, **cparams)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2015-05-26 17:10:47.924 21851 TRACE nova return Connection(*args, **kwargs)
2015-05-26 17:10:47.924 21851 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2015-05-26 17:10:47.924 21851 TRACE nova super(Connection, self).__init__(*args, **kwargs2)
2015-05-26 17:10:47.924 21851 TRACE nova OperationalError: (OperationalError) (1040, 'Too many connections') None None
2015-05-26 17:10:47.924 21851 TRACE nova
root@hwnode6:/home/ubuntu# reboot
大神帮我看看这大概是什么问题呢