Hi all,

I am just starting to have a first look on CloudStack Usage Service in 4.11.

Maybe I am getting something wrong, but to me it seems, that Usage
reports lists destroyed and expunged Volumes. Is that the intended
behaviour?

For an example project it lists the following records:

(rz-admin) :D > list usagerecords startdate=2018-05-16
enddate=2018-05-16 projectid=a5496954-0f3c-4511-b54c-db9aa14ee9ac type=6
filter=description,
count = 18
usagerecord:
+------------------------------------------------+
|                  description                   |
+------------------------------------------------+
|   Volume Id: 2222 usage time (Template: 471)   |
|   Volume Id: 2420 usage time (Template: 521)   |
| Volume Id: 2567 usage time (DiskOffering: 147) |
| Volume Id: 2719 usage time (DiskOffering: 96)  |
| Volume Id: 2920 usage time (DiskOffering: 95)  |
|   Volume Id: 2528 usage time (Template: 521)   |
|   Volume Id: 2809 usage time (Template: 394)   |
|   Volume Id: 2243 usage time (Template: 467)   |
|   Volume Id: 2505 usage time (Template: 394)   |
|   Volume Id: 2396 usage time (Template: 517)   |
|   Volume Id: 3696 usage time (Template: 521)   |
|   Volume Id: 2239 usage time (Template: 400)   |
| Volume Id: 3174 usage time (DiskOffering: 95)  |
|   Volume Id: 3675 usage time (Template: 521)   |
|   Volume Id: 2172 usage time (Template: 394)   |
|   Volume Id: 2225 usage time (Template: 390)   |
|   Volume Id: 2223 usage time (Template: 471)   |
|   Volume Id: 3255 usage time (Template: 521)   |
+------------------------------------------------+

Quering the IDs in the database I get records for a lot of destroyed and
expunged volumes.

mysql> select distinct id,removed,state from volumes where id=2222 or
id=2420 or id=2567 or id=2719 or id=2920 or id=2528 or id=2809 or
id=2243 or id=2505 or id=2396 or id=3696 or id=2239 or id=3174 or
id=3675 or id=2172 or id=2225 or id=2223 or id=3255 order by id;
+------+---------------------+----------+
| id   | removed             | state    |
+------+---------------------+----------+
| 2172 | 2017-08-28 12:37:57 | Destroy  |
| 2222 | 2017-01-30 13:06:40 | Destroy  |
| 2223 | 2017-01-30 12:08:54 | Destroy  |
| 2225 | 2017-01-30 13:06:21 | Destroy  |
| 2239 | 2017-02-09 13:25:26 | Destroy  |
| 2243 | 2017-08-28 12:28:36 | Destroy  |
| 2396 | 2017-05-15 10:13:24 | Destroy  |
| 2420 | 2017-08-28 11:48:57 | Destroy  |
| 2505 | NULL                | Ready    |
| 2528 | 2017-07-15 08:54:32 | Destroy  |
| 2567 | 2017-08-28 12:27:57 | Destroy  |
| 2719 | 2017-07-15 09:03:36 | Expunged |
| 2809 | 2017-07-25 12:51:50 | Destroy  |
| 2920 | 2017-10-24 12:12:05 | Expunged |
| 3174 | NULL                | Ready    |
| 3255 | NULL                | Ready    |
| 3675 | NULL                | Ready    |
| 3696 | NULL                | Ready    |
+------+---------------------+----------+
18 rows in set (0.00 sec)

I would usage expect to list only the volumes actually provisioned. So
listing "Destroyed" volumes might be to be expected. But listing
"Expunged" volumes seems wrong to me.

Greetings,

Melanie
-- 
--

Heinlein Support GmbH
Linux: Akademie - Support - Hosting

http://www.heinlein-support.de
Tel: 030 / 40 50 51 - 0
Fax: 030 / 40 50 51 - 19

Zwangsangaben lt. §35a GmbHG:
HRB 93818 B / Amtsgericht Berlin-Charlottenburg,
Geschäftsführer: Peer Heinlein  -- Sitz: Berlin

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to