[openstack-dev] Cinder list and cinder create generating error as unknown column instance_uuid in cinder.volumes

Duncan Thomas duncan.thomas at gmail.com
Tue Mar 31 07:09:28 UTC 2015


Does running 'sudo cinder db sync' fix the problem (this runs all migration
scripts needed to bring the db up to the current schema)?

On 31 March 2015 at 10:05, Kamsali, RaghavendraChari (Artesyn) <
RaghavendraChari.Kamsali at artesyn.com> wrote:

>
>
> Hi,
>
>
>
> Am using openstack/juno and I bring up the setup like controller node and
> storage node, when I created volumes or getting list of volumes it is
> generating error as shown below .
>
>
>
>
>
>
>
> [stack at Storage devstack]$ cinder list
>
> ERROR: Internal Server Error (HTTP 500) (Request-ID:
> req-519d330d-5b14-4705-9f3d-937de00a61e0)
>
> [stack at Storage devstack]$
>
>
>
>
>
> *c-api.log*
>
>
>
>
>
> from (pid=24777) _http_log_response
> /usr/lib/python2.7/site-packages/keystoneclient/session.py:223
>
> 2015-03-31 12:29:39.300 INFO cinder.api.openstack.wsgi
> [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8
> e4e2d713323a4a66be5994f85ce91101] GET
> http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail
>
> 2015-03-31 12:29:39.301 DEBUG cinder.api.openstack.wsgi
> [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8
> e4e2d713323a4a66be5994f85ce91101] Empty body provided in request from
> (pid=24777) get_body /opt/stack/cinder/cinder/api/openstack/wsgi.py:789
>
> 2015-03-31 12:29:39.324 ERROR cinder.api.middleware.fault
> [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8
> e4e2d713323a4a66be5994f85ce91101] Caught error: (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.project_id = %s ORDER BY volumes.created_at DESC,
> volumes.created_at DESC, volumes.id DESC'
> ('e4e2d713323a4a66be5994f85ce91101',)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault Traceback (most
> recent call last):
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/middleware/fault.py", line 76, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> req.get_response(self.application)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/request.py", line 1320, in send
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     application,
> catch_exc_info=False)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/request.py", line 1284, in
> call_application
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     app_iter =
> application(self.environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> resp(environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     resp =
> self.call_func(req, *args, **self.kwargs)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self.func(req, *args, **kwargs)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/osprofiler/web.py", line 99, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> request.get_response(self.application)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/request.py", line 1320, in send
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     application,
> catch_exc_info=False)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/request.py", line 1284, in
> call_application
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     app_iter =
> application(self.environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/keystonemiddleware/auth_token/__init__.py",
> line 634, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self._call_app(env, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/keystonemiddleware/auth_token/__init__.py",
> line 554, in _call_app
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self._app(env, _fake_start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> resp(environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> resp(environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/routes/middleware.py", line 131, in
> __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     response =
> self.app(environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> resp(environ, start_response)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     resp =
> self.call_func(req, *args, **self.kwargs)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self.func(req, *args, **kwargs)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 897, in __call__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> content_type, body, accept)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 945, in
> _process_stack
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> action_result = self.dispatch(meth, request, action_args)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 1021, in dispatch
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> method(req=request, **action_args)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/v1/volumes.py", line 264, in detail
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self._items(req, entity_maker=_translate_volume_detail_view)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/api/v1/volumes.py", line 285, in _items
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> viewable_admin_meta=True)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/volume/api.py", line 398, in get_all
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> filters=filters)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/db/api.py", line 234, in volume_get_all_by_project
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     sort_key,
> sort_dir, filters=filters)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 172, in wrapper
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> f(*args, **kwargs)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 1315, in
> volume_get_all_by_project
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> query.all()
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2320, in
> all
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> list(self)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in
> __iter__
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> self._execute_and_instances(context)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in
> _execute_and_instances
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     result =
> conn.execute(querycontext.statement, self._params)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729,
> in execute
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> meth(self, multiparams, params)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322,
> in _execute_on_connection
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     return
> connection._execute_clauseelement(self, multiparams, params)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826,
> in _execute_clauseelement
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> compiled_sql, distilled_params
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958,
> in _execute_context
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     context)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/compat/handle_error.py",
> line 261, in _handle_dbapi_exception
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     e,
> statement, parameters, cursor, context)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1155,
> in _handle_dbapi_exception
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> util.raise_from_cause(newraise, exc_info)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199,
> in raise_from_cause
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> reraise(type(exception), exception, tb=exc_tb)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951,
> in _execute_context
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     context)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> 436, in do_execute
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> cursor.execute(statement, parameters)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in
> execute
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> self.errorhandler(self, exc, value)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in
> defaulterrorhandler
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault     raise
> errorclass, errorvalue
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
> 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.project_id = %s ORDER BY volumes.created_at DESC,
> volumes.created_at DESC, volumes.id DESC'
> ('e4e2d713323a4a66be5994f85ce91101',)
>
> 2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault
>
> 2015-03-31 12:29:39.327 INFO cinder.api.middleware.fault
> [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8
> e4e2d713323a4a66be5994f85ce91101]
> http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail
> returned with HTTP 500
>
> 2015-03-31 12:29:39.328 INFO eventlet.wsgi.server
> [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8
> e4e2d713323a4a66be5994f85ce91101] 192.168.21.107 - - [31/Mar/2015 12:29:39]
> "GET /v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail HTTP/1.1" 500 425
> 0.108592
>
>
>
>
>
>
>
>
>
> *Cinder database volumes description *
>
>
>
>
>
> MariaDB [cinder]> desc volumes;
>
>
> +-----------------------------+--------------+------+-----+---------+-------+
>
> | Field                       | Type         | Null | Key | Default |
> Extra |
>
>
> +-----------------------------+--------------+------+-----+---------+-------+
>
> | created_at                  | datetime     | YES  |     | NULL
> |       |
>
> | updated_at                  | datetime     | YES  |     | NULL
> |       |
>
> | deleted_at                  | datetime     | YES  |     | NULL
> |       |
>
> | deleted                     | tinyint(1)   | YES  |     | NULL
> |       |
>
> | id                          | varchar(36)  | NO   | PRI | NULL
> |       |
>
> | ec2_id                      | varchar(255) | YES  |     | NULL
> |       |
>
> | user_id                     | varchar(255) | YES  |     | NULL
> |       |
>
> | project_id                  | varchar(255) | YES  |     | NULL
> |       |
>
> | host                        | varchar(255) | YES  |     | NULL
> |       |
>
> | size                        | int(11)      | YES  |     | NULL
> |       |
>
> | availability_zone           | varchar(255) | YES  |     | NULL
> |       |
>
> | status                      | varchar(255) | YES  |     | NULL
>   |       |
>
> | attach_status               | varchar(255) | YES  |     | NULL
> |       |
>
> | scheduled_at                | datetime     | YES  |     | NULL
> |       |
>
> | launched_at                 | datetime     | YES  |     | NULL
> |       |
>
> | terminated_at               | datetime     | YES  |     | NULL
> |       |
>
> | display_name                | varchar(255) | YES  |     | NULL
> |       |
>
> | display_description         | varchar(255) | YES  |     | NULL
> |       |
>
> | provider_location           | varchar(256) | YES  |     | NULL
> |       |
>
> | provider_auth               | varchar(256) | YES  |     | NULL
> |       |
>
> | snapshot_id                 | varchar(36)  | YES  |     | NULL
> |       |
>
> | volume_type_id              | varchar(36)  | YES  |     | NULL
> |       |
>
> | source_volid                | varchar(36)  | YES  |     | NULL
> |       |
>
> | bootable                    | tinyint(1)   | YES  |     | NULL
> |       |
>
> | provider_geometry           | varchar(255) | YES  |     | NULL
> |       |
>
> | _name_id                    | varchar(36)  | YES  |     | NULL
> |       |
>
> | encryption_key_id           | varchar(36)  | YES  |     | NULL
> |       |
>
> | migration_status            | varchar(255) | YES  |     | NULL
> |       |
>
> | replication_status          | varchar(255) | YES  |     | NULL
> |       |
>
> | replication_extended_status | varchar(255) | YES  |     | NULL
> |       |
>
> | replication_driver_data     | varchar(255) | YES  |     | NULL
> |       |
>
> | consistencygroup_id         | varchar(36)  | YES  | MUL | NULL
> |       |
>
> | provider_id                 | varchar(255) | YES  |     | NULL
> |       |
>
> | multiattach                 | tinyint(1)   | YES  |     | NULL
> |       |
>
>
> +-----------------------------+--------------+------+-----+---------+-------+
>
> 34 rows in set (0.00 sec)
>
>
>
> Here no column exist instance_uuid.
>
>
>
>
>
>
>
> Thanks and Regards,
>
> *Raghavendrachari kamsali *| Software Engineer II  | Embedded Computing
>
> *Artesyn Embedded Technologies* | 5th Floor, Capella Block, The V,
> Madhapur| Hyderabad, AP 500081 India
>
> T +91-40-66747059 | M +919705762153
>
>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>


-- 
Duncan Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150331/7d37584f/attachment.html>


More information about the OpenStack-dev mailing list