Description of problem:
- Unable to delete an unused security group.
- irrespective of the Horizon dashboard or the cli unable to use a security group.

Version-Release number of selected component (if applicable):


How reproducible:
Quite 

Steps to Reproduce:
1.
2.
3.

Actual results:
Expect to be able to delete the security group since it is not used

Expected results:


Additional info:

openstack security group list
+--------------------------------------+--------------------------+------------------------+----------------------------------+
| ID                                   | Name                     | Description            | Project                          |
+--------------------------------------+--------------------------+------------------------+----------------------------------+
| 0517d62e-89f2-4c5f-a82a-abb348d32f06 | default                  | Default security group | a5e1b335b86f487e90b2f59163bbef39 |
| d4f610ea-b620-4f67-8ab3-c8506a8fd723 | db_server_security_group |                        | a5e1b335b86f487e90b2f59163bbef39 |
+--------------------------------------+--------------------------+------------------------+----------------------------------+

[stack@undercloud apptemplates]$ openstack security group show d4f610ea-b620-4f67-8ab3-c8506a8fd723
+-----------------+-------------------------------------------------------------------------------------------------------------------------+
| Field           | Value                                                                                                                   |
+-----------------+-------------------------------------------------------------------------------------------------------------------------+
| created_at      | 2016-11-17T17:23:35Z                                                                                                    |
| description     |                                                                                                                         |
| id              | d4f610ea-b620-4f67-8ab3-c8506a8fd723                                                                                    |
| name            | db_server_security_group                                                                                                |
| project_id      | a5e1b335b86f487e90b2f59163bbef39                                                                                        |
| project_id      | a5e1b335b86f487e90b2f59163bbef39                                                                                        |
| revision_number | 2                                                                                                                       |
| rules           | created_at='2016-11-17T17:23:35Z', direction='egress', ethertype='IPv4', id='032f0d52-3a83-4545-b884-7642ec5043cb',     |
|                 | project_id='a5e1b335b86f487e90b2f59163bbef39', revision_number='1', updated_at='2016-11-17T17:23:35Z'                   |
|                 | created_at='2016-11-17T17:23:35Z', direction='ingress', ethertype='IPv4', id='2ef40bbe-61ee-4801-a64e-99272307161e',    |
|                 | port_range_max='3306', port_range_min='3306', project_id='a5e1b335b86f487e90b2f59163bbef39', protocol='tcp',            |
|                 | revision_number='1', updated_at='2016-11-17T17:23:35Z'                                                                  |
|                 | created_at='2016-11-17T17:23:35Z', direction='egress', ethertype='IPv6', id='a4163497-4f0a-4f35-a32e-4a250453a839',     |
|                 | project_id='a5e1b335b86f487e90b2f59163bbef39', revision_number='1', updated_at='2016-11-17T17:23:35Z'                   |
| updated_at      | 2016-11-17T17:23:35Z                                                                                                    |
+-----------------+-------------------------------------------------------------------------------------------------------------------------+


[stack@undercloud apptemplates]$ openstack security group delete d4f610ea-b620-4f67-8ab3-c8506a8fd723
Failed to delete group with name or ID 'd4f610ea-b620-4f67-8ab3-c8506a8fd723': HttpException: Conflict
1 of 1 groups failed to delete.



nova list
+--------------------------------------+------+--------+------------+-------------+-------------------------------------+
| ID                                   | Name | Status | Task State | Power State | Networks                            |
+--------------------------------------+------+--------+------------+-------------+-------------------------------------+
| 4aa6738a-85e4-471d-beb3-8d9d2635d924 | test | ACTIVE | -          | Running     | test=192.168.123.4, 192.168.122.155 |
+--------------------------------------+------+--------+------------+-------------+-------------------------------------+

[stack@undercloud apptemplates]$ nova show test
+--------------------------------------+------------------------------------------------------------+
| Property                             | Value                                                      |
+--------------------------------------+------------------------------------------------------------+
| OS-DCF:diskConfig                    | MANUAL                                                     |
| OS-EXT-AZ:availability_zone          | nova                                                       |
| OS-EXT-SRV-ATTR:host                 | overcloud-compute-0.localdomain                            |
| OS-EXT-SRV-ATTR:hostname             | test                                                       |
| OS-EXT-SRV-ATTR:hypervisor_hostname  | overcloud-compute-0.localdomain                            |
| OS-EXT-SRV-ATTR:instance_name        | instance-00000002                                          |
| OS-EXT-SRV-ATTR:kernel_id            |                                                            |
| OS-EXT-SRV-ATTR:launch_index         | 0                                                          |
| OS-EXT-SRV-ATTR:ramdisk_id           |                                                            |
| OS-EXT-SRV-ATTR:reservation_id       | r-84tlob2s                                                 |
| OS-EXT-SRV-ATTR:root_device_name     | /dev/vda                                                   |
| OS-EXT-SRV-ATTR:user_data            | -                                                          |
| OS-EXT-STS:power_state               | 1                                                          |
| OS-EXT-STS:task_state                | -                                                          |
| OS-EXT-STS:vm_state                  | active                                                     |
| OS-SRV-USG:launched_at               | 2016-11-16T21:23:06.000000                                 |
| OS-SRV-USG:terminated_at             | -                                                          |
| accessIPv4                           |                                                            |
| accessIPv6                           |                                                            |
| config_drive                         |                                                            |
| created                              | 2016-11-16T21:23:00Z                                       |
| description                          | -                                                          |
| flavor                               | m1.tiny (ff005ff9-8d5e-4af2-b3e4-9eda83bbff01)             |
| hostId                               | fe891a21f3687104f1b72c3b0d958b4aca8cb56dc2c23e03ae7ced0e   |
| host_status                          | UP                                                         |
| id                                   | 4aa6738a-85e4-471d-beb3-8d9d2635d924                       |
| image                                | cirros-0.3.4-x86_64 (e1a28b5d-704b-4f24-bb66-ad8400a0e685) |
| key_name                             | stack                                                      |
| locked                               | False                                                      |
| metadata                             | {}                                                         |
| name                                 | test                                                       |
| os-extended-volumes:volumes_attached | []                                                         |
| progress                             | 0                                                          |
| security_groups                      | default                                                    |
| status                               | ACTIVE                                                     |
| tags                                 | []                                                         |
| tenant_id                            | a5e1b335b86f487e90b2f59163bbef39                           |
| test network                         | 192.168.123.4, 192.168.122.155                             |
| updated                              | 2016-11-16T21:23:06Z                                       |
| user_id                              | 556678aab3e340b193e14873201cfc3e                           |
+--------------------------------------+------------------------------------------------------------+

This is not using the securoty group being deleted