yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #60304
[Bug 1654736] [NEW] VM number summarize not match.
Public bug reported:
[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
** Affects: nova
Importance: Undecided
Status: New
--
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):
New
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
Follow ups
