yahoo-eng-team team mailing list archive

[Sujitha <sujitha.neti@xxxxxxxxx>]

@pratik-bandarkar,

I agree with you. Also openstack usage list shows resource usage per
project based on start and end date range. Both the commands have
different usages. The behavior observed is expected. Marking this as
invalid.

** Changed in: nova
       Status: New => Invalid

-- 
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/1654736

Title:
  VM number summarize not match.

Status in OpenStack Compute (nova):
  Invalid

Bug description:
  [root@controller1 nova]# openstack usage list
  Usage from 2016-12-10 to 2017-01-08: 
  +----------------------------------+---------+--------------+-----------+---------------+
  | Project                          | Servers | RAM MB-Hours | CPU Hours | Disk GB-Hours |
  +----------------------------------+---------+--------------+-----------+---------------+
  | e98032abd959422bb6b38029fa1b2b36 |       9 |    223970.37 |    218.72 |       1093.61 |
  +----------------------------------+---------+--------------+-----------+---------------+

  [root@controller1 nova]# nova list
  +--------------------------------------+-----------+---------+------------+-------------+------------------------+
  | ID                                   | Name      | Status  | Task State | Power State | Networks               |
  +--------------------------------------+-----------+---------+------------+-------------+------------------------+
  | 582eda06-d3b6-409d-84fc-5315751ecc9e | VM-User-1 | SHUTOFF | -          | Shutdown    | VM-Net=192.168.201.110 |
  | 9fdb65d4-2eed-4251-9f63-822b19497bf7 | VM-User-2 | SHUTOFF | -          | Shutdown    | VM-Net=192.168.201.103 |
  | d9b0c52b-bbd6-4f63-814f-cd244d090ad4 | test-1    | ACTIVE  | -          | Running     | VM-Net=192.168.201.108 |
  | a2ccbc21-363b-4b8a-93d1-923d58d067ed | test-2    | SHUTOFF | -          | Shutdown    | VM-Net=192.168.201.109 |
  +--------------------------------------+-----------+---------+------------+-------------+------------------------+
  the two command has the different number VM created.

  "openstack usage list" give 9 VM created.
  "nova list" give 4 VM created.

  the "nova list" command show the correct result.
  I suspect the "openstack usage list" dump the database data directly.

  MariaDB [nova]> select id, display_name ,node from instances;
  +----+--------------+--------------------+
  | id | display_name | node               |
  +----+--------------+--------------------+
  |  1 | Linux        | NULL               |
  |  2 | Linux        | NULL               |
  |  3 | linux        | NULL               |
  |  4 | linux        | NULL               |
  |  5 | linux        | NULL               |
  |  6 | Linux1       | NULL               |
  |  7 | linux        | NULL               |
  |  8 | linux        | NULL               |
  |  9 | linux        | NULL               |
  | 10 | 123          | NULL               |
  | 11 | 123          | NULL               |
  | 12 | vm111        | NULL               |
  | 13 | test         | compute1           |
  | 14 | VM-Min1-1    | compute1           |
  | 15 | VM-Min1-2    | compute1           |
  | 16 | Min-1        | compute1           |
  | 17 | Min-2        | compute1           |
  | 18 | VM-User-1    | compute1           |
  | 19 | VM-User-2    | compute1           |
  | 20 | test-1       | Compute2.puppy.com |
  | 21 | test-2       | Compute2.puppy.com |
  +----+--------------+--------------------+
  In the instance table, there are 9 VM.

  I am not sure the issue caused by what.

  Jichen

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