subhash yedugundla created CLOUDSTACK-8921:
----------------------------------------------

             Summary: snapshot_store_ref table should store actual size of back 
snapshot in secondary storage
                 Key: CLOUDSTACK-8921
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8921
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Snapshot, Usage
    Affects Versions: 4.5.2
         Environment: Hypervisor: Xen Server
Hypervisor Version: 6.2 + SP1 
            Reporter: subhash yedugundla


CCP is storing physical-utilisation of the snapshot in physical_size column of 
the table "snapshot_store_ref". That was fixed as part of 
https://issues.apache.org/jira/browse/CLOUDSTACK-7842.

. From DB:
=====================

mysql> select * from snapshot_store_ref where id=586 \G;
*************************** 1. row ***************************
id: 586
store_id: 1
snapshot_id: 305
created: 2015-06-15 06:06:22
last_updated: NULL
job_id: NULL
store_role: Image
size: 5368709120
physical_size: 13312 ---> This is the size we are storing in the DB
parent_snapshot_id: 0
install_path: snapshots/2/233/e8d888a5-41c0-4a17-b1b7-f9a6fd50c0d3
state: Ready
update_count: 2
ref_cnt: 0
updated: 2015-06-15 06:06:36
volume_id: 233
1 row in set (0.00 sec)

 From File System:
=====================
[root@kirangoleta2 233]# ls -lh
total 2.1M
-rw-r--r--. 1 root root 2.1M Jun 15 11:36 
e8d888a5-41c0-4a17-b1b7-f9a6fd50c0d3.vhd ---> Physical file size

3. From Xen Server:
=====================
xe vdi-list name-label=newtest_ROOT-203_20150615060620 params=all

uuid ( RO) : 74a4185e-74fe-4cec-875b-060572cc675d
name-label ( RW): newtest_ROOT-203_20150615060620
name-description ( RW):
is-a-snapshot ( RO): true
snapshot-of ( RO): 02789581-7bfc-45bd-8e59-c35515d2b605
snapshots ( RO):
snapshot-time ( RO): 20150615T06:09:29Z
allowed-operations (SRO): forget; generate_config; update; resize; destroy; 
clone; copy; snapshot
current-operations (SRO):
sr-uuid ( RO): 73ff08fb-b341-c71c-e2c7-be6c8d395126
sr-name-label ( RO): 347c06fb-f7dd-3613-aa82-db5b82181d77
vbd-uuids (SRO):
crashdump-uuids (SRO):
virtual-size ( RO): 5368709120
physical-utilisation ( RO): 14848 ---> This is the size xen server reports as 
consumed
location ( RO): 74a4185e-74fe-4cec-875b-060572cc675d
type ( RO): User
sharable ( RO): false
read-only ( RO): false
storage-lock ( RO): false
managed ( RO): true
parent ( RO): <not in database>
missing ( RO): false
other-config (MRW): content_id: ad6423f7-e2c3-7ea4-be8d-573ad155511e
xenstore-data (MRO):
sm-config (MRO): vhd-parent: 73a33517-e9c5-48c6-89e7-70e37905a74a
on-boot ( RW): persist
allow-caching ( RW): false
metadata-latest ( RO): false
metadata-of-pool ( RO): <not in database>
tags (SRW):

I see that we are storing the physical-utilisation reported by xen server.
Interesting I see that ACS stores the physical file size in case of VMWare 
environment,

EXPECTED BEHAVIOR
==================
It is expected to see the physical size of the snapshot file in physical_size 
column of the table "snapshot_store_ref

ACTUAL BEHAVIOR
==================
In case of Xen Server CCP is storing physical-utilisation of the snapshot in 
physical_size column of the table "snapshot_store_ref"





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to