nova usage-list doesn't show all instance

[Eli Qiao]

nova usage-list (os-simple-tenant-usage) will query a period instance

it will return 2 kinds of instances:

    query = query.filter(or_(models.Instance.terminated_at == null(),
                             models.Instance.terminated_at > begin))

in my devstack environment, query from db I see there are some instance which

mysql> select count(*) from instances where launched_at is NULL;
+----------+
| count(*) |
+----------+
| 3 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from instances ;
+----------+
| count(*) |
+----------+
| 22 |
+----------+

but usage-list doesn't show 22, it doesn't count the instance which launched_at is NULL
(I don't know why they are NULL , maybe live-migration failed)

Usage from 2015-02-26 to 2015-03-27:
+----------------------------------+---------+--------------+-----------+---------------+
| Tenant ID | Servers | RAM MB-Hours | CPU Hours | Disk GB-Hours |
+----------------------------------+---------+--------------+-----------+---------------+
| 0d028ada663f41cd869acc5cdb488ad6 | 19 | 229321.36 | 447.89 | 447.89 |
+----------------------------------+---------+--------------+-----------+---------------+

do we need to count launched_at instances ?

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/168232

[OpenStack Infra (hudson-openstack)]

Change abandoned by Eli Qiao (<email address hidden>) on branch: master
Review: https://review.openstack.org/168232
Reason: I will find a use case , for now, abandon this due to sean's comment

[Markus Zoeller (markus_z) (mzoeller)]

@Abhishek Talwar: Are you still working on this?

[Anusha Unnam (anusha-unnam)]

@Abhishek Talwar: If you wish to work on this bug, please reassign yourself and push a review for it.