[ 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