You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "manasaveloori (JIRA)" <ji...@apache.org> on 2013/06/13 11:23:19 UTC

[jira] [Created] (CLOUDSTACK-2982) listTemplates with templatefilter as “All” is not showing proper listing of templates when there are multiple zones.

manasaveloori created CLOUDSTACK-2982:
-----------------------------------------

             Summary: 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
            Priority: Minor
             Fix For: 4.2.0


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