yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1309379] [NEW] can not connect to the database

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: "ynuzgw@xxxxxxxx" <ynuzgw@xxxxxxxx>
Date: Fri, 18 Apr 2014 07:41:28 -0000
Reply-to: Bug 1309379 <1309379@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

when I edit the /etc/hosts file on the controller node, the openstack get down,and the log of nova-manage.log is:
2014-04-16 09:56:38.768 4369 TRACE nova Traceback (most recent call last):
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 1263, in <module>
2014-04-16 09:56:38.768 4369 TRACE nova     main()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 1255, in main
2014-04-16 09:56:38.768 4369 TRACE nova     fn(*fn_args, **fn_kwargs)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 657, in list
2014-04-16 09:56:38.768 4369 TRACE nova     services = db.service_get_all(ctxt)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 132, in service_get_all
2014-04-16 09:56:38.768 4369 TRACE nova     return IMPL.service_get_all(context, disabled)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 97, in wrapper
2014-04-16 09:56:38.768 4369 TRACE nova     return f(*args, **kwargs)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 362, in service_get_all
2014-04-16 09:56:38.768 4369 TRACE nova     query = model_query(context, models.Service)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 178, in model_query
2014-04-16 09:56:38.768 4369 TRACE nova     session = kwargs.get('session') or get_session()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 325, in get_session
2014-04-16 09:56:38.768 4369 TRACE nova     engine = get_engine()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 446, in get_engine
2014-04-16 09:56:38.768 4369 TRACE nova     _ENGINE = create_engine(CONF.sql_connection)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 547, in create_engine
2014-04-16 09:56:38.768 4369 TRACE nova     engine.connect()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2471, in connect
2014-04-16 09:56:38.768 4369 TRACE nova     return self._connection_cls(self, **kwargs)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 878, in __init__
2014-04-16 09:56:38.768 4369 TRACE nova     self.__connection = connection or engine.raw_connection()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2557, in raw_connection
2014-04-16 09:56:38.768 4369 TRACE nova     return self.pool.unique_connection()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 184, in unique_connection
2014-04-16 09:56:38.768 4369 TRACE nova     return _ConnectionFairy(self).checkout()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 401, in __init__
2014-04-16 09:56:38.768 4369 TRACE nova     rec = self._connection_record = pool._do_get()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 746, in _do_get
2014-04-16 09:56:38.768 4369 TRACE nova     con = self._create_connection()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 189, in _create_connection
2014-04-16 09:56:38.768 4369 TRACE nova     return _ConnectionRecord(self)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 282, in __init__
2014-04-16 09:56:38.768 4369 TRACE nova     self.connection = self.__connect()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 344, in __connect
2014-04-16 09:56:38.768 4369 TRACE nova     connection = self.__pool._creator()
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
2014-04-16 09:56:38.768 4369 TRACE nova     return dialect.connect(*cargs, **cparams)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect
2014-04-16 09:56:38.768 4369 TRACE nova     return self.dbapi.connect(*cargs, **cparams)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2014-04-16 09:56:38.768 4369 TRACE nova     return Connection(*args, **kwargs)
2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
2014-04-16 09:56:38.768 4369 TRACE nova     super(Connection, self).__init__(*args, **kwargs2)
2014-04-16 09:56:38.768 4369 TRACE nova OperationalError: (OperationalError) (1045, "Access denied for user 'novaUser'@'compute1' (using password: YES)") None None

the problem is not simply about the openstack, it is about the mysql or
other database. we need to delete the default user from the
corresponding database to avoid the possible trap.

** Affects: nova
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1309379

Title:
  can not connect to the database

Status in OpenStack Compute (Nova):
  New

Bug description:
  when I edit the /etc/hosts file on the controller node, the openstack get down,and the log of nova-manage.log is:
  2014-04-16 09:56:38.768 4369 TRACE nova Traceback (most recent call last):
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 1263, in <module>
  2014-04-16 09:56:38.768 4369 TRACE nova     main()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 1255, in main
  2014-04-16 09:56:38.768 4369 TRACE nova     fn(*fn_args, **fn_kwargs)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/bin/nova-manage", line 657, in list
  2014-04-16 09:56:38.768 4369 TRACE nova     services = db.service_get_all(ctxt)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 132, in service_get_all
  2014-04-16 09:56:38.768 4369 TRACE nova     return IMPL.service_get_all(context, disabled)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 97, in wrapper
  2014-04-16 09:56:38.768 4369 TRACE nova     return f(*args, **kwargs)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 362, in service_get_all
  2014-04-16 09:56:38.768 4369 TRACE nova     query = model_query(context, models.Service)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 178, in model_query
  2014-04-16 09:56:38.768 4369 TRACE nova     session = kwargs.get('session') or get_session()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 325, in get_session
  2014-04-16 09:56:38.768 4369 TRACE nova     engine = get_engine()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 446, in get_engine
  2014-04-16 09:56:38.768 4369 TRACE nova     _ENGINE = create_engine(CONF.sql_connection)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/openstack/common/db/sqlalchemy/session.py", line 547, in create_engine
  2014-04-16 09:56:38.768 4369 TRACE nova     engine.connect()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2471, in connect
  2014-04-16 09:56:38.768 4369 TRACE nova     return self._connection_cls(self, **kwargs)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 878, in __init__
  2014-04-16 09:56:38.768 4369 TRACE nova     self.__connection = connection or engine.raw_connection()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2557, in raw_connection
  2014-04-16 09:56:38.768 4369 TRACE nova     return self.pool.unique_connection()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 184, in unique_connection
  2014-04-16 09:56:38.768 4369 TRACE nova     return _ConnectionFairy(self).checkout()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 401, in __init__
  2014-04-16 09:56:38.768 4369 TRACE nova     rec = self._connection_record = pool._do_get()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 746, in _do_get
  2014-04-16 09:56:38.768 4369 TRACE nova     con = self._create_connection()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 189, in _create_connection
  2014-04-16 09:56:38.768 4369 TRACE nova     return _ConnectionRecord(self)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 282, in __init__
  2014-04-16 09:56:38.768 4369 TRACE nova     self.connection = self.__connect()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 344, in __connect
  2014-04-16 09:56:38.768 4369 TRACE nova     connection = self.__pool._creator()
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
  2014-04-16 09:56:38.768 4369 TRACE nova     return dialect.connect(*cargs, **cparams)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect
  2014-04-16 09:56:38.768 4369 TRACE nova     return self.dbapi.connect(*cargs, **cparams)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
  2014-04-16 09:56:38.768 4369 TRACE nova     return Connection(*args, **kwargs)
  2014-04-16 09:56:38.768 4369 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
  2014-04-16 09:56:38.768 4369 TRACE nova     super(Connection, self).__init__(*args, **kwargs2)
  2014-04-16 09:56:38.768 4369 TRACE nova OperationalError: (OperationalError) (1045, "Access denied for user 'novaUser'@'compute1' (using password: YES)") None None

  the problem is not simply about the openstack, it is about the mysql
  or other database. we need to delete the default user from the
  corresponding database to avoid the possible trap.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1309379/+subscriptions
Follow ups

[Bug 1309379] Re: can not connect to the database
From: Yaguang Tang, 2014-04-19
[Bug 1309379] [NEW] can not connect to the database
From: ynuzgw@xxxxxxxx, 2014-04-18
References

[Bug 1309379] [NEW] can not connect to the database
From: ynuzgw@xxxxxxxx, 2014-04-18