** Changed in: nova
Status: New => Invalid
--
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/1153698
Title:
nova service crash with error "Table 'nova.services' doesn't exist"
Status in OpenStack Compute (Nova):
Invalid
Bug description:
Precise 12.04
Grizzly
After the nova gets installed, the nova-cert, nova-conductor and nova-
scheduler crash due to below error logged in their corresponding log
[/var/log/nova] -
TRACE nova return f(*args, **kwargs)
TRACE nova File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 399, in
service_get_by_args
TRACE nova filter_by(binary=binary).\
TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2156, in first
TRACE nova ret = list(self[0:1])
TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2023, in __getitem__
TRACE nova return list(res)
TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2227, in __iter__
TRACE nova return self._execute_and_instances(context)
TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2242, in _execute_and_instances
TRACE nova result = conn.execute(querycontext.statement, self._params)
TRACE nova File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in
execute
TRACE nova params)
TRACE nova File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in
_execute_clauseelement
TRACE nova compiled_sql, distilled_params
TRACE nova File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in
_execute_context
TRACE nova context)
TRACE nova File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1850, in
_handle_dbapi_exception
TRACE nova None, sys.exc_info()[2]
TRACE nova ProgrammingError: (ProgrammingError) (1146, "Table 'nova.services'
doesn't exist")
'SELECT services.created_at AS services_created_at, services.updated_at AS
services_updated_at,
services.deleted_at AS services_deleted_at, services.deleted AS
services_deleted, services.id AS services_id,
services.host AS services_host, services.`binary` AS services_binary,
services.topic AS services_topic,
services.report_count AS services_report_count, services.disabled AS
services_disabled \nFROM services
\nWHERE services.deleted = %s AND services.host = %s AND services.`binary` =
%s \n LIMIT %s' (0, 'grizzly', 'nova-cert', 1)
TRACE nova
nova-manage db sync solves the problem.
The services should not crash until a nova db sync. Looks like a bug
which needs to be fixed.
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1153698/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
