[ 
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

Reply via email to