Bug 1121705

Description of problem:
Tracks with upstream bug https://bugs.launchpad.net/nova/+bug/1298494

There is no way, outside of directly querying the SQL database, to show relationships netween server groups in IceHouse and deployed servers.


Version-Release number of selected component (if applicable):
]# rpm -qa | grep nova
python-nova-2014.1-7.el7ost.noarch
openstack-nova-conductor-2014.1-7.el7ost.noarch
openstack-nova-scheduler-2014.1-7.el7ost.noarch
openstack-nova-api-2014.1-7.el7ost.noarch
openstack-nova-novncproxy-2014.1-7.el7ost.noarch
python-novaclient-2.17.0-2.el7ost.noarch
openstack-nova-common-2014.1-7.el7ost.noarch
openstack-nova-compute-2014.1-7.el7ost.noarch
openstack-nova-cert-2014.1-7.el7ost.noarch
openstack-nova-console-2014.1-7.el7ost.noarch




How reproducible:
Always


Steps to Reproduce:
1.Create a server group

# nova server-group-list
+--------------------------------------+------+--------------------+---------+----------+
| Id                                   | Name | Policies           | Members | Metadata |
+--------------------------------------+------+--------------------+---------+----------+
| ca989bce-ace5-483a-8844-b8320f55ea44 | anti | [u'anti-affinity'] | []      | {}       |
+--------------------------------------+------+--------------------+---------+----------+

2. Deploy one or more servers into that group:
# nova boot --image cirros --nic net-id=76bb7f2d-d37d-4f73-8cce-22eb9b9d0021 --flavor m1.tiny --hint group=ca989bce-ace5-483a-8844-b8320f55ea44 --num-instances 2 grouptest
...
]# nova list | grep grouptest
| a9d09b10-d63a-467d-82c2-0d444dd926d3 | grouptest-a9d09b10-d63a-467d-82c2-0d444dd926d3 | ACTIVE | -          | Running     | private=192.168.75.13                |
| bba64534-f9b5-491f-b6ac-5edc65b2a022 | grouptest-bba64534-f9b5-491f-b6ac-5edc65b2a022 | ACTIVE | -          | Running     | private=192.168.75.12                |
...



3. Verify that the anti-affinity (in this case) policy was applied:
# nova show a9d09b10-d63a-467d-82c2-0d444dd926d3 |egrep 'grouptest|hypervisor_hostname'
| OS-EXT-SRV-ATTR:hypervisor_hostname  | server162.costakos.com                                   |
| name                                 | grouptest-a9d09b10-d63a-467d-82c2-0d444dd926d3           |
# nova show bba64534-f9b5-491f-b6ac-5edc65b2a022 | egrep 'grouptest|hypervisor_hostname'
| OS-EXT-SRV-ATTR:hypervisor_hostname  | server161.costakos.com                                   |
| name                                 | grouptest-bba64534-f9b5-491f-b6ac-5edc65b2a022           |
# egrep 'a9d09b10-d63a-467d-82c2-0d444dd926d3|bba64534-f9b5-491f-b6ac-5edc65b2a022' /var/log/nova/nova-scheduler.log 
2014-07-21 09:19:20.449 12561 INFO nova.scheduler.filter_scheduler [req-6853f940-eb01-482f-af39-9ea927667d56 8e5ae3daa5a346648b8022e868ff1490 6765d72287984b598d104e5041b33a01] Attempting to build 2 instance(s) uuids: [u'bba64534-f9b5-491f-b6ac-5edc65b2a022', u'a9d09b10-d63a-467d-82c2-0d444dd926d3']
2014-07-21 09:19:20.486 12561 INFO nova.scheduler.filter_scheduler [req-6853f940-eb01-482f-af39-9ea927667d56 8e5ae3daa5a346648b8022e868ff1490 6765d72287984b598d104e5041b33a01] Choosing host WeighedHost [host: server161.costakos.com, weight: 1.0] for instance bba64534-f9b5-491f-b6ac-5edc65b2a022
2014-07-21 09:19:20.550 12561 INFO nova.scheduler.filter_scheduler [req-6853f940-eb01-482f-af39-9ea927667d56 8e5ae3daa5a346648b8022e868ff1490 6765d72287984b598d104e5041b33a01] Choosing host WeighedHost [host: server162.costakos.com, weight: 1.0] for instance a9d09b10-d63a-467d-82c2-0d444dd926d3

4. Now do a nova server-group-list and verify that the group has no members.

# nova server-group-list
+--------------------------------------+------+--------------------+---------+----------+
| Id                                   | Name | Policies           | Members | Metadata |
+--------------------------------------+------+--------------------+---------+----------+
| ca989bce-ace5-483a-8844-b8320f55ea44 | anti | [u'anti-affinity'] | []      | {}       |
+--------------------------------------+------+--------------------+---------+----------+
# nova server-group-get ca989bce-ace5-483a-8844-b8320f55ea44
+--------------------------------------+------+--------------------+---------+----------+
| Id                                   | Name | Policies           | Members | Metadata |
+--------------------------------------+------+--------------------+---------+----------+
| ca989bce-ace5-483a-8844-b8320f55ea44 | anti | [u'anti-affinity'] | []      | {}       |
+--------------------------------------+------+--------------------+---------+----------+

5. Verify via REST Nova calls that the group shows no members as well

...
<info>: nova-server-groups Entering method get_group_info ca989bce-ace5-483a-8844-b8320f55ea44
<info>: nova-server-groups Full Response {
  "server_group": {
    "members": [

    ],
    "metadata": {
    },
    "id": "ca989bce-ace5-483a-8844-b8320f55ea44",
    "policies": [
      "anti-affinity"
    ],
    "name": "anti"
  }
}

6. Verify that 'stuff' is in the nova/instance_group_members database:

MariaDB [nova]> select * from instance_group_member;
+---------------------+------------+------------+---------+----+--------------------------------------+----------+
| created_at          | updated_at | deleted_at | deleted | id | instance_id                          | group_id |
+---------------------+------------+------------+---------+----+--------------------------------------+----------+
| 2014-07-21 03:56:15 | NULL       | NULL       |       0 |  1 | 680f0e2d-71a3-4960-8bb5-78809e1bbaf9 |        1 |
| 2014-07-21 03:56:15 | NULL       | NULL       |       0 |  2 | 62ebb492-f3c5-467f-9030-9fd652f2f9ec |        1 |
| 2014-07-21 04:55:42 | NULL       | NULL       |       0 |  3 | 84c53e73-c047-4231-9700-3add2b4faac8 |        1 |
| 2014-07-21 04:55:42 | NULL       | NULL       |       0 |  4 | 99ea1e55-4380-4725-875e-7b1e0641ec3a |        1 |
| 2014-07-21 16:19:20 | NULL       | NULL       |       0 |  5 | bba64534-f9b5-491f-b6ac-5edc65b2a022 |        1 |
| 2014-07-21 16:19:20 | NULL       | NULL       |       0 |  6 | a9d09b10-d63a-467d-82c2-0d444dd926d3 |        1 |
+---------------------+------------+------------+---------+----+--------------------------------------+----------+



Actual results:

nova client calls to server-group-list/server-group-get show no group members
api calls to os-server-groups REST URLs return no members
database table entry exists in instance_group_member, but nothing is returned

Expected results:

nova returns the members of a particular nova server-group

Additional info:

Makes auditing, evacuation, live migration difficult for operators if they are unable to audit which instances are members of a particular server group with a policy applied.