<div dir="ltr">Hi,<div>I'm testing the nova DB sync (Havana -> Icehouse) in a copy of my production databases</div><div>and I'm getting the following "CRITICAL" in nova-manage log for the 230-> 231 migration.<br></div><div>Looking at this particular migration it creates a new column "<span style="font-family:Menlo;font-size:13px">instances.ephemeral_key_uuid</span>" </div><div>however it's complaining that the column doesn't exist!</div><div>Anyway, this doesn't block the DB sync and at the end this column is added to the DB.</div><div><br></div><div>Anyone already in Icehouse also experienced this problem?</div><div>Is this harmful?</div><div><br></div><div>thanks,</div><div>Belmiro</div><div><br></div><div><br></div><div><br></div><div><p style="margin:0px;font-size:13px;font-family:Menlo">2014-09-30 14:44:08.973 32035 INFO migrate.versioning.api [-] 230 -> 231... </p>
<p style="margin:0px;font-size:13px;font-family:Menlo">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, <a href="http://instances.id">instances.id</a> 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, <a href="http://instance_info_caches_1.id">instance_info_caches_1.id</a> 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, <a href="http://security_groups_1.id">security_groups_1.id</a> AS security_groups_1_id, <a href="http://security_groups_1.name">security_groups_1.name</a> 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 <a href="http://security_groups_1.id">security_groups_1.id</a> = 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)</p></div><div><p style="margin:0px;font-size:13px;font-family:Menlo">2014-09-30 14:58:56.928 32035 INFO migrate.versioning.api [-] done</p>
<p style="margin:0px;font-size:13px;font-family:Menlo">2014-09-30 14:58:56.930 32035 INFO migrate.versioning.api [-] 231 -> 232... </p></div><div><br></div><div><br></div><div><br></div></div>