<div dir="ltr">Does running 'sudo cinder db sync' fix the problem (this runs all migration scripts needed to bring the db up to the current schema)?</div><div class="gmail_extra"><br><div class="gmail_quote">On 31 March 2015 at 10:05, Kamsali, RaghavendraChari (Artesyn) <span dir="ltr"><<a href="mailto:RaghavendraChari.Kamsali@artesyn.com" target="_blank">RaghavendraChari.Kamsali@artesyn.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></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 .<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">[stack@Storage devstack]$ cinder list<u></u><u></u></p>
<p class="MsoNormal">ERROR: Internal Server Error (HTTP 500) (Request-ID: req-519d330d-5b14-4705-9f3d-937de00a61e0)<u></u><u></u></p>
<p class="MsoNormal">[stack@Storage devstack]$<u></u><u></u></p>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><u>c-api.log<u></u><u></u></u></b></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">from (pid=24777) _http_log_response /usr/lib/python2.7/site-packages/keystoneclient/session.py:223<u></u><u></u></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 <a href="http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail" target="_blank">http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail</a><u></u><u></u></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<u></u><u></u></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, <a href="http://volumes.id" target="_blank">volumes.id</a> 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, <a href="http://consistencygroups_1.id" target="_blank">consistencygroups_1.id</a> 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, <a href="http://consistencygroups_1.name" target="_blank">consistencygroups_1.name</a> 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, <a href="http://volume_metadata_1.id" target="_blank">volume_metadata_1.id</a> 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,
<a href="http://volume_types_1.id" target="_blank">volume_types_1.id</a> AS volume_types_1_id, <a href="http://volume_types_1.name" target="_blank">volume_types_1.name</a> 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, <a href="http://volume_admin_metadata_1.id" target="_blank">volume_admin_metadata_1.id</a> 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
= <a href="http://consistencygroups_1.id" target="_blank">consistencygroups_1.id</a> LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = <a href="http://volumes.id" target="_blank">volumes.id</a> AND volume_metadata_1.deleted = 0 LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = <a href="http://volume_types_1.id" target="_blank">volume_types_1.id</a> AND volume_types_1.deleted
= 0 LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id = <a href="http://volumes.id" target="_blank">volumes.id</a> 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, <a href="http://volumes.id" target="_blank">volumes.id</a> DESC' ('e4e2d713323a4a66be5994f85ce91101',)<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault Traceback (most recent call last):<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return req.get_response(self.application)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault application, catch_exc_info=False)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault app_iter = application(self.environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self.func(req, *args, **kwargs)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return request.get_response(self.application)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault application, catch_exc_info=False)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault app_iter = application(self.environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._call_app(env, start_response)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._app(env, _fake_start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault response = self.app(environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return resp(environ, start_response)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault resp = self.call_func(req, *args, **self.kwargs)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self.func(req, *args, **kwargs)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault content_type, body, accept)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault action_result = self.dispatch(meth, request, action_args)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return method(req=request, **action_args)<u></u><u></u></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<u></u><u></u></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)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault viewable_admin_meta=True)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault filters=filters)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault sort_key, sort_dir, filters=filters)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return f(*args, **kwargs)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return query.all()<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return list(self)<u></u><u></u></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__<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return self._execute_and_instances(context)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault result = conn.execute(querycontext.statement, self._params)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return meth(self, multiparams, params)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault return connection._execute_clauseelement(self, multiparams, params)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault compiled_sql, distilled_params<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault context)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault e, statement, parameters, cursor, context)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault util.raise_from_cause(newraise, exc_info)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault reraise(type(exception), exception, tb=exc_tb)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault context)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault cursor.execute(statement, parameters)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault self.errorhandler(self, exc, value)<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault raise errorclass, errorvalue<u></u><u></u></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, <a href="http://volumes.id" target="_blank">volumes.id</a> 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,
<a href="http://consistencygroups_1.id" target="_blank">consistencygroups_1.id</a> 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, <a href="http://consistencygroups_1.name" target="_blank">consistencygroups_1.name</a> 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,
<a href="http://volume_metadata_1.id" target="_blank">volume_metadata_1.id</a> 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, <a href="http://volume_types_1.id" target="_blank">volume_types_1.id</a> AS volume_types_1_id, <a href="http://volume_types_1.name" target="_blank">volume_types_1.name</a> 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, <a href="http://volume_admin_metadata_1.id" target="_blank">volume_admin_metadata_1.id</a> 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 = <a href="http://consistencygroups_1.id" target="_blank">consistencygroups_1.id</a> LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = <a href="http://volumes.id" target="_blank">volumes.id</a>
AND volume_metadata_1.deleted = 0 LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = <a href="http://volume_types_1.id" target="_blank">volume_types_1.id</a> AND volume_types_1.deleted = 0 LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id
= <a href="http://volumes.id" target="_blank">volumes.id</a> 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, <a href="http://volumes.id" target="_blank">volumes.id</a> DESC' ('e4e2d713323a4a66be5994f85ce91101',)<u></u><u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.324 TRACE cinder.api.middleware.fault <u></u>
<u></u></p>
<p class="MsoNormal">2015-03-31 12:29:39.327 INFO cinder.api.middleware.fault [req-519d330d-5b14-4705-9f3d-937de00a61e0 155aae03e3214f9e8fc411a6395706f8 e4e2d713323a4a66be5994f85ce91101] <a href="http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail" target="_blank">http://192.168.21.108:8776/v1/e4e2d713323a4a66be5994f85ce91101/volumes/detail</a>
returned with HTTP 500<u></u><u></u></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<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><u>Cinder database volumes description <u></u><u></u></u></b></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">MariaDB [cinder]> desc volumes;<u></u><u></u></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<u></u><u></u></p>
<p class="MsoNormal">| Field | Type | Null | Key | Default | Extra |<u></u><u></u></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<u></u><u></u></p>
<p class="MsoNormal">| created_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| updated_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| deleted_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| deleted | tinyint(1) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| id | varchar(36) | NO | PRI | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| ec2_id | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| user_id | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| project_id | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| host | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| size | int(11) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| availability_zone | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| status | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| attach_status | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| scheduled_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| launched_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| terminated_at | datetime | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| display_name | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| display_description | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| provider_location | varchar(256) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| provider_auth | varchar(256) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| snapshot_id | varchar(36) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| volume_type_id | varchar(36) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| source_volid | varchar(36) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| bootable | tinyint(1) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| provider_geometry | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| _name_id | varchar(36) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| encryption_key_id | varchar(36) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| migration_status | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| replication_status | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| replication_extended_status | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| replication_driver_data | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| consistencygroup_id | varchar(36) | YES | MUL | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| provider_id | varchar(255) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">| multiattach | tinyint(1) | YES | | NULL | |<u></u><u></u></p>
<p class="MsoNormal">+-----------------------------+--------------+------+-----+---------+-------+<u></u><u></u></p>
<p class="MsoNormal">34 rows in set (0.00 sec)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Here no column exist instance_uuid.<u></u><u></u></p>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">Thanks and Regards,<u></u><u></u></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
<u></u><u></u></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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1f497d">T <a href="tel:%2B91-40-66747059" value="+914066747059" target="_blank">+91-40-66747059</a> | M <a href="tel:%2B919705762153" value="+919705762153" target="_blank">+919705762153</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Duncan Thomas</div>
</div>