** Changed in: nova Status: Fix Committed => Fix Released ** Changed in: nova Milestone: None => liberty-rc1
-- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1226049 Title: instance_system_metadata rows not being deleted Status in OpenStack Compute (nova): Fix Released Bug description: Deleting an instance no longer seems to delete the associated instance_system_metadata rows in the DB. To reproduce in Devstack: - Create an instance - Delete it - Look at the associated DB rows: mysql> select * from instances where uuid="9ad5d7c7-306f-44ff-84a2-06b9af7d5d36" \G ; *************************** 1. row *************************** created_at: 2013-09-16 10:18:05 updated_at: 2013-09-16 10:21:44 deleted_at: 2013-09-16 10:21:44 id: 7 internal_id: NULL user_id: eb50e969766f4cfcb392d307d1178a9e project_id: 852d7be63c7c4540856b38be6226ff49 image_ref: 28b52a16-4a62-497c-8c83-837cdcf6bf66 kernel_id: 86f818dc-d836-4b1f-aae5-386bc594a746 ramdisk_id: 41e93f5e-06c5-49eb-9ed4-3b5e10f56d0a launch_index: 0 key_name: NULL key_data: NULL power_state: 1 vm_state: deleted memory_mb: 512 vcpus: 1 hostname: phil host: vm-reap user_data: NULL reservation_id: r-8arbuy8m scheduled_at: 2013-09-16 10:18:06 launched_at: 2013-09-16 10:18:10 terminated_at: 2013-09-16 10:21:44 display_name: phil display_description: phil availability_zone: NULL locked: 0 os_type: NULL launched_on: vm-reap instance_type_id: 2 vm_mode: NULL uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 architecture: NULL root_device_name: /dev/vda access_ip_v4: NULL access_ip_v6: NULL config_drive: task_state: NULL default_ephemeral_device: NULL default_swap_device: NULL progress: 0 auto_disk_config: 0 shutdown_terminate: 0 disable_terminate: 0 root_gb: 1 ephemeral_gb: 0 cell_name: NULL node: vm-reap.novalocal deleted: 7 locked_by: NULL cleaned: 0 1 row in set (0.00 sec) ERROR: No query specified mysql> select * from instance_metadata where instance_uuid="9ad5d7c7-306f-44ff-84a2-06b9af7d5d36" \G ; Empty set (0.00 sec) ERROR: No query specified mysql> select * from instance_system_metadata where instance_uuid="9ad5d7c7-306f-44ff-84a2-06b9af7d5d36" \G ; *************************** 1. row *************************** created_at: 2013-09-16 10:18:05 updated_at: NULL deleted_at: NULL id: 83 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: image_kernel_id value: 86f818dc-d836-4b1f-aae5-386bc594a746 deleted: 0 *************************** 2. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 84 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_memory_mb value: 512 deleted: 0 *************************** 3. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 85 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_swap value: 0 deleted: 0 *************************** 4. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 86 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_vcpu_weight value: NULL deleted: 0 *************************** 5. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 87 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_root_gb value: 1 deleted: 0 *************************** 6. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 88 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_name value: m1.tiny deleted: 0 *************************** 7. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 89 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: image_ramdisk_id value: 41e93f5e-06c5-49eb-9ed4-3b5e10f56d0a deleted: 0 *************************** 8. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 90 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_id value: 2 deleted: 0 *************************** 9. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 91 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_ephemeral_gb value: 0 deleted: 0 *************************** 10. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 92 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_rxtx_factor value: 1 deleted: 0 *************************** 11. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 93 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_flavorid value: 1 deleted: 0 *************************** 12. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 94 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: instance_type_vcpus value: 1 deleted: 0 *************************** 13. row *************************** created_at: 2013-09-16 10:18:06 updated_at: NULL deleted_at: NULL id: 95 instance_uuid: 9ad5d7c7-306f-44ff-84a2-06b9af7d5d36 key: image_base_image_ref value: 28b52a16-4a62-497c-8c83-837cdcf6bf66 deleted: 0 13 rows in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1226049/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp