Open Stack

Hello,

I encountered an issue on a clean openstack havana install (one controller
node, two compute nodes, and one network node)  when creating multiple
instances. Some instances were created but other entered in the error
state. Looking in the logs I noticed that the openstack-nova-scheduler had
some database related errors (logs can be found bellow). Has anyone
encountered this issue? What is causing this?

Regards,
Stefan

The error in the nova-scheduler log:
Error during SchedulerManager._expire_reservations: (OperationalError)
(1054, "Unknown column 'reservations.user_id' in 'field list'") 'SELECT
reservations.created_at AS reservations_created_at, reservations.updated_at
AS reservations_updated_at, reservations.deleted_at AS
reservations_deleted_at, reservations.deleted AS reservations_deleted,
reservations.id AS reservations_id, reservations.uuid AS reservations_uuid,
reservations.usage_id AS reservations_usage_id, reservations.project_id AS
reservations_project_id, reservations.user_id AS reservations_user_id,
reservations.resource AS reservations_resource, reservations.delta AS
reservations_delta, reservations.expire AS reservations_expire \nFROM
reservations INNER JOIN quota_usages ON quota_usages.id =
reservations.usage_id \nWHERE reservations.deleted = %s AND
reservations.expire < %s' (0, datetime.datetime(2014, 3, 18, 12, 58, 8,
784970))
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
Traceback (most recent call last):
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib/python2.6/site-packages/nova/openstack/common/periodic_task.py",
line 180, in run_periodic_tasks
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
task(self, context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/scheduler/manager.py", line
273, in _expire_reservations
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
QUOTAS.expire(context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/quota.py", line 1368, in expire
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
self._driver.expire(context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/quota.py", line 609, in expire
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
db.reservation_expire(context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/db/api.py", line 1112, in
reservation_expire
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
return IMPL.reservation_expire(context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py", line
108, in wrapper
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
return f(*args, **kwargs)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py", line
3337, in reservation_expire
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task for
reservation in reservation_query.join(models.QuotaUsage).all():
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py",
line 2115, in all
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
return list(self)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py",
line 2227, in _*iter*_
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
return self._execute_and_instances(context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/query.py",
line 2242, in _execute_and_instances
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
result = conn.execute(querycontext.statement, self._params)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1449, in execute
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
params)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1584, in _execute_clauseelement
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
compiled_sql, distilled_params
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1698, in _execute_context
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py",
line 1691, in _execute_context
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
context)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py",
line 331, in do_execute
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
cursor.execute(statement, parameters)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in
execute
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
self.errorhandler(self, exc, value)
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
raise errorclass, errorvalue
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
OperationalError: (OperationalError) (1054, "Unknown column
'reservations.user_id' in 'field list'") 'SELECT reservations.created_at AS
reservations_created_at, reservations.updated_at AS
reservations_updated_at, reservations.deleted_at AS
reservations_deleted_at, reservations.deleted AS reservations_deleted,
reservations.id AS reservations_id, reservations.uuid AS reservations_uuid,
reservations.usage_id AS reservations_usage_id, reservations.project_id AS
reservations_project_id, reservations.user_id AS reservations_user_id,
reservations.resource AS reservations_resource, reservations.delta AS
reservations_delta, reservations.expire AS reservations_expire \nFROM
reservations INNER JOIN quota_usages ON quota_usages.id =
reservations.usage_id \nWHERE reservations.deleted = %s AND
reservations.expire < %s' (0, datetime.datetime(2014, 3, 18, 12, 58, 8,
784970))
2014-03-18 05:58:08.827 24056 TRACE nova.openstack.common.periodic_task
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140318/697fc179/attachment.html>