[ 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)