[Openstack-operators] DB sync (Havana -> Icehouse). Unknown column 'instances.ephemeral_key_uuid'

Belmiro Moreira moreira.belmiro.email.lists at gmail.com
Tue Sep 30 13:07:10 UTC 2014


Hi,
I'm testing the nova DB sync (Havana -> Icehouse) in a copy of my
production databases
and I'm getting the following "CRITICAL" in nova-manage log for the 230->
231 migration.
Looking at this particular migration it creates a new column "
instances.ephemeral_key_uuid"
however it's complaining that the column doesn't exist!
Anyway, this doesn't block the DB sync and at the end this column is added
to the DB.

Anyone already in Icehouse also experienced this problem?
Is this harmful?

thanks,
Belmiro



2014-09-30 14:44:08.973 32035 INFO migrate.versioning.api [-] 230 -> 231...

2014-09-30 14:45:05.248 32152 CRITICAL nova
[req-0f394ba5-32ff-4f15-afea-92bc5cc06dcf None None] OperationalError:
(OperationalError) (1054, "Unknown column 'instances.ephemeral_key_uuid' in
'field list'") 'SELECT instances.created_at AS instances_created_at,
instances.updated_at AS instances_updated_at, instances.deleted_at AS
instances_deleted_at, instances.deleted AS instances_deleted, instances.id
AS instances_id, instances.user_id AS instances_user_id,
instances.project_id AS instances_project_id, instances.image_ref AS
instances_image_ref, instances.kernel_id AS instances_kernel_id,
instances.ramdisk_id AS instances_ramdisk_id, instances.hostname AS
instances_hostname, instances.launch_index AS instances_launch_index,
instances.key_name AS instances_key_name, instances.key_data AS
instances_key_data, instances.power_state AS instances_power_state,
instances.vm_state AS instances_vm_state, instances.task_state AS
instances_task_state, instances.memory_mb AS instances_memory_mb,
instances.vcpus AS instances_vcpus, instances.root_gb AS instances_root_gb,
instances.ephemeral_gb AS instances_ephemeral_gb,
instances.ephemeral_key_uuid AS instances_ephemeral_key_uuid,
instances.host AS instances_host, instances.node AS instances_node,
instances.instance_type_id AS instances_instance_type_id,
instances.user_data AS instances_user_data, instances.reservation_id AS
instances_reservation_id, instances.scheduled_at AS instances_scheduled_at,
instances.launched_at AS instances_launched_at, instances.terminated_at AS
instances_terminated_at, instances.availability_zone AS
instances_availability_zone, instances.display_name AS
instances_display_name, instances.display_description AS
instances_display_description, instances.launched_on AS
instances_launched_on, instances.locked AS instances_locked,
instances.locked_by AS instances_locked_by, instances.os_type AS
instances_os_type, instances.architecture AS instances_architecture,
instances.vm_mode AS instances_vm_mode, instances.uuid AS instances_uuid,
instances.root_device_name AS instances_root_device_name,
instances.default_ephemeral_device AS instances_default_ephemeral_device,
instances.default_swap_device AS instances_default_swap_device,
instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS
instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6,
instances.auto_disk_config AS instances_auto_disk_config,
instances.progress AS instances_progress, instances.shutdown_terminate AS
instances_shutdown_terminate, instances.disable_terminate AS
instances_disable_terminate, instances.cell_name AS instances_cell_name,
instances.internal_id AS instances_internal_id, instances.cleaned AS
instances_cleaned, instance_info_caches_1.created_at AS
instance_info_caches_1_created_at, instance_info_caches_1.updated_at AS
instance_info_caches_1_updated_at, instance_info_caches_1.deleted_at AS
instance_info_caches_1_deleted_at, instance_info_caches_1.deleted AS
instance_info_caches_1_deleted, instance_info_caches_1.id AS
instance_info_caches_1_id, instance_info_caches_1.network_info AS
instance_info_caches_1_network_info, instance_info_caches_1.instance_uuid
AS instance_info_caches_1_instance_uuid, security_groups_1.created_at AS
security_groups_1_created_at, security_groups_1.updated_at AS
security_groups_1_updated_at, security_groups_1.deleted_at AS
security_groups_1_deleted_at, security_groups_1.deleted AS
security_groups_1_deleted, security_groups_1.id AS security_groups_1_id,
security_groups_1.name AS security_groups_1_name,
security_groups_1.description AS security_groups_1_description,
security_groups_1.user_id AS security_groups_1_user_id,
security_groups_1.project_id AS security_groups_1_project_id \nFROM
instances LEFT OUTER JOIN instance_info_caches AS instance_info_caches_1 ON
instance_info_caches_1.instance_uuid = instances.uuid LEFT OUTER JOIN
security_group_instance_association AS
security_group_instance_association_1 ON
security_group_instance_association_1.instance_uuid = instances.uuid AND
instances.deleted = %s LEFT OUTER JOIN security_groups AS security_groups_1
ON security_groups_1.id =
security_group_instance_association_1.security_group_id AND
security_group_instance_association_1.deleted = %s AND
security_groups_1.deleted = %s \nWHERE instances.deleted = %s' (0, 0, 0, 0)

2014-09-30 14:58:56.928 32035 INFO migrate.versioning.api [-] done

2014-09-30 14:58:56.930 32035 INFO migrate.versioning.api [-] 231 -> 232...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20140930/72571061/attachment.html>


More information about the OpenStack-operators mailing list