[CLOUDSTACK-4386] template physical size is set to zero in template store ref table for templates created from volume is impacting usage

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.2.0
• Fix Version/s: 4.2.0
• Component/s: Template
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: advanced zone with xen server CP 4.2 build; CloudPlatform-4.2-431-rhel6.3.tar.gz
• Assignee: Nitin Mehta
• Reporter: shweta agarwal
• Created: 19/Aug/13 05:55
• Updated: 28/Aug/13 10:21
• Resolved: 19/Aug/13 10:47

Description

template physical size is set to zero in template store ref table for templates created from volume.This is impacting Usage . Usage for such templates will not be generated

SQL entries for
template-store-ref
"id" "store_id" "template_id" "created" "last_updated" "job_id" "download_pct" "size" "store_role" "physical_size" "download_state" "error_str" "local_path" "install_path" "url" "download_url" "download_url_created" "state" "destroyed" "is_copy" "update_count" "ref_cnt" "updated"
"27" "1" "207" "2013-08-19 10:44:40" "" "" "100" "21474836480" "Image" "0" "DOWNLOADED" "" "" "template/tmpl/4/207/784d06d9-66d7-4c42-a876-9c9f76151ce8.vhd" "" "" "" "Ready" "0" "0" "2" "0" "2013-08-19 10:47:09"

vm-template entries :

"id" "unique_name" "name" "uuid" "public" "featured" "type" "hvm" "bits" "url" "format" "created" "removed" "account_id" "checksum" "display_text" "enable_password" "enable_sshkey" "guest_os_id" "bootable" "prepopulate" "cross_zones" "extractable" "hypervisor_type" "source_template_id" "template_tag" "sort_key" "size" "state" "update_count" "updated" "dynamically_scalable"
"207" "29fe912a2-62c7-3d4a-9047-c897e6f154aa" "from volume" "b6b76119-5e72-482b-bea5-cd274a91a553" "1" "1" "USER" "1" "64" "" "VHD" "2013-08-19 10:44:40" "" "4" "" "from volume" "0" "0" "221" "1" "0" "0" "1" "XenServer" "0" "" "0" "21474836480" "" "0" "" "0"

Issue Links

• duplicates: CLOUDSTACK-3730 physical_size column in template_store_ref shows value as 0 when a template is created from a snapshot
• relates to: CLOUDSTACK-3730 physical_size column in template_store_ref shows value as 0 when a template is created from a snapshot