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
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
