Table 'nova.zones' doesn't exist

Asked by Shirley Woo

My startup of nova-schedule is crashing. The nova-schedule.log says:

2012-03-09 11:12:28,778 AUDIT nova [-] Starting scheduler node (version 2011.3-nova-milestone-tarball:tarmac-20110922115702-k9nkvxqzhj130av2)
2012-03-09 11:12:28,963 DEBUG nova.utils [-] backend <module 'nova.db.sqlalchemy.api' from '/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.pyc'> from (pid=32771) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:450
2012-03-09 11:12:28,965 INFO nova.db.sqlalchemy [-] Using mysql/eventlet db_pool.
2012-03-09 11:12:29,225 INFO nova.rpc [-] Connected to AMQP server on 10.228.24.60:5672
2012-03-09 11:12:29,227 DEBUG nova [-] Creating Consumer connection for Service scheduler from (pid=32771) start /usr/lib/python2.7/dist-packages/nova/service.py:153
2012-03-09 11:13:29,255 DEBUG nova [-] Updating zone cache from db. from (pid=32771) ping /usr/lib/python2.7/dist-packages/nova/scheduler/zone_manager.py:193
2012-03-09 11:13:29,264 ERROR nova [-] in looping call
(nova): TRACE: Traceback (most recent call last):
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/utils.py", line 491, in _inner
(nova): TRACE: self.f(*self.args, **self.kw)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/service.py", line 251, in periodic_tasks
(nova): TRACE: self.manager.periodic_tasks(context.get_admin_context())
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/scheduler/manager.py", line 58, in periodic_tasks
(nova): TRACE: self.zone_manager.ping(context)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/scheduler/zone_manager.py", line 195, in ping
(nova): TRACE: self._refresh_from_db(context)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/scheduler/zone_manager.py", line 170, in _refresh_from_db
(nova): TRACE: zones = db.zone_get_all(context)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 1396, in zone_get_all
(nova): TRACE: return IMPL.zone_get_all(context)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 101, in wrapper
(nova): TRACE: return f(*args, **kwargs)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 3497, in zone_get_all
(nova): TRACE: return session.query(models.Zone).all()
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1983, in all
(nova): TRACE: return list(self)
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2093, in __iter__
(nova): TRACE: return self._execute_and_instances(context)
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2108, in _execute_and_instances
(nova): TRACE: result = conn.execute(querycontext.statement, self._params)
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute
(nova): TRACE: params)
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1538, in _execute_clauseelement
(nova): TRACE: compiled_sql, distilled_params
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
(nova): TRACE: context)
(nova): TRACE: File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1790, in _handle_dbapi_exception
(nova): TRACE: None, sys.exc_info()[2]
(nova): TRACE: ProgrammingError: (ProgrammingError) (1146, "Table 'nova.zones' doesn't exist") 'SELECT zones.created_at AS zones_created_at, zones.updated_at AS zones_updated_at, zones.deleted_at AS zones_deleted_at, zones.deleted AS zones_deleted, zones.id AS zones_id, zones.api_url AS zones_api_url, zones.username AS zones_username, zones.password AS zones_password, zones.weight_offset AS zones_weight_offset, zones.weight_scale AS zones_weight_scale \nFROM zones' ()
(nova): TRACE:

When should the nova.zones table have been created and by who?
The install instructions only creates the nova db.

Any help would be appreciated.
Thanks
--Shirley

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
Russell Bryant (russellb) said :
#1

Run:

$ sudo nova-manage db sync

Can you help with this problem?

Provide an answer of your own, or ask Shirley Woo for more information if necessary.

To post a message you must log in.