[openstack-dev] Cinder list and cinder create generating error as unknown column instance_uuid in cinder.volumes
Kamsali, RaghavendraChari (Artesyn)
RaghavendraChari.Kamsali at artesyn.com
Tue Mar 31 07:05:35 UTC 2015
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150331/6afc368e/attachment.html>
More information about the OpenStack-dev
mailing list