[Openstack] Unable to start NOVA VOLUME

Trinath Somanchi trinath.somanchi at gmail.com
Mon Sep 3 06:59:18 UTC 2012


Hi-

I have Installed Nova Volume in the Openstack Essex Controller. But When I
restart the nova-volume service, I get the following error

2012-09-03 12:26:22 TRACE nova Traceback (most recent call last):
2012-09-03 12:26:22 TRACE nova   File "/usr/bin/nova-volume", line 49, in
<module>
2012-09-03 12:26:22 TRACE nova     service.wait()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 413, in wait
2012-09-03 12:26:22 TRACE nova     _launcher.wait()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 131, in wait
2012-09-03 12:26:22 TRACE nova     service.wait()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 166, in
wait
2012-09-03 12:26:22 TRACE nova     return self._exit_event.wait()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/event.py", line 116, in wait
2012-09-03 12:26:22 TRACE nova     return hubs.get_hub().switch()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 177, in switch
2012-09-03 12:26:22 TRACE nova     return self.greenlet.switch()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 192, in
main
2012-09-03 12:26:22 TRACE nova     result = function(*args, **kwargs)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 101, in run_server
2012-09-03 12:26:22 TRACE nova     server.start()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 162, in start
2012-09-03 12:26:22 TRACE nova     self.manager.init_host()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/volume/manager.py", line 95, in
init_host
2012-09-03 12:26:22 TRACE nova     volumes =
self.db.volume_get_all_by_host(ctxt, self.host)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/api.py", line 958, in
volume_get_all_by_host
2012-09-03 12:26:22 TRACE nova     return
IMPL.volume_get_all_by_host(context, host)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 102, in
wrapper
2012-09-03 12:26:22 TRACE nova     return f(*args, **kwargs)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 2402, in
volume_get_all_by_host
2012-09-03 12:26:22 TRACE nova     return
_volume_get_query(context).filter_by(host=host).all()
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1947, in
all
2012-09-03 12:26:22 TRACE nova     return list(self)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2057, in
__iter__
2012-09-03 12:26:22 TRACE nova     return
self._execute_and_instances(context)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2072, in
_execute_and_instances
2012-09-03 12:26:22 TRACE nova     result =
conn.execute(querycontext.statement, self._params)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in
execute
2012-09-03 12:26:22 TRACE nova     params)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1538, in
_execute_clauseelement
2012-09-03 12:26:22 TRACE nova     compiled_sql, distilled_params
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in
_execute_context
2012-09-03 12:26:22 TRACE nova     context)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in
_execute_context
2012-09-03 12:26:22 TRACE nova     context)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330,
in do_execute
2012-09-03 12:26:22 TRACE nova     cursor.execute(statement, parameters)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2012-09-03 12:26:22 TRACE nova     self.errorhandler(self, exc, value)
2012-09-03 12:26:22 TRACE nova   File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2012-09-03 12:26:22 TRACE nova     raise errorclass, errorvalue
2012-09-03 12:26:22 TRACE nova OperationalError: (OperationalError) (1054,
"Unknown column 'volumes.instance_id' 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.deleted AS volumes_deleted, volumes.id AS volumes_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_id
AS volumes_instance_id, 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.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.volume_type_id AS volumes_volume_type_id, instances_1.created_at AS
instances_1_created_at, instances_1.updated_at AS instances_1_updated_at,
instances_1.deleted_at AS instances_1_deleted_at, instances_1.deleted AS
instances_1_deleted, instances_1.id AS instances_1_id, instances_1.user_id
AS instances_1_user_id, instances_1.project_id AS instances_1_project_id,
instances_1.image_ref AS instances_1_image_ref, instances_1.kernel_id AS
instances_1_kernel_id, instances_1.ramdisk_id AS instances_1_ramdisk_id,
instances_1.server_name AS instances_1_server_name,
instances_1.launch_index AS instances_1_launch_index, instances_1.key_name
AS instances_1_key_name, instances_1.key_data AS instances_1_key_data,
instances_1.power_state AS instances_1_power_state, instances_1.vm_state AS
instances_1_vm_state, instances_1.task_state AS instances_1_task_state,
instances_1.memory_mb AS instances_1_memory_mb, instances_1.vcpus AS
instances_1_vcpus, instances_1.root_gb AS instances_1_root_gb,
instances_1.ephemeral_gb AS instances_1_ephemeral_gb, instances_1.hostname
AS instances_1_hostname, instances_1.host AS instances_1_host,
instances_1.instance_type_id AS instances_1_instance_type_id,
instances_1.user_data AS instances_1_user_data, instances_1.reservation_id
AS instances_1_reservation_id, instances_1.scheduled_at AS
instances_1_scheduled_at, instances_1.launched_at AS
instances_1_launched_at, instances_1.terminated_at AS
instances_1_terminated_at, instances_1.availability_zone AS
instances_1_availability_zone, instances_1.display_name AS
instances_1_display_name, instances_1.display_description AS
instances_1_display_description, instances_1.launched_on AS
instances_1_launched_on, instances_1.locked AS instances_1_locked,
instances_1.os_type AS instances_1_os_type, instances_1.architecture AS
instances_1_architecture, instances_1.vm_mode AS instances_1_vm_mode,
instances_1.uuid AS instances_1_uuid, instances_1.root_device_name AS
instances_1_root_device_name, instances_1.default_ephemeral_device AS
instances_1_default_ephemeral_device, instances_1.default_swap_device AS
instances_1_default_swap_device, instances_1.config_drive AS
instances_1_config_drive, instances_1.access_ip_v4 AS
instances_1_access_ip_v4, instances_1.access_ip_v6 AS
instances_1_access_ip_v6, instances_1.auto_disk_config AS
instances_1_auto_disk_config, instances_1.progress AS instances_1_progress,
instances_1.shutdown_terminate AS instances_1_shutdown_terminate,
instances_1.disable_terminate AS instances_1_disable_terminate,
instances_1.cell_name AS instances_1_cell_name,
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.idAS 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 \nFROM
volumes LEFT OUTER JOIN instances AS instances_1 ON volumes.instance_id =
instances_1.id AND volumes.deleted = %s LEFT OUTER JOIN volume_metadata AS
volume_metadata_1 ON volume_metadata_1.volume_id = volumes.id AND
volume_metadata_1.deleted = %s LEFT OUTER JOIN volume_types AS
volume_types_1 ON volumes.volume_type_id = volume_types_1.id AND
volume_types_1.deleted = %s \nWHERE volumes.deleted = %s AND volumes.host =
%s' (0, 0, 0, 0, 'OpenstackController')
2012-09-03 12:26:22 TRACE nova

Can any one kindly please guide me on troubleshooting the issue.

Thanking you all..

-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20120903/a7f6a212/attachment.html>


More information about the Openstack mailing list