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)
