Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Unknown column 'volumes.instance_uuid' in 'field list'

when we finish installation of cinder on block storage node, when type '# cinder-volume' to start cinder-volume, error came like this:

2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup Traceback (most recent call last):
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/threadgroup.py", line 143, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     x.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/threadgroup.py", line 47, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self.thread.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 168, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self._exit_event.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/event.py", line 116, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return hubs.get_hub().switch()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 187, in switch
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self.greenlet.switch()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 194, in main
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     result = function(*args, **kwargs)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/service.py", line 500, in run_service
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     service.start()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/service.py", line 141, in start
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     self.manager.init_host()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/osprofiler/profiler.py", line 105, in wrapper
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return f(*args, **kwargs)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/volume/manager.py", line 261, in init_host
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     volumes = self.db.volume_get_all_by_host(ctxt, self.host)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/db/api.py", line 222, in volume_get_all_by_host
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return IMPL.volume_get_all_by_host(context, host)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line 154, in wrapper
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return f(*args, **kwargs)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line 1273, in volume_get_all_by_host
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     result = _volume_get_query(context).filter(or_(*conditions)).all()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2300, in all
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return list(self)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2412, in __iter__
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self._execute_and_instances(context)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2427, in _execute_and_instances
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     result = conn.execute(querycontext.statement, self._params)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return meth(self, multiparams, params)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return connection._execute_clauseelement(self, multiparams, params)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     compiled_sql, distilled_params
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     context)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     util.raise_from_cause(newraise, exc_info)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     reraise(type(exception), exception, tb=exc_tb)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     context)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     cursor.execute(statement, parameters)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     self.errorhandler(self, exc, value)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     raise errorclass, errorvalue
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup OperationalError: (OperationalError) (1054, "Unknown column 'volumes.instance_uuid' in 'field list'") 'SELECT volumes.created_at AS volumes_created_at, volumes.updated_at AS volumes_updated_at, volumes.deleted_at AS volumes_deleted_at, volumes.id AS volumes_id, volumes._name_id AS volumes__name_id, volumes.ec2_id AS volumes_ec2_id, volumes.user_id AS volumes_user_id, volumes.project_id AS volumes_project_id, volumes.snapshot_id AS volumes_snapshot_id, volumes.host AS volumes_host, volumes.size AS volumes_size, volumes.availability_zone AS volumes_availability_zone, volumes.instance_uuid AS volumes_instance_uuid, volumes.attached_host AS volumes_attached_host, volumes.mountpoint AS volumes_mountpoint, volumes.attach_time AS volumes_attach_time, volumes.status AS volumes_status, volumes.attach_status AS volumes_attach_status, volumes.migration_status AS volumes_migration_status, volumes.scheduled_at AS volumes_scheduled_at, volumes.launched_at AS volumes_launched_at, volumes.terminated_at AS volumes_terminated_at, volumes.display_name AS volumes_display_name, volumes.display_description AS volumes_display_description, volumes.provider_location AS volumes_provider_location, volumes.provider_auth AS volumes_provider_auth, volumes.provider_geometry AS volumes_provider_geometry, volumes.volume_type_id AS volumes_volume_type_id, volumes.source_volid AS volumes_source_volid, volumes.encryption_key_id AS volumes_encryption_key_id, volumes.consistencygroup_id AS volumes_consistencygroup_id, volumes.deleted AS volumes_deleted, volumes.bootable AS volumes_bootable, volumes.replication_status AS volumes_replication_status, volumes.replication_extended_status AS volumes_replication_extended_status, volumes.replication_driver_data AS volumes_replication_driver_data, consistencygroups_1.created_at AS consistencygroups_1_created_at, consistencygroups_1.updated_at AS consistencygroups_1_updated_at, consistencygroups_1.deleted_at AS consistencygroups_1_deleted_at, consistencygroups_1.deleted AS consistencygroups_1_deleted, consistencygroups_1.id AS consistencygroups_1_id, consistencygroups_1.user_id AS consistencygroups_1_user_id, consistencygroups_1.project_id AS consistencygroups_1_project_id, consistencygroups_1.host AS consistencygroups_1_host, consistencygroups_1.availability_zone AS consistencygroups_1_availability_zone, consistencygroups_1.name AS consistencygroups_1_name, consistencygroups_1.description AS consistencygroups_1_description, consistencygroups_1.volume_type_id AS consistencygroups_1_volume_type_id, consistencygroups_1.status AS consistencygroups_1_status, volume_metadata_1.created_at AS volume_metadata_1_created_at, volume_metadata_1.updated_at AS volume_metadata_1_updated_at, volume_metadata_1.deleted_at AS volume_metadata_1_deleted_at, volume_metadata_1.deleted AS volume_metadata_1_deleted, volume_metadata_1.id AS volume_metadata_1_id, volume_metadata_1.`key` AS volume_metadata_1_key, volume_metadata_1.value AS volume_metadata_1_value, volume_metadata_1.volume_id AS volume_metadata_1_volume_id, volume_types_1.created_at AS volume_types_1_created_at, volume_types_1.updated_at AS volume_types_1_updated_at, volume_types_1.deleted_at AS volume_types_1_deleted_at, volume_types_1.deleted AS volume_types_1_deleted, volume_types_1.id AS volume_types_1_id, volume_types_1.name AS volume_types_1_name, volume_types_1.qos_specs_id AS volume_types_1_qos_specs_id, volume_admin_metadata_1.created_at AS volume_admin_metadata_1_created_at, volume_admin_metadata_1.updated_at AS volume_admin_metadata_1_updated_at, volume_admin_metadata_1.deleted_at AS volume_admin_metadata_1_deleted_at, volume_admin_metadata_1.deleted AS volume_admin_metadata_1_deleted, volume_admin_metadata_1.id AS volume_admin_metadata_1_id, volume_admin_metadata_1.`key` AS volume_admin_metadata_1_key, volume_admin_metadata_1.value AS volume_admin_metadata_1_value, volume_admin_metadata_1.volume_id AS volume_admin_metadata_1_volume_id \nFROM volumes LEFT OUTER JOIN consistencygroups AS consistencygroups_1 ON volumes.consistencygroup_id = consistencygroups_1.id LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = volumes.id AND volume_metadata_1.deleted = 0 LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = volume_types_1.id AND volume_types_1.deleted = 0 LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id = volumes.id AND volume_admin_metadata_1.deleted = 0 \nWHERE volumes.deleted = 0 AND (volumes.host = %s OR (volumes.host LIKE %s))' ('ISeR-Server6@lvm', 'ISeR-Server6@lvm#%')

My cinder DB version is 41, can anybody help to solve this problem?