cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wei Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-5303) "snapshot" count and "secondary_storage" count are not correct in resource_count table
Date Thu, 28 Nov 2013 10:42:35 GMT
Wei Zhou created CLOUDSTACK-5303:
------------------------------------

             Summary: "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