openstack team mailing list archive

[Afef MDHAFFAR <afef.mdhaffar@xxxxxxxxx>]

Hi all

I installed openstack with ubuntu 12.04 + xcp.
nova-compute does not want to start and shows this error message:
2012-12-07 13:00:55 DEBUG nova.compute.resource_tracker [-] Hypervisor:
VCPU information unavailable from (pid=27696)
_report_hypervisor_resource_view
/opt/stack/nova/nova/compute/resource_tracker.py:330
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line
336, in fire_timers
    timer()
  File "/usr/local/lib/python2.7/dist-packages/eventlet/hubs/timer.py",
line 56, in __call__
    cb(*args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/eventlet/greenthread.py",
line 192, in main
    result = function(*args, **kwargs)
  File "/opt/stack/nova/nova/service.py", line 124, in run_server
    server.start()
  File "/opt/stack/nova/nova/service.py", line 412, in start
    self.manager.pre_start_hook(rpc_connection=self.conn)
  File "/opt/stack/nova/nova/compute/manager.py", line 437, in
pre_start_hook
    self.update_available_resource(nova.context.get_admin_context())
  File "/opt/stack/nova/nova/compute/manager.py", line 3241, in
update_available_resource
    rt.update_available_resource(context)
  File "/opt/stack/nova/nova/openstack/common/lockutils.py", line 228, in
inner
    retval = f(*args, **kwargs)
  File "/opt/stack/nova/nova/compute/resource_tracker.py", line 266, in
update_available_resource
    self.host, self.nodename)
  File "/opt/stack/nova/nova/db/api.py", line 411, in
migration_get_in_progress_by_host_and_node
    return IMPL.migration_get_in_progress_by_host_and_node(context, host,
node)
  File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 108, in wrapper
    return f(*args, **kwargs)
  File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 3415, in
