← Back to team overview

yahoo-eng-team team mailing list archive

[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