[ https://issues.apache.org/jira/browse/CLOUDSTACK-4248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13736752#comment-13736752 ]
Nitin Mehta commented on CLOUDSTACK-4248: ----------------------------------------- I saw the template store ref entries for the builtin templates for vmware and XS and they have the right format. Please check the mysql entries mysql> select * from template_store_ref where template_id=7\G; *************************** 1. row *************************** id: 14 store_id: 6 template_id: 7 created: 2013-08-08 16:26:30 last_updated: 2013-08-09 12:39:16 job_id: 2210d8f4-835f-4c8e-b0c4-ced725022cad download_pct: 100 size: 2147483648 store_role: Image physical_size: 459320832 download_state: DOWNLOADED error_str: Install completed successfully at 8/8/13 11:01 AM local_path: /mnt/SecStorage/0e8da06e-0788-3efb-86a6-b0705a2205d3/template/tmpl/1/7/dnld5688446664484897039tmp_ install_path: template/tmpl/1/7/4c555584-335c-3751-b9e5-5069cbd03f8f.ova url: http://10.147.28.7/releases/2.2.0/CentOS5.3-x86_64.ova download_url: https://10-147-47-53.realhostip.com/userdata/711e329e-af0a-4353-95db-e07114f0149a.ova download_url_created: 2013-08-12 11:51:04 state: Ready destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL *************************** 2. row *************************** id: 21 store_id: 9 template_id: 7 created: 2013-08-08 16:29:58 last_updated: 2013-08-08 16:29:58 job_id: NULL download_pct: 0 size: 0 store_role: Image physical_size: 0 download_state: NOT_DOWNLOADED error_str: NULL local_path: NULL install_path: NULL url: http://10.147.28.7/releases/2.2.0/CentOS5.3-x86_64.ova download_url: NULL download_url_created: NULL state: Allocated destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL *************************** 3. row *************************** id: 40 store_id: 2 template_id: 7 created: 2013-08-12 14:30:32 last_updated: 2013-08-12 14:33:25 job_id: f68455db-0289-4f03-baf6-931e99c3e96c download_pct: 100 size: 2147483648 store_role: Image physical_size: 459320832 download_state: DOWNLOADED error_str: Install completed successfully at 8/12/13 9:08 AM local_path: /mnt/SecStorage/0a639c32-c2df-36e3-883d-eebcb5093bf1/template/tmpl/1/7/dnld9191691464576201332tmp_ install_path: template/tmpl/1/7/ff60340d-68ae-389e-b982-9fe2ee778ecd.ova url: NULL download_url: NULL download_url_created: NULL state: Ready destroyed: 0 is_copy: 0 update_count: 2 ref_cnt: 0 updated: 2013-08-12 14:33:25 3 rows in set (0.00 sec) ERROR: No query specified mysql> select * from template_store_ref where template_id=5\G; *************************** 1. row *************************** id: 6 store_id: 2 template_id: 5 created: 2013-08-08 16:19:21 last_updated: 2013-08-09 12:39:12 job_id: d403bf85-28ef-4c8f-a161-077fade3dde1 download_pct: 100 size: 21474836480 store_role: Image physical_size: 1758786048 download_state: DOWNLOADED error_str: Install completed successfully at 8/8/13 10:57 AM local_path: /mnt/SecStorage/0a639c32-c2df-36e3-883d-eebcb5093bf1/template/tmpl/1/5/dnld532333876603677664tmp_ install_path: template/tmpl/1/5/3deb25f9-a15d-39cc-a7d6-ce47f25504e5.vhd url: http://10.147.28.7/templates/builtin/centos56-x86_64.vhd.bz2 download_url: NULL download_url_created: NULL state: Ready destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL *************************** 2. row *************************** id: 20 store_id: 9 template_id: 5 created: 2013-08-08 16:29:58 last_updated: 2013-08-08 16:29:58 job_id: NULL download_pct: 0 size: 0 store_role: Image physical_size: 0 download_state: NOT_DOWNLOADED error_str: NULL local_path: NULL install_path: NULL url: http://10.147.28.7/templates/builtin/centos56-x86_64.vhd.bz2 download_url: NULL download_url_created: NULL state: Allocated destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL *************************** 3. row *************************** id: 44 store_id: 6 template_id: 5 created: 2013-08-12 14:53:41 last_updated: 2013-08-12 15:05:53 job_id: 39f87b57-8d2c-4e96-a08f-280b9d5b096c download_pct: 100 size: 21474836480 store_role: Image physical_size: 1758786048 download_state: DOWNLOADED error_str: Install completed successfully at 8/12/13 9:41 AM local_path: /mnt/SecStorage/0e8da06e-0788-3efb-86a6-b0705a2205d3/template/tmpl/1/5/dnld8874329555229464352tmp_ install_path: template/tmpl/1/5/1ad4ca85-2a53-3a10-81d0-f6ea55175efc.vhd url: NULL download_url: NULL download_url_created: NULL state: Ready destroyed: 0 is_copy: 0 update_count: 2 ref_cnt: 0 updated: 2013-08-12 15:05:53 3 rows in set (0.00 sec) ERROR: No query specified > Copy default template across zones with different hypervisors is saving the > template as .iso file at destination zones secondary storage. > ----------------------------------------------------------------------------------------------------------------------------------------- > > Key: CLOUDSTACK-4248 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4248 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Template > Affects Versions: 4.2.0 > Reporter: manasaveloori > Assignee: Nitin Mehta > Priority: Critical > Fix For: 4.2.0 > > > Steps: > 1. Have CS with 2 zones(zoneXen and ZoneVMw) with 2 clusters having Xen > and Vmware hosts. > 2. Copy the default template from one zone to another. > Observation: > Default template copy is success. The copied template is stored as .iso file > in secondary storage of the destination zone. > If the destination zone does not have the supported hypervisor to copy the > template, copy template should fail. In this case copy is not failing and > more over it is saved as an .iso file which is not valid > *************************** 27. row *************************** > id: 45 > store_id: 2 > template_id: 216 > created: 2013-08-12 15:00:26 > last_updated: 2013-08-12 15:01:02 > job_id: 5434eedd-d704-4a73-8de6-05ce6b30d3ff > download_pct: 100 > size: 358400 > store_role: Image > physical_size: 358400 > download_state: DOWNLOADED > error_str: Install completed successfully at 8/12/13 9:36 AM > local_path: > /mnt/SecStorage/0a639c32-c2df-36e3-883d-eebcb5093bf1/template/tmpl/9/216/dnld4529817597804272417tmp_ > install_path: > template/tmpl/9/216/216-9-23f8feda-ffba-38a1-9e3d-841072518bc8.iso > url: NULL > download_url: NULL > download_url_created: NULL > state: Ready > destroyed: 0 > is_copy: 0 > update_count: 2 > ref_cnt: 0 > updated: 2013-08-12 15:01:02 > *************************** 28. row *************************** > id: 47 > store_id: 6 > template_id: 216 > created: 2013-08-12 15:00:26 > last_updated: 2013-08-12 15:01:04 > job_id: 88d96c60-7443-4626-8c2d-c6020831dced > download_pct: 100 > size: 358400 > store_role: Image > physical_size: 358400 > download_state: DOWNLOADED > error_str: Install completed successfully at 8/12/13 9:36 AM > local_path: > /mnt/SecStorage/0e8da06e-0788-3efb-86a6-b0705a2205d3/template/tmpl/9/216/dnld5944478410480646111tmp_ > install_path: > template/tmpl/9/216/216-9-23f8feda-ffba-38a1-9e3d-841072518bc8.iso > url: NULL > download_url: NULL > download_url_created: NULL > state: Ready > destroyed: 0 > is_copy: 0 > update_count: 2 > ref_cnt: 0 > updated: 2013-08-12 15:01:04 > 28 rows in set (0.00 sec) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira