[ https://issues.apache.org/jira/browse/CLOUDSTACK-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhinandan Prateek updated CLOUDSTACK-2982: ------------------------------------------- Assignee: (was: Abhinandan Prateek) > 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 > 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