[ https://issues.apache.org/jira/browse/CLOUDSTACK-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13720649#comment-13720649 ]
manasaveloori commented on CLOUDSTACK-2982: ------------------------------------------- Abhi, Iam not seeing this issue with latest builds, Anyway Pasting the API response: http://10.147.38.154:8096/client/api?command=listTemplates&listAll=true&templatefilter=all <listtemplatesresponse cloud-stack-version="4.2.0-SNAPSHOT"><count>7</count><template><id>c78dd60b-c9e7-48f0-8596-b813c1c33b16</id><name>tempfromsanpVM</name><displaytext>tempfromsanpVM</displaytext><ispublic>true</ispublic><created>2013-07-26T21:33:42+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>OVA</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>75738960-f5df-11e2-8005-063078000024</ostypeid><ostypename>CentOS 5.3 (64-bit)</ostypename><account>admin</account><zoneid>2c1eaf04-8fab-45b5-8402-a1b7c4842fa2</zoneid><zonename>zoneVMw</zonename><status>Download Complete</status><size>4096</size><templatetype>USER</templatetype><hypervisor>VMware</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>true</isextractable><sourcetemplateid>75620fe6-f5df-11e2-8005-063078000024</sourcetemplateid><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>7562a9b0-f5df-11e2-8005-063078000024</id><name>SystemVM Template (vSphere)</name><displaytext>SystemVM Template (vSphere)</displaytext><ispublic>false</ispublic><created>2013-07-26T16:28:26+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>OVA</format><isfeatured>false</isfeatured><crossZones>true</crossZones><ostypeid>75758300-f5df-11e2-8005-063078000024</ostypeid><ostypename>Debian GNU/Linux 5.0 (32-bit)</ostypename><account>system</account><zoneid>2c1eaf04-8fab-45b5-8402-a1b7c4842fa2</zoneid><zonename>zoneVMw</zonename><status>Download Complete</status><size>2097152000</size><templatetype>SYSTEM</templatetype><hypervisor>VMware</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>false</isextractable><checksum>7137e453f950079ea2ba6feaafd939e8</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>756071ae-f5df-11e2-8005-063078000024</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-07-26T16:50:05+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>true</isfeatured><crossZones>true</crossZones><ostypeid>75738960-f5df-11e2-8005-063078000024</ostypeid><ostypename>CentOS 5.3 (64-bit)</ostypename><account>system</account><zoneid>e1fe126b-13a6-4631-a400-882f798588aa</zoneid><zonename>podxen</zonename><status>Download Complete</status><size>21474836480</size><templatetype>BUILTIN</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>true</isextractable><checksum>905cec879afd9c9d22ecc8036131a180</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>true</isdynamicallyscalable></template><template><id>fec56938-1cbe-430c-8c2c-c377e93b0064</id><name>tempsnapxen</name><displaytext>tempsnapxen</displaytext><ispublic>true</ispublic><created>2013-07-26T21:29:58+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>75738960-f5df-11e2-8005-063078000024</ostypeid><ostypename>CentOS 5.3 (64-bit)</ostypename><account>admin</account><zoneid>e1fe126b-13a6-4631-a400-882f798588aa</zoneid><zonename>podxen</zonename><status>Download Complete</status><size>21474836480</size><templatetype>USER</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>true</isextractable><sourcetemplateid>756071ae-f5df-11e2-8005-063078000024</sourcetemplateid><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>75620fe6-f5df-11e2-8005-063078000024</id><name>CentOS 5.3(64-bit) no GUI (vSphere)</name><displaytext>CentOS 5.3(64-bit) no GUI (vSphere)</displaytext><ispublic>true</ispublic><created>2013-07-26T16:35:26+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>OVA</format><isfeatured>true</isfeatured><crossZones>true</crossZones><ostypeid>75738960-f5df-11e2-8005-063078000024</ostypeid><ostypename>CentOS 5.3 (64-bit)</ostypename><account>system</account><zoneid>2c1eaf04-8fab-45b5-8402-a1b7c4842fa2</zoneid><zonename>zoneVMw</zonename><status>Download Complete</status><size>2147483648</size><templatetype>BUILTIN</templatetype><hypervisor>VMware</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>true</isextractable><checksum>f6f881b7f2292948d8494db837fe0f47</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>755db482-f5df-11e2-8005-063078000024</id><name>SystemVM Template (XenServer)</name><displaytext>SystemVM Template (XenServer)</displaytext><ispublic>false</ispublic><created>2013-07-26T16:35:25+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>true</crossZones><ostypeid>75ba87a2-f5df-11e2-8005-063078000024</ostypeid><ostypename>Debian GNU/Linux 6(64-bit)</ostypename><account>system</account><zoneid>e1fe126b-13a6-4631-a400-882f798588aa</zoneid><zonename>podxen</zonename><status>Download Complete</status><size>2101252608</size><templatetype>SYSTEM</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>false</isextractable><checksum>f613f38c96bf039f2e5cbf92fa8ad4f8</checksum><sshkeyenabled>false</sshkeyenabled><isdynamicallyscalable>false</isdynamicallyscalable></template><template><id>fb2df2a5-484c-4995-9142-1d2e907b7820</id><name>ce</name><displaytext>ce</displaytext><ispublic>true</ispublic><created>2013-07-26T21:36:50+0530</created><isready>true</isready><passwordenabled>false</passwordenabled><format>VHD</format><isfeatured>false</isfeatured><crossZones>false</crossZones><ostypeid>75b0e422-f5df-11e2-8005-063078000024</ostypeid><ostypename>CentOS 5.5 (64-bit)</ostypename><account>admin</account><zoneid>e1fe126b-13a6-4631-a400-882f798588aa</zoneid><zonename>podxen</zonename><status>Download Complete</status><size>8589934592</size><templatetype>USER</templatetype><hypervisor>XenServer</hypervisor><domain>ROOT</domain><domainid>7558870a-f5df-11e2-8005-063078000024</domainid><isextractable>false</isextractable><checksum>0eab1c96d9d4b3bcbe7557f8c2190ea7</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: prashant kumar mishra > 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