You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2014/01/08 15:37:51 UTC
[jira] [Commented] (CLOUDSTACK-5303) "snapshot" count and
"secondary_storage" count are not correct in resource_count table
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13865482#comment-13865482 ]
ASF subversion and git services commented on CLOUDSTACK-5303:
-------------------------------------------------------------
Commit 4bb85cd7f921d66eabe72d00dcde817affd48732 in branch refs/heads/4.3 from [~weizhou]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=4bb85cd ]
CLOUDSTACK-5303: fix incorrect resource count (snapshot, secondary_storage)
(cherry picked from commit fa43987e43162c6f87ca8e341afe55e4f45ef058)
> "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.5#6160)