[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

manasaveloori reopened CLOUDSTACK-2982:
---------------------------------------


Observed the issue on upgraded setup.upgraded from 3.0.6 to 4.2
API:
http://10.147.38.171:8096/client/api?command=listTemplates&templatefilter=all

Response:
<listtemplatesresponse 
cloud-stack-version="4.2.0-SNAPSHOT"><count>10</count><template><id>d822be14-8908-45a5-b7b0-6c24b6cfe6ef</id><name>tempsnap</name><displaytext>tempsnap</displaytext><ispublic>true</ispublic><created>2013-08-02T21:39:44+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>12</ostypeid><ostypename>CentOS
 5.3 
(64-bit)</ostypename><account>admin</account><zoneid>bf752771-ae69-4f52-8d6a-6aba01b673b9</zoneid><zonename>zonexen</zonename><status>Download
 
Complete</status><size>21474836480</size><templatetype>USER</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>true</isextractable><sourcetemplateid>5</sourcetemplateid><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>4</id><name>CentOS
 5.5(64-bit) no GUI (KVM)</name><displaytext>CentOS 5.5(64-bit) no GUI 
(KVM)</displaytext><ispublic>true</ispublic><created>2013-08-01T17:25:23+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>QCOW2</format><isfeatured>true</isfeatured><crossZones>true</crossZones><ostypeid>112</ostypeid><ostypename>CentOS
 5.5 
(64-bit)</ostypename><account>system</account><zoneid>51648687-4645-4014-ae33-cbf0d04865d8</zoneid><zonename>zoneKVM</zonename><status>Download
 
Complete</status><size>8589934592</size><templatetype>BUILTIN</templatetype><hypervisor>KVM</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>true</isextractable><checksum>ed0e788280ff2912ea40f7f91ca7a249</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>daa34ed2-4093-484c-8fc0-6ca2d2d635a6</id><name>systemvm-kvm-4.2</name><displaytext>systemvm-kvm-4.2</displaytext><ispublic>false</ispublic><created>2013-08-01T19:28:11+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>QCOW2</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>15</ostypeid><ostypename>Debian
 GNU/Linux 5.0 
(32-bit)</ostypename><account>admin</account><zoneid>51648687-4645-4014-ae33-cbf0d04865d8</zoneid><zonename>zoneKVM</zonename><status>Download
 
Complete</status><size>2097152000</size><templatetype>SYSTEM</templatetype><hypervisor>KVM</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>false</isextractable><checksum>6cea42b2633841648040becb588bd8f0</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>5</id><name>CentOS
 5.6(64-bit) no GUI (XenServer)</name><displaytext>CentOS 5.6(64-bit) no GUI 
(XenServer)</displaytext><ispublic>true</ispublic><created>2013-08-01T17:28:40+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>true</isfeatured><crossZones>true</crossZones><ostypeid>12</ostypeid><ostypename>CentOS
 5.3 
(64-bit)</ostypename><account>system</account><zoneid>bf752771-ae69-4f52-8d6a-6aba01b673b9</zoneid><zonename>zonexen</zonename><status>Download
 
Complete</status><size>21474836480</size><templatetype>BUILTIN</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>true</isextractable><checksum>905cec879afd9c9d22ecc8036131a180</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>true</isdynamicallyscalable></template><template><id>5</id><name>CentOS
 5.6(64-bit) no GUI (XenServer)</name><displaytext>CentOS 5.6(64-bit) no GUI 
(XenServer)</displaytext><ispublic>true</ispublic><created>2013-08-01T17:25:23+0530</created><isready>false</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>true</isfeatured><crossZones>true</crossZones><ostypeid>12</ostypeid><ostypename>CentOS
 5.3 
(64-bit)</ostypename><account>system</account><zoneid>51648687-4645-4014-ae33-cbf0d04865d8</zoneid><zonename>zoneKVM</zonename><templatetype>BUILTIN</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>true</isextractable><checksum>905cec879afd9c9d22ecc8036131a180</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>true</isdynamicallyscalable></template><template><id>1</id><name>SystemVM
 Template (XenServer)</name><displaytext>SystemVM Template 
(XenServer)</displaytext><ispublic>false</ispublic><created>2013-08-01T17:23:10+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>true</crossZones><ostypeid>133</ostypeid><ostypename>Debian
 GNU/Linux 
6(64-bit)</ostypename><account>system</account><zoneid>bf752771-ae69-4f52-8d6a-6aba01b673b9</zoneid><zonename>zonexen</zonename><status>Download
 
Complete</status><size>565240320</size><templatetype>SYSTEM</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>false</isextractable><checksum>f613f38c96bf039f2e5cbf92fa8ad4f8</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>1</id><name>SystemVM
 Template (XenServer)</name><displaytext>SystemVM Template 
(XenServer)</displaytext><ispublic>false</ispublic><created>2013-08-01T17:18:44+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>true</crossZones><ostypeid>133</ostypeid><ostypename>Debian
 GNU/Linux 
6(64-bit)</ostypename><account>system</account><zoneid>51648687-4645-4014-ae33-cbf0d04865d8</zoneid><zonename>zoneKVM</zonename><status>Download
 
Complete</status><templatetype>SYSTEM</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>false</isextractable><checksum>f613f38c96bf039f2e5cbf92fa8ad4f8</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>8c1ed576-6d18-402d-a0cb-5a60aad10fdd</id><name>Cent53</name><displaytext>Cent53</displaytext><ispublic>true</ispublic><created>2013-08-02T16:34:49+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>true</isfeatured><crossZones>false</crossZones><ostypeid>12</ostypeid><ostypename>CentOS
 5.3 
(64-bit)</ostypename><account>admin</account><zoneid>bf752771-ae69-4f52-8d6a-6aba01b673b9</zoneid><zonename>zonexen</zonename><status>Download
 
Complete</status><size>21474836480</size><templatetype>USER</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>true</isextractable><checksum>34b5f768be3fbcbfd96436a093e432e5</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>3</id><name>SystemVM
 Template (KVM)</name><displaytext>SystemVM Template 
(KVM)</displaytext><ispublic>false</ispublic><created>2013-08-01T17:18:44+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>QCOW2</format><isfeatured>false</isfeatured><crossZones>true</crossZones><ostypeid>15</ostypeid><ostypename>Debian
 GNU/Linux 5.0 
(32-bit)</ostypename><account>system</account><zoneid>51648687-4645-4014-ae33-cbf0d04865d8</zoneid><zonename>zoneKVM</zonename><status>Download
 
Complete</status><size>725811200</size><templatetype>SYSTEM</templatetype><hypervisor>KVM</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>false</isextractable><checksum>2755de1f9ef2ce4d6f2bee2efbb4da92</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>60d73d07-7580-4a23-8bad-e5db33c1d23a</id><name>systemvm-xenserver-4.2</name><displaytext>systemvm-xenserver-4.2</displaytext><ispublic>false</ispublic><created>2013-08-01T19:27:10+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>133</ostypeid><ostypename>Debian
 GNU/Linux 
6(64-bit)</ostypename><account>admin</account><zoneid>bf752771-ae69-4f52-8d6a-6aba01b673b9</zoneid><zonename>zonexen</zonename><status>Download
 
Complete</status><size>2097152000</size><templatetype>SYSTEM</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>1</domainid><isextractable>false</isextractable><checksum>74b92f031cc5c2089ee89efb81344dcf</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template></listtemplatesresponse>
                
> listTemplates with templatefilter as “All” is not showing  proper listing of 
> templates when there are multiple zones.
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-2982
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2982
>             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: Abhinandan Prateek
>             Fix For: 4.2.0
>
>         Attachments: listTemplate.jpg
>
>
> Steps:
> 1.    Have a CS with multiple zones. I have 2 advanced zones (1 using xen and 
> other VMware).
> 2.    Go to templates page. Filter by “All”.
> Observation:
> The listing is not proper when multiple zones are there. Some templates are 
> not downloaded and the zone ,hypervisor mapping for the templates are not 
> proper.
> Attached is the screenshot.
> mysql> select * from template_host_ref\G;
> *************************** 1. row ***************************
>             id: 1
>        host_id: 2
>    template_id: 10
>        created: 2013-06-12 11:52:07
>   last_updated: 2013-06-12 11:52:07
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/10/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 2. row ***************************
>             id: 2
>        host_id: 2
>    template_id: 9
>        created: 2013-06-12 11:52:07
>   last_updated: 2013-06-12 11:52:07
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/9/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.vhd.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 3. row ***************************
>             id: 3
>        host_id: 2
>    template_id: 8
>        created: 2013-06-12 11:52:07
>   last_updated: 2013-06-13 10:35:24
>         job_id: NULL
>   download_pct: 100
>           size: 2097152000
>  physical_size: 372702720
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/8//74e8ee19-8ea4-495a-899a-446970388717.ova
>            url: 
> http://download.cloud.com/templates/burbank/burbank-systemvm-08012012.ova
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 4. row ***************************
>             id: 4
>        host_id: 2
>    template_id: 3
>        created: 2013-06-12 11:52:07
>   last_updated: 2013-06-12 11:52:07
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/3/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 5. row ***************************
>             id: 5
>        host_id: 2
>    template_id: 1
>        created: 2013-06-12 11:52:07
>   last_updated: 2013-06-12 11:52:07
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/1/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.vhd.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 6. row ***************************
>             id: 6
>        host_id: 5
>    template_id: 10
>        created: 2013-06-12 11:58:04
>   last_updated: 2013-06-12 11:58:04
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/10/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 7. row ***************************
>             id: 7
>        host_id: 5
>    template_id: 9
>        created: 2013-06-12 11:58:04
>   last_updated: 2013-06-12 11:58:04
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/9/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.vhd.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 8. row ***************************
>             id: 8
>        host_id: 5
>    template_id: 8
>        created: 2013-06-12 11:58:04
>   last_updated: 2013-06-12 11:58:04
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/8/
>            url: 
> http://download.cloud.com/templates/burbank/burbank-systemvm-08012012.ova
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 9. row ***************************
>             id: 9
>        host_id: 5
>    template_id: 3
>        created: 2013-06-12 11:58:04
>   last_updated: 2013-06-12 11:58:04
>         job_id: NULL
>   download_pct: 100
>           size: 0
>  physical_size: 0
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/3/
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 10. row ***************************
>             id: 10
>        host_id: 5
>    template_id: 1
>        created: 2013-06-12 11:58:04
>   last_updated: 2013-06-13 10:35:23
>         job_id: NULL
>   download_pct: 100
>           size: 2101252608
>  physical_size: 2101252608
> download_state: DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: template/tmpl/1/1//0a511208-77fe-477a-b358-0d40f33bfb6f.vhd
>            url: 
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.vhd.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 11. row ***************************
>             id: 11
>        host_id: 2
>    template_id: 4
>        created: 2013-06-12 11:58:46
>   last_updated: 2013-06-12 11:58:46
>         job_id: NULL
>   download_pct: 0
>           size: 0
>  physical_size: 0
> download_state: NOT_DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: NULL
>            url: 
> http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 12. row ***************************
>             id: 12
>        host_id: 2
>    template_id: 5
>        created: 2013-06-12 11:58:46
>   last_updated: 2013-06-12 11:58:46
>         job_id: NULL
>   download_pct: 0
>           size: 0
>  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
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 13. row ***************************
>             id: 13
>        host_id: 2
>    template_id: 7
>        created: 2013-06-12 11:58:46
>   last_updated: 2013-06-13 10:35:24
>         job_id: dd212d95-69a0-4a96-8991-ece514f5c415
>   download_pct: 100
>           size: 2147483648
>  physical_size: 459320832
> download_state: DOWNLOADED
>      error_str: Install completed successfully at 6/12/13 6:37 AM
>     local_path: 
> /mnt/SecStorage/0e8da06e-0788-3efb-86a6-b0705a2205d3/template/tmpl/1/7/dnld719896144530704458tmp_
>   install_path: template/tmpl/1/7//991e95fe-5f09-3040-a37f-87f386704a74.ova
>            url: http://10.147.28.7/releases/2.2.0/CentOS5.3-x86_64.ova
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 14. row ***************************
>             id: 14
>        host_id: 5
>    template_id: 4
>        created: 2013-06-12 12:05:32
>   last_updated: 2013-06-12 12:05:32
>         job_id: NULL
>   download_pct: 0
>           size: 0
>  physical_size: 0
> download_state: NOT_DOWNLOADED
>      error_str: NULL
>     local_path: NULL
>   install_path: NULL
>            url: 
> http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 15. row ***************************
>             id: 15
>        host_id: 5
>    template_id: 5
>        created: 2013-06-12 12:05:32
>   last_updated: 2013-06-13 10:35:23
>         job_id: a421307e-ecbf-4927-9375-8be4843d577a
>   download_pct: 100
>           size: 21474836480
>  physical_size: 1758786048
> download_state: DOWNLOADED
>      error_str: Install completed successfully at 6/12/13 6:43 AM
>     local_path: 
> /mnt/SecStorage/0a639c32-c2df-36e3-883d-eebcb5093bf1/template/tmpl/1/5/dnld6871166169255782439tmp_
>   install_path: template/tmpl/1/5//afb285c1-1a6a-35e9-a19d-706b3b3a0acf.vhd
>            url: http://10.147.28.7/templates/builtin/centos56-x86_64.vhd.bz2
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 16. row ***************************
>             id: 16
>        host_id: 5
>    template_id: 7
>        created: 2013-06-12 12:05:32
>   last_updated: 2013-06-12 12:05:32
>         job_id: NULL
>   download_pct: 0
>           size: 0
>  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
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> *************************** 17. row ***************************
>             id: 17
>        host_id: 2
>    template_id: 202
>        created: 2013-06-12 15:38:18
>   last_updated: 2013-06-13 10:35:24
>         job_id: 10e65c5e-313a-4865-a4b6-9b8424be6576
>   download_pct: 100
>           size: 2147483648
>  physical_size: 459320832
> download_state: DOWNLOADED
>      error_str: Install completed successfully at 6/12/13 10:15 AM
>     local_path: 
> /mnt/SecStorage/0e8da06e-0788-3efb-86a6-b0705a2205d3/template/tmpl/2/202/dnld8108765456110116910tmp_
>   install_path: template/tmpl/2/202//9eb0f105-bd64-3380-b7a4-244851513a6b.ova
>            url: http://10.147.28.7/releases/2.2.0/CentOS5.3-x86_64.ova
>      destroyed: 0
>        is_copy: 0
>          state: NULL
>   update_count: 0
>        updated: NULL
> 17 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