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
