yahoo-eng-team team mailing list archive

[Vivian Ruschak <vivian.ruschak@xxxxxxxxxxxxxxxx>]

** Changed in: horizon
       Status: Incomplete => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Dashboard (Horizon).
https://bugs.launchpad.net/bugs/1256056

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

Status in OpenStack Dashboard (Horizon):
  Invalid

Bug description:
  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/horizon/+bug/1256056/+subscriptions