yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #38916
[Bug 1226049] Re: instance_system_metadata rows not being deleted
** 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
