[CLOUDSTACK-3730] physical_size column in template_store_ref shows value as 0 when a template is created from a snapshot

• Type: Bug
• Status: Resolved
• Priority: Critical
• 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: Xenserver
• Assignee: Nitin Mehta
• Reporter: Saksham Srivastava
• Created: 23/Jul/13 09:36
• Updated: 19/Aug/13 12:01
• Resolved: 19/Aug/13 12:01

Description

Creating a template from a snapshot does not update the physical_size column in template_store_ref, while registering a template does.

mysql> select * from template_store_ref;
id: 11
store_id: 1
template_id: 206
created: 2013-07-23 09:16:42
last_updated: NULL
job_id: NULL
download_pct: 100
size: 5368709120
store_role: Image
physical_size: 0
download_state: DOWNLOADED
error_str: NULL
local_path: NULL
install_path: template/tmpl/2/206/af01d134-3fde-43b8-b144-a6db1dff6162.vhd
url: NULL
state: Ready
destroyed: 0
is_copy: 0
update_count: 2
ref_cnt: 0
updated: 2013-07-23 09:20:41

• • • • • • • • • • • • • • • • • • • • • • • • • • • 7. row ***************************
                                                      id: 12
                                                      store_id: 1
                                                      template_id: 207
                                                      created: 2013-07-23 09:33:31
                                                      last_updated: 2013-07-23 09:38:35
                                                      job_id: 21d1b0df-d2ba-4d17-8f7e-6236af9fd4aa
                                                      download_pct: 100
                                                      size: 8589934592
                                                      store_role: Image
                                                      physical_size: 1928962560
                                                      download_state: DOWNLOADED
                                                      error_str: Install completed successfully at 7/23/13 9:25 AM
                                                      local_path: /mnt/SecStorage/6afb4a4d-ac7f-3235-9d7b-f6551c108baf/template/tmpl/2/207/dnld7482648641266117804tmp_
                                                      install_path: template/tmpl/2/207/8922d523-257a-363f-acd9-32d8a413940e.vhd
                                                      url: NULL
                                                      state: Ready
                                                      destroyed: 0
                                                      is_copy: 0
                                                      update_count: 3
                                                      ref_cnt: 0
                                                      updated: 2013-07-23 09:38:35
                                                      7 rows in set (0.00 sec)

template id 11 is template created from snapshot while 12 is registered from url.

Issue Links

• is duplicated by: CLOUDSTACK-4386 template physical size is set to zero in template store ref table for templates created from volume is impacting usage
• is related to: CLOUDSTACK-4386 template physical size is set to zero in template store ref table for templates created from volume is impacting usage