OpenStack Compute (nova)

WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 8 attempts left.

Asked by MANOJ KUMAR YADAV

nova-manage service list
2012-09-20 02:13:23 DEBUG nova.utils [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] backend <module 'nova.db.sqlalchemy.api' from '/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.pyc'> from (pid=6028) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:658
2012-09-20 02:13:23 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 10 attempts left.
2012-09-20 02:13:33 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 9 attempts left.
2012-09-20 02:13:43 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 8 attempts left.
2012-09-20 02:13:53 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 7 attempts left.
2012-09-20 02:14:03 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 6 attempts left.
2012-09-20 02:14:13 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 5 attempts left.
2012-09-20 02:14:23 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 4 attempts left.
2012-09-20 02:14:33 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 3 attempts left.
2012-09-20 02:14:43 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 2 attempts left.
2012-09-20 02:14:53 WARNING nova.db.sqlalchemy.session [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] SQL connection failed. 1 attempts left.
Command failed, please check log for more info
2012-09-20 02:15:03 CRITICAL nova [req-b6bbc073-bec0-4b8b-961a-7ff06ca8120d None None] (OperationalError) (2003, "Can't connect to MySQL server on '210.212.97.140' (111)") None None
2012-09-20 02:15:03 TRACE nova Traceback (most recent call last):
2012-09-20 02:15:03 TRACE nova File "/usr/bin/nova-manage", line 1746, in <module>
2012-09-20 02:15:03 TRACE nova main()
2012-09-20 02:15:03 TRACE nova File "/usr/bin/nova-manage", line 1733, in main
2012-09-20 02:15:03 TRACE nova fn(*fn_args, **fn_kwargs)
2012-09-20 02:15:03 TRACE nova File "/usr/bin/nova-manage", line 964, in list
2012-09-20 02:15:03 TRACE nova services = db.service_get_all(ctxt)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 107, in service_get_all
2012-09-20 02:15:03 TRACE nova return IMPL.service_get_all(context, disabled)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 102, in wrapper
2012-09-20 02:15:03 TRACE nova return f(*args, **kwargs)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 268, in service_get_all
2012-09-20 02:15:03 TRACE nova query = model_query(context, models.Service)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 175, in model_query
2012-09-20 02:15:03 TRACE nova session = kwargs.get('session') or get_session()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/session.py", line 45, in get_session
2012-09-20 02:15:03 TRACE nova engine = get_engine()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/session.py", line 143, in get_engine
2012-09-20 02:15:03 TRACE nova _ENGINE.connect()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2322, in connect
2012-09-20 02:15:03 TRACE nova return self._connection_cls(self, **kwargs)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 872, in __init__
2012-09-20 02:15:03 TRACE nova self.__connection = connection or engine.raw_connection()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2408, in raw_connection
2012-09-20 02:15:03 TRACE nova return self.pool.unique_connection()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 169, in unique_connection
2012-09-20 02:15:03 TRACE nova return _ConnectionFairy(self).checkout()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 371, in __init__
2012-09-20 02:15:03 TRACE nova rec = self._connection_record = pool._do_get()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 697, in _do_get
2012-09-20 02:15:03 TRACE nova con = self._create_connection()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 174, in _create_connection
2012-09-20 02:15:03 TRACE nova return _ConnectionRecord(self)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 256, in __init__
2012-09-20 02:15:03 TRACE nova self.connection = self.__connect()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 316, in __connect
2012-09-20 02:15:03 TRACE nova connection = self.__pool._creator()
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
2012-09-20 02:15:03 TRACE nova return dialect.connect(*cargs, **cparams)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 280, in connect
2012-09-20 02:15:03 TRACE nova return self.dbapi.connect(*cargs, **cparams)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2012-09-20 02:15:03 TRACE nova return Connection(*args, **kwargs)
2012-09-20 02:15:03 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2012-09-20 02:15:03 TRACE nova super(Connection, self).__init__(*args, **kwargs2)
2012-09-20 02:15:03 TRACE nova OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on '210.212.97.140' (111)") None None
2012-09-20 02:15:03 TRACE nova

Question information

Language:
English Edit question
Status:
Answered
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Armando Migliaccio (armando-migliaccio) said : 		#1

Ensure:

1) your DB is up and running
2) you can reach it from the host from where you're running nova-manage
3) nova.conf is configured with the right connection string.

Can you help with this problem?

Provide an answer of your own, or ask MANOJ KUMAR YADAV for more information if necessary.

To post a message you must log in.