Public bug reported: Description =========== instance_group_members record also exist in database after delete vm
Steps to reproduce ================== 1:create affinity instance_group 2:create vm 3:delete vm Actual result ============= Database changed MariaDB [nova_api]> select * from instance_group_member where group_id='3'; +---------------------+------------+-----+--------------------------------------+----------+ | created_at | updated_at | id | instance_uuid | group_id | +---------------------+------------+-----+--------------------------------------+----------+ | 2018-02-12 09:14:42 | NULL | 106 | 3b9aa471-612f-4967-a405-574241e84aa0 | 3 | | 2018-02-12 09:15:14 | NULL | 107 | e04244d9-2832-482a-9793-b5cc5b018de2 | 3 | | 2018-02-22 03:05:40 | NULL | 108 | ff7a2194-9f38-4a7e-a67f-f0c53e409e9b | 3 | | 2018-02-22 04:07:43 | NULL | 109 | 50000a55-8d0f-4592-ae0f-e9223c3f6a32 | 3 | | 2018-02-22 08:36:44 | NULL | 110 | 4ef31c5c-d96f-4e24-ba86-75c5576ae4ed | 3 | | 2018-02-22 09:36:39 | NULL | 111 | 0378c1bb-2d79-4b33-8115-77a75996af38 | 3 | | 2018-02-23 00:40:05 | NULL | 112 | 08dac72d-8f04-4f7d-8b9a-60b0cf000951 | 3 | +---------------------+------------+-----+--------------------------------------+----------+ 7 rows in set (0.00 sec) MariaDB [nova_api]> use nova; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [nova]> select * from instances where uuid='3b9aa471-612f-4967-a405-574241e84aa0'; +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ | created_at | updated_at | deleted_at | id | internal_id | user_id | project_id | image_ref | kernel_id | ramdisk_id | launch_index | key_name | key_data | power_state | vm_state | memory_mb | vcpus | hostname | host | user_data | reservation_id | launched_at | terminated_at | display_name | display_description | availability_zone | locked | os_type | launched_on | instance_type_id | vm_mode | uuid | architecture | root_device_name | access_ip_v4 | access_ip_v6 | config_drive | task_state | default_ephemeral_device | default_swap_device | progress | auto_disk_config | shutdown_terminate | disable_terminate | root_gb | ephemeral_gb | cell_name | node | deleted | locked_by | cleaned | ephemeral_key_uuid | +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ | 2018-02-12 09:14:42 | 2018-02-13 00:58:48 | 2018-02-13 00:58:48 | 255 | NULL | 86019a90ad0b44609cca8b0eb9eee79b | 01f2572fd19743558be05561e09c3850 | 22164f51-c353-4f8a-a073-cbb2930bf25f | | | 0 | NULL | NULL | 0 | deleted | 2048 | 1 | test-tx001 | nail-5300-2 | NULL | r-j42bg7io | 2018-02-12 09:14:56 | 2018-02-13 00:58:48 | test_tx001 | NULL | test1 | 0 | NULL | nail-5300-2 | 14 | NULL | 3b9aa471-612f-4967-a405-574241e84aa0 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | nail-5300-2 | 255 | NULL | 1 | NULL | +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ 1 row in set (0.00 sec) ** Affects: nova Importance: Undecided Status: New -- 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/1751186 Title: instance_group_members also exist after delete vm Status in OpenStack Compute (nova): New Bug description: Description =========== instance_group_members record also exist in database after delete vm Steps to reproduce ================== 1:create affinity instance_group 2:create vm 3:delete vm Actual result ============= Database changed MariaDB [nova_api]> select * from instance_group_member where group_id='3'; +---------------------+------------+-----+--------------------------------------+----------+ | created_at | updated_at | id | instance_uuid | group_id | +---------------------+------------+-----+--------------------------------------+----------+ | 2018-02-12 09:14:42 | NULL | 106 | 3b9aa471-612f-4967-a405-574241e84aa0 | 3 | | 2018-02-12 09:15:14 | NULL | 107 | e04244d9-2832-482a-9793-b5cc5b018de2 | 3 | | 2018-02-22 03:05:40 | NULL | 108 | ff7a2194-9f38-4a7e-a67f-f0c53e409e9b | 3 | | 2018-02-22 04:07:43 | NULL | 109 | 50000a55-8d0f-4592-ae0f-e9223c3f6a32 | 3 | | 2018-02-22 08:36:44 | NULL | 110 | 4ef31c5c-d96f-4e24-ba86-75c5576ae4ed | 3 | | 2018-02-22 09:36:39 | NULL | 111 | 0378c1bb-2d79-4b33-8115-77a75996af38 | 3 | | 2018-02-23 00:40:05 | NULL | 112 | 08dac72d-8f04-4f7d-8b9a-60b0cf000951 | 3 | +---------------------+------------+-----+--------------------------------------+----------+ 7 rows in set (0.00 sec) MariaDB [nova_api]> use nova; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [nova]> select * from instances where uuid='3b9aa471-612f-4967-a405-574241e84aa0'; +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ | created_at | updated_at | deleted_at | id | internal_id | user_id | project_id | image_ref | kernel_id | ramdisk_id | launch_index | key_name | key_data | power_state | vm_state | memory_mb | vcpus | hostname | host | user_data | reservation_id | launched_at | terminated_at | display_name | display_description | availability_zone | locked | os_type | launched_on | instance_type_id | vm_mode | uuid | architecture | root_device_name | access_ip_v4 | access_ip_v6 | config_drive | task_state | default_ephemeral_device | default_swap_device | progress | auto_disk_config | shutdown_terminate | disable_terminate | root_gb | ephemeral_gb | cell_name | node | deleted | locked_by | cleaned | ephemeral_key_uuid | +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ | 2018-02-12 09:14:42 | 2018-02-13 00:58:48 | 2018-02-13 00:58:48 | 255 | NULL | 86019a90ad0b44609cca8b0eb9eee79b | 01f2572fd19743558be05561e09c3850 | 22164f51-c353-4f8a-a073-cbb2930bf25f | | | 0 | NULL | NULL | 0 | deleted | 2048 | 1 | test-tx001 | nail-5300-2 | NULL | r-j42bg7io | 2018-02-12 09:14:56 | 2018-02-13 00:58:48 | test_tx001 | NULL | test1 | 0 | NULL | nail-5300-2 | 14 | NULL | 3b9aa471-612f-4967-a405-574241e84aa0 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 10 | 0 | NULL | nail-5300-2 | 255 | NULL | 1 | NULL | +---------------------+---------------------+---------------------+-----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+------------+-------------+-----------+----------------+---------------------+---------------------+--------------+---------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+-------------+---------+-----------+---------+--------------------+ 1 row in set (0.00 sec) To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1751186/+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