cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-5303) "snapshot" count and "secondary_storage" count are not correct in resource_count table
Date Thu, 05 Dec 2013 18:53:36 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-5303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13840405#comment-13840405
] 

ASF subversion and git services commented on CLOUDSTACK-5303:
-------------------------------------------------------------

Commit fa43987e43162c6f87ca8e341afe55e4f45ef058 in branch refs/heads/4.2 from [~weizhou]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=fa43987 ]

CLOUDSTACK-5303: fix incorrect resource count (snapshot, secondary_storage


> "snapshot" count and "secondary_storage" count  are not correct in resource_count table
> ---------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-5303
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5303
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.2.0, 4.3.0
>            Reporter: Wei Zhou
>            Assignee: Wei Zhou
>             Fix For: 4.2.1, 4.3.0
>
>
> After I had some testing on snapshot (take,delete,create template), the values in resource_count
looks wrong.
> mysql> select * from resource_count where type="snapshot";
> +-----+------------+-----------+----------+-------+
> | id  | account_id | domain_id | type     | count |
> +-----+------------+-----------+----------+-------+
> |   8 |       NULL |         1 | snapshot |     2 |
> |  40 |       NULL |         2 | snapshot |     0 |
> |  52 |       NULL |         3 | snapshot |     0 |
> | 100 |       NULL |         4 | snapshot |     0 |
> | 184 |       NULL |         5 | snapshot |     0 |
> | 220 |       NULL |         6 | snapshot |     1 |
> | 280 |       NULL |         7 | snapshot |     1 |
> | 412 |       NULL |         8 | snapshot |     0 |
> |  16 |          1 |      NULL | snapshot |     0 |
> |  28 |          2 |      NULL | snapshot |     0 |
> |  64 |          3 |      NULL | snapshot |     0 |
> |  76 |          4 |      NULL | snapshot |     0 |
> | 172 |         11 |      NULL | snapshot |     0 |
> | 196 |         12 |      NULL | snapshot |     0 |
> | 208 |         13 |      NULL | snapshot |     0 |
> | 232 |         14 |      NULL | snapshot |     1 |
> | 244 |         15 |      NULL | snapshot |     0 |
> | 292 |         18 |      NULL | snapshot |     1 |
> | 304 |         19 |      NULL | snapshot |     0 |
> | 316 |         20 |      NULL | snapshot |     0 |
> | 328 |         21 |      NULL | snapshot |     0 |
> | 340 |         22 |      NULL | snapshot |     0 |
> | 352 |         23 |      NULL | snapshot |     0 |
> | 376 |         25 |      NULL | snapshot |     0 |
> | 388 |         26 |      NULL | snapshot |     0 |
> | 400 |         27 |      NULL | snapshot |     0 |
> | 424 |         28 |      NULL | snapshot |     1 |
> | 436 |         29 |      NULL | snapshot |    -1 |
> | 448 |         30 |      NULL | snapshot |     0 |
> | 460 |         31 |      NULL | snapshot |     0 |
> | 472 |         32 |      NULL | snapshot |     0 |
> +-----+------------+-----------+----------+-------+
> 31 rows in set (0.00 sec)
> mysql> select * from resource_count where type="secondary_storage";
> +-----+------------+-----------+-------------------+--------------+
> | id  | account_id | domain_id | type              | count        |
> +-----+------------+-----------+-------------------+--------------+
> |   4 |       NULL |         1 | secondary_storage | 567941002752 |
> |  48 |       NULL |         2 | secondary_storage |            0 |
> |  60 |       NULL |         3 | secondary_storage |            0 |
> | 108 |       NULL |         4 | secondary_storage |            0 |
> | 192 |       NULL |         5 | secondary_storage |            0 |
> | 228 |       NULL |         6 | secondary_storage | 300647710720 |
> | 288 |       NULL |         7 | secondary_storage | 128849018880 |
> | 420 |       NULL |         8 | secondary_storage |            0 |
> |  24 |          1 |      NULL | secondary_storage |   8866096640 |
> |  36 |          2 |      NULL | secondary_storage | 172527849472 |
> |  72 |          3 |      NULL | secondary_storage |            0 |
> |  84 |          4 |      NULL | secondary_storage |            0 |
> | 180 |         11 |      NULL | secondary_storage |            0 |
> | 204 |         12 |      NULL | secondary_storage |            0 |
> | 216 |         13 |      NULL | secondary_storage |            0 |
> | 240 |         14 |      NULL | secondary_storage | 257698037760 |
> | 252 |         15 |      NULL | secondary_storage |            0 |
> | 300 |         18 |      NULL | secondary_storage | 128849018880 |
> | 312 |         19 |      NULL | secondary_storage |            0 |
> | 324 |         20 |      NULL | secondary_storage |            0 |
> | 336 |         21 |      NULL | secondary_storage |            0 |
> | 348 |         22 |      NULL | secondary_storage |            0 |
> | 360 |         23 |      NULL | secondary_storage |            0 |
> | 384 |         25 |      NULL | secondary_storage |            0 |
> | 396 |         26 |      NULL | secondary_storage |            0 |
> | 408 |         27 |      NULL | secondary_storage |            0 |
> | 432 |         28 |      NULL | secondary_storage |  42949672960 |
> | 444 |         29 |      NULL | secondary_storage | -42949672960 |
> | 456 |         30 |      NULL | secondary_storage |            0 |
> | 468 |         31 |      NULL | secondary_storage |            0 |
> | 480 |         32 |      NULL | secondary_storage |            0 |
> +-----+------------+-----------+-------------------+--------------+
> 31 rows in set (0.01 sec)



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message