nova service crash with error "Table 'nova.services' doesn't exist"

[Sandeep Raman]

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.

[Sandeep Raman (sandeep-raman)]

May i request if you could comment the reason behind changing status to "Invalid". Is this expected behaviour?