Details
Description
Steps to reproduce the problem:
Set - Advanced zone set up with KVM (Rhel 6.3) hosts.
Create an account.
Deploy few Vms.
Take snapshots of "ROOT" volumes of few of the Vms.
Check the resource_count for "secondary_storage" for this account.
It is always set to 0.
Notice that this value gets set to the virtual size of the the Volume when snapshot is in Progress.
Once snapshot is done , it gets updated to 0.
mysql> select * from resource_count where account_id=4;
----------------------------------------------------
id account_id domain_id type count
----------------------------------------------------
53 4 NULL user_vm 12
54 4 NULL public_ip 13
55 4 NULL volume 12
56 4 NULL snapshot 5
57 4 NULL template 0
58 4 NULL project 0
59 4 NULL network 1
60 4 NULL vpc 0
61 4 NULL cpu 12
62 4 NULL memory 1536
63 4 NULL primary_storage 103079215104
64 4 NULL secondary_storage 0
----------------------------------------------------
12 rows in set (0.00 sec)
mysql> select * from snapshots where account_id=4;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
id data_center_id account_id domain_id volume_id disk_offering_id status path name uuid snapshot_type type_description size created removed backup_snap_id swift_id sechost_id prev_snap_id hypervisor_type version s3_id
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
750 1 4 1 40 16 BackedUp NULL TestVM-tiny-host-1ps-0-4_ROOT-40_20140113223219 0696a291-7fe6-47d6-b4d4-0d489d7ddb3e 0 MANUAL 8589934592 2014-01-13 22:32:19 NULL NULL NULL NULL NULL KVM 2.2 NULL
751 1 4 1 41 12 BackedUp NULL testnew_ROOT-41_20140113224709 3ba19873-8a90-49f5-8a5c-58d0c980fc2b 0 MANUAL 8589934592 2014-01-13 22:47:09 NULL NULL NULL NULL NULL KVM 2.2 NULL
752 1 4 1 41 12 BackedUp NULL testnew_ROOT-41_20140113225245 d73d8c26-4f2a-4ead-801c-8e8cee42ab70 0 MANUAL 8589934592 2014-01-13 22:52:45 NULL NULL NULL NULL NULL KVM 2.2 NULL
755 1 4 1 38 16 BackedUp NULL TestVM-tiny-host-1ps-0-2_ROOT-38_20140114020510 80672e8b-4a45-4070-9686-c68aee9c217d 0 MANUAL 8589934592 2014-01-14 02:05:10 NULL NULL NULL NULL NULL KVM 2.2 NULL
756 1 4 1 40 16 BackedUp NULL TestVM-tiny-host-1ps-0-4_ROOT-40_20140116234727 db0300ec-9558-40eb-8244-a8fbef7ad9b4 0 MANUAL 8589934592 2014-01-16 23:47:27 NULL NULL NULL NULL NULL KVM 2.2 NULL
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)