migration_get_in_progress_by_host_and_node
    options(joinedload('instance')).\
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2115, in all
    return list(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py",
line 2242, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1449, in execute
    params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1850, in _handle_dbapi_exception
    None, sys.exc_info()[2]
OperationalError: (OperationalError) (1054, "Unknown column
'migrations.source_node' in 'field list'") 'SELECT migrations.created_at AS
migrations_created_at, migrations.updated_at AS migrations_updated_at,
migrations.deleted_at AS migrations_deleted_at, migrations.deleted AS
migrations_deleted, migrations.id AS migrations_id,
migrations.source_compute AS migrations_source_compute,
migrations.dest_compute AS migrations_dest_compute, migrations.source_node
AS migrations_source_node, migrations.dest_node AS migrations_dest_node,
migrations.dest_host AS migrations_dest_host,
migrations.old_instance_type_id AS migrations_old_instance_type_id,
migrations.new_instance_type_id AS migrations_new_instance_type_id,
migrations.instance_uuid AS migrations_instance_uuid, migrations.status AS
migrations_status, 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.hostname AS instances_1_hostname, 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.host AS instances_1_host,
instances_1.node AS instances_1_node, 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 \nFROM migrations LEFT OUTER
JOIN instances AS instances_1 ON migrations.instance_uuid =
instances_1.uuid AND instances_1.deleted = %s \nWHERE migrations.deleted =
%s AND (migrations.source_compute = %s AND migrations.source_node = %s OR
migrations.dest_compute = %s AND migrations.dest_node = %s) AND
migrations.status NOT IN (%s, %s)' (0, 0, 'computeDomU03', 'compute09',
'computeDomU03', 'compute09', 'confirmed', 'reverted')
2012-12-07 13:00:55 CRITICAL nova [-] (OperationalError) (1054, "Unknown
column 'migrations.source_node' in 'field list'") 'SELECT
migrations.created_at AS migrations_created_at, migrations.updated_at AS
migrations_updated_at, migrations.deleted_at AS migrations_deleted_at,
migrations.deleted AS migrations_deleted, migrations.id AS migrations_id,
migrations.source_compute AS migrations_source_compute,
migrations.dest_compute AS migrations_dest_compute, migrations.source_node
AS migrations_source_node, migrations.dest_node AS migrations_dest_node,
migrations.dest_host AS migrations_dest_host,
migrations.old_instance_type_id AS migrations_old_instance_type_id,
migrations.new_instance_type_id AS migrations_new_instance_type_id,
migrations.instance_uuid AS migrations_instance_uuid, migrations.status AS
migrations_status, 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.hostname AS instances_1_hostname, 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.host AS instances_1_host,
instances_1.node AS instances_1_node, 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 \nFROM migrations LEFT OUTER
JOIN instances AS instances_1 ON migrations.instance_uuid =
instances_1.uuid AND instances_1.deleted = %s \nWHERE migrations.deleted =
%s AND (migrations.source_compute = %s AND migrations.source_node = %s OR
migrations.dest_compute = %s AND migrations.dest_node = %s) AND
migrations.status NOT IN (%s, %s)' (0, 0, 'computeDomU03', 'compute09',
'computeDomU03', 'compute09', 'confirmed', 'reverted')
2012-12-07 13:00:55 TRACE nova Traceback (most recent call last):
2012-12-07 13:00:55 TRACE nova   File "/usr/local/bin/nova-compute", line
7, in <module>
2012-12-07 13:00:55 TRACE nova     execfile(__file__)
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/bin/nova-compute",
line 60, in <module>
2012-12-07 13:00:55 TRACE nova     service.wait()
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/service.py",
line 637, in wait
2012-12-07 13:00:55 TRACE nova     _launcher.wait()
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/service.py",
line 186, in wait
2012-12-07 13:00:55 TRACE nova     super(ServiceLauncher, self).wait()
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/service.py",
line 156, in wait
2012-12-07 13:00:55 TRACE nova     service.wait()
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/eventlet/greenthread.py", line 166,
in wait
2012-12-07 13:00:55 TRACE nova     return self._exit_event.wait()
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/eventlet/event.py", line 116, in
wait
2012-12-07 13:00:55 TRACE nova     return hubs.get_hub().switch()
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 177, in
switch
2012-12-07 13:00:55 TRACE nova     return self.greenlet.switch()
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/eventlet/greenthread.py", line 192,
in main
2012-12-07 13:00:55 TRACE nova     result = function(*args, **kwargs)
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/service.py",
line 124, in run_server
2012-12-07 13:00:55 TRACE nova     server.start()
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/service.py",
line 412, in start
2012-12-07 13:00:55 TRACE nova
self.manager.pre_start_hook(rpc_connection=self.conn)
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/compute/manager.py", line 437, in pre_start_hook
2012-12-07 13:00:55 TRACE nova
self.update_available_resource(nova.context.get_admin_context())
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/compute/manager.py", line 3241, in
update_available_resource
2012-12-07 13:00:55 TRACE nova     rt.update_available_resource(context)
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/openstack/common/lockutils.py", line 228, in inner
2012-12-07 13:00:55 TRACE nova     retval = f(*args, **kwargs)
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/compute/resource_tracker.py", line 266, in
update_available_resource
2012-12-07 13:00:55 TRACE nova     self.host, self.nodename)
2012-12-07 13:00:55 TRACE nova   File "/opt/stack/nova/nova/db/api.py",
line 411, in migration_get_in_progress_by_host_and_node
2012-12-07 13:00:55 TRACE nova     return
IMPL.migration_get_in_progress_by_host_and_node(context, host, node)
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 108, in wrapper
2012-12-07 13:00:55 TRACE nova     return f(*args, **kwargs)
2012-12-07 13:00:55 TRACE nova   File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 3415, in
migration_get_in_progress_by_host_and_node
2012-12-07 13:00:55 TRACE nova     options(joinedload('instance')).\
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2115, in all
2012-12-07 13:00:55 TRACE nova     return list(self)
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2227, in __iter__
2012-12-07 13:00:55 TRACE nova     return
self._execute_and_instances(context)
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2242, in _execute_and_instances
2012-12-07 13:00:55 TRACE nova     result =
conn.execute(querycontext.statement, self._params)
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1449, in execute
2012-12-07 13:00:55 TRACE nova     params)
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1584, in _execute_clauseelement
2012-12-07 13:00:55 TRACE nova     compiled_sql, distilled_params
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1698, in _execute_context
2012-12-07 13:00:55 TRACE nova     context)
2012-12-07 13:00:55 TRACE nova   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1850, in _handle_dbapi_exception
2012-12-07 13:00:55 TRACE nova     None, sys.exc_info()[2]
2012-12-07 13:00:55 TRACE nova OperationalError: (OperationalError) (1054,
"Unknown column 'migrations.source_node' in 'field list'") 'SELECT
migrations.created_at AS migrations_created_at, migrations.updated_at AS
migrations_updated_at, migrations.deleted_at AS migrations_deleted_at,
migrations.deleted AS migrations_deleted, migrations.id AS migrations_id,
migrations.source_compute AS migrations_source_compute,
migrations.dest_compute AS migrations_dest_compute, migrations.source_node
AS migrations_source_node, migrations.dest_node AS migrations_dest_node,
migrations.dest_host AS migrations_dest_host,
migrations.old_instance_type_id AS migrations_old_instance_type_id,
migrations.new_instance_type_id AS migrations_new_instance_type_id,
migrations.instance_uuid AS migrations_instance_uuid, migrations.status AS
migrations_status, 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.hostname AS instances_1_hostname, 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.host AS instances_1_host,
instances_1.node AS instances_1_node, 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 \nFROM migrations LEFT OUTER
JOIN instances AS instances_1 ON migrations.instance_uuid =
instances_1.uuid AND instances_1.deleted = %s \nWHERE migrations.deleted =
%s AND (migrations.source_compute = %s AND migrations.source_node = %s OR
migrations.dest_compute = %s AND migrations.dest_node = %s) AND
migrations.status NOT IN (%s, %s)' (0, 0, 'computeDomU03', 'compute09',
'computeDomU03', 'compute09', 'confirmed', 'reverted')
2012-12-07 13:00:55 TRACE nova

Any ideas how to solve it?

Thank you,
Afef