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) < [email protected]> 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@Storage devstack]$ cinder list > > ERROR: Internal Server Error (HTTP 500) (Request-ID: > req-519d330d-5b14-4705-9f3d-937de00a61e0) > > [stack@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: [email protected]?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > -- Duncan Thomas
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
