In Project Overview the Limit Summary for floating ips shows ips even if the mysqldb has no active floating ips

[Vivian Ruschak]

After deleting all instances and removing the floating ip bulk Horizon still shows x out of y ( in my case 10/30) used floating ips.

####### Terminal #######

root@sim-master : nova floating-ip-list

root@sim-master : nova floating-ip-pool-list

root@sim-master : nova floating-ip-bulk-list

root@sim-master : nova list

root@sim-master :

###### Dashboard ######
see attached file

when i setup a new pool and add a bulk of ip addresses it adds new associated ips to the "existing" pool when i start an instance

the mysql table shows all ips i deleted - until now - as deleted. Some are still connected to a project id. Looks like these are the 10 "used" ips.

floating ip mysql table:

+---------------------+---------------------+---------------------+----+---------------+-------------+----------------------------------+------+---------------+------+-----------+---------+
| created_at | updated_at | deleted_at | id | address | fixed_ip_id | project_id | host | auto_assigned | pool | interface | deleted |
+---------------------+---------------------+---------------------+----+---------------+-------------+----------------------------------+------+---------------+------+-----------+---------+
2013-11-06 14:47:48 | 2013-11-19 10:02:15 | 2013-11-19 15:31:04 | 5 | 192.168.0.229 | NULL | b58c09083b17453594ad99d62a567d50 | NULL | 0 | nova | eth0 | 1 |
| 2013-11-06 14:47:48 | 2013-11-19 11:23:22 | 2013-11-19 15:31:04 | 6 | 192.168.0.230 | NULL | b58c09083b17453594ad99d62a567d50 | NULL | 0 | nova | eth0 | 2 |
| 2013-11-06 14:47:48 | 2013-11-19 11:23:27 | 2013-11-19 15:31:04 | 7 | 192.168.0.231 | NULL | b58c09083b17453594ad99d62a567d50 | NULL | 0 | nova | eth0 | 3 |

when i curl the given url from the debug log file i get:

root@sim-master : curl -i http://149.148.62.116:8774/v2/b58c09083b17453594ad99d62a567d50/os-floating-ips -X GET -H "X-Auth-Project-Id: b58c09083b17453594ad99d62a567d50" -H "User-Agent: python-novaclient" -H "Accept: application/json" -H "X-Auth-Token: 13ce6cd95838e93f8ef3298d525e7bc6"
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: 20
X-Compute-Request-Id: req-9399d298-8e2c-4b79-9ffe-9ea709fe1174
Date: Thu, 28 Nov 2013 14:48:04 GMT

{"floating_ips": []}
root@sim-master :

it's still the same as shown in the debug log.

[Kieran Spear (kspear)]

Hi, can you include the output of:

$ nova absolute-limits

That's the same API call that Horizon uses to get the value it displays in the dashboard. It's likely that the number Nova is reporting is wrong.

The Nova `quota_usages` and `reservations` tables might give you more insight into the problem.

[Vivian Ruschak (vivian-ruschak)]

Hi,

seems like nova didn't reset the used limit in the quota_usages table. It looks like this is the result of the troubles i had of installing nova-network.

$ nova absolute-limits
+-------------------------+-------+
| Name | Value |
+-------------------------+-------+
...
| totalFloatingIpsUsed | 10 |
...
+-------------------------+-------+

mysql:

mysql> select * from quota_usages where in_use!=0;
+---------------------+---------------------+------------+----+----------------------------------+--------------+--------+----------+---------------+---------+---------+
| created_at | updated_at | deleted_at | id | project_id | resource | in_use | reserved | until_refresh | deleted | user_id |
+---------------------+---------------------+------------+----+----------------------------------+--------------+--------+----------+---------------+---------+---------+
| 2013-11-06 08:36:56 | 2013-11-28 12:48:56 | NULL | 4 | b58c09083b17453594ad99d62a567d50 | floating_ips | 10 | 0 | NULL | 0 | NULL |
+---------------------+---------------------+------------+----+----------------------------------+--------------+--------+----------+---------------+---------+---------+

In the reservations table all entries are marked as deleted.

When i update the quota_usages table and set in_use to 0 Horizon shows 0 out of x

So, Horizon is working correctly.

thank you for the hint.