yahoo-eng-team team mailing list archive

[Yaguang Tang <heut2008@xxxxxxxxx>]

** 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