<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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 .<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[stack@Storage devstack]$ cinder list<o:p></o:p></p>
<p class="MsoNormal">ERROR: Internal Server Error (HTTP 500) (Request-ID: req-519d330d-5b14-4705-9f3d-937de00a61e0)<o:p></o:p></p>
<p class="MsoNormal">[stack@Storage devstack]$<o:p></o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><u>c-api.log<o:p></o:p></u></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">from (pid=24777) _http_log_response /usr/lib/python2.7/site-packages/keystoneclient/session.py:223<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">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',)<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault Traceback (most recent call last):<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return req.get_response(self.application)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault application, catch_exc_info=False)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault app_iter = application(self.environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self.func(req, *args, **kwargs)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return request.get_response(self.application)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault application, catch_exc_info=False)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault app_iter = application(self.environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._call_app(env, start_response)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._app(env, _fake_start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault response = self.app(environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self.func(req, *args, **kwargs)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault content_type, body, accept)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault action_result = self.dispatch(meth, request, action_args)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return method(req=request, **action_args)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._items(req, entity_maker=_translate_volume_detail_view)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault viewable_admin_meta=True)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault filters=filters)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault sort_key, sort_dir, filters=filters)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return f(*args, **kwargs)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return query.all()<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return list(self)<o:p></o:p></p>
<p class="MsoNormal">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__<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._execute_and_instances(context)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault result = conn.execute(querycontext.statement, self._params)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return meth(self, multiparams, params)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return connection._execute_clauseelement(self, multiparams, params)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault compiled_sql, distilled_params<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault context)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault e, statement, parameters, cursor, context)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault util.raise_from_cause(newraise, exc_info)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault reraise(type(exception), exception, tb=exc_tb)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault context)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault cursor.execute(statement, parameters)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault self.errorhandler(self, exc, value)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault raise errorclass, errorvalue<o:p></o:p></p>
<p class="MsoNormal">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',)<o:p></o:p></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault <o:p>
</o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><u>Cinder database volumes description <o:p></o:p></u></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">MariaDB [cinder]> desc volumes;<o:p></o:p></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<o:p></o:p></p>
<p class="MsoNormal">| Field | Type | Null | Key | Default | Extra |<o:p></o:p></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<o:p></o:p></p>
<p class="MsoNormal">| created_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| updated_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| deleted_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| deleted | tinyint(1) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| id | varchar(36) | NO | PRI | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| ec2_id | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| user_id | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| project_id | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| host | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| size | int(11) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| availability_zone | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| status | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| attach_status | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| scheduled_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| launched_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| terminated_at | datetime | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| display_name | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| display_description | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| provider_location | varchar(256) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| provider_auth | varchar(256) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| snapshot_id | varchar(36) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| volume_type_id | varchar(36) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| source_volid | varchar(36) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| bootable | tinyint(1) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| provider_geometry | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| _name_id | varchar(36) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| encryption_key_id | varchar(36) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| migration_status | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| replication_status | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| replication_extended_status | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| replication_driver_data | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| consistencygroup_id | varchar(36) | YES | MUL | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| provider_id | varchar(255) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">| multiattach | tinyint(1) | YES | | NULL | |<o:p></o:p></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<o:p></o:p></p>
<p class="MsoNormal">34 rows in set (0.00 sec)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here no column exist instance_uuid.<o:p></o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">Thanks and Regards,<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#007BB9">Raghavendrachari kamsali
</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:black">| Software Engineer II | Embedded Computing
<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#007BB9">Artesyn Embedded Technologies</span></b><b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#999999">
</span></b><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">|<b>
</b>5th Floor, Capella Block, The V, Madhapur| Hyderabad, AP 500081 India<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D">T +91-40-66747059 | M +919705762153<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>