Comment 15 for bug 1226049

Yes, makes sense.

Best Regard:)
Bruce Yan

Yan， Fengxi （闫凤喜）
Openstack Platform Team
IBM China Systems & Technology Lab, Beijing
E-Mail: <email address hidden>
Tel: 86-10-82451418 Notes: Feng Xi FX Yan/China/IBM
Address: 3BW239, Ring Building. No.28 Building, ZhongGuanCun Software
Park,No.8
DongBeiWang West Road, ShangDi, Haidian District, Beijing, P.R.China

From: Chen CH Ji/China/IBM@IBMCN
To: Feng Xi BJ Yan/China/IBM@IBMCN
Date: 2015/07/09 14:50
Subject: [Bug 1226049] Re: instance_system_metadata rows not being
            deleted
Sent by: <email address hidden>

Maybe only Kilo
since it's not a critical bug or security bug, thoughts?

--
You received this bug notification because you are subscribed to a
duplicate bug report (1388756).
https://bugs.launchpad.net/bugs/1226049

Title:
  instance_system_metadata rows not being deleted

Status in OpenStack Compute (Nova):
  In Progress

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