Yes looks OK Vladimir, the second entry is as expected. Again it looks like the 
template has downloaded already, so check your template > zones tab.

Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue

On 02/04/2018, 17:51, "Vladimir Melnik" <v.mel...@uplink.ua> wrote:

    I destroyed the new zone and create it again. Haven't enabled it, haven't 
done anything else, but now I have 2 records in `template_store_ref`:
    
    
    *************************** 1. row ***************************
                      id: 41
                store_id: 1
             template_id: 3
                 created: 2016-12-08 11:45:54
            last_updated: 2018-04-01 19:25:34
                  job_id: NULL
            download_pct: 100
                    size: 322954240
              store_role: Image
           physical_size: 322954240
          download_state: DOWNLOADED
               error_str: NULL
              local_path: NULL
            install_path: 
template/tmpl/1/3/612564dc-8119-4c58-ae4c-df965ee99447.qcow2
                     url: 
http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2
                   state: Ready
               destroyed: 0
                 is_copy: 0
            update_count: 0
                 ref_cnt: 0
                 updated: NULL
    download_url_created: 1970-01-01 00:00:00
            download_url: NULL
    *************************** 2. row ***************************
                      id: 4271
                store_id: 61
             template_id: 3
                 created: 2018-04-02 16:45:33
            last_updated: 2018-04-02 16:45:33
                  job_id: NULL
            download_pct: 100
                    size: 0
              store_role: Image
           physical_size: 0
          download_state: DOWNLOADED
               error_str: NULL
              local_path: NULL
            install_path: template/tmpl/1/3/
                     url: 
http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2
                   state: Ready
               destroyed: 0
                 is_copy: 0
            update_count: 0
                 ref_cnt: 0
                 updated: NULL
    download_url_created: NULL
            download_url: NULL
    
    The 2nd record is new, it has different values in the `id`, `store_id`, 
`created` and `last_updated` fields, so I hope it's OK. :-)
    
    On Mon, Apr 02, 2018 at 07:34:08PM +0300, Vladimir Melnik wrote:
    > Thank you for replying!
    > 
    > Yes, I've added the new zone, but I didn't make attempts to install the 
template. At the same time I see that it shows as "DOWNLOADED" in the database 
and in the list of zones where template is installed. At the same time I don't 
see any files in my secondary storage's directory (it's being mounted and 
umounted either from the management servers and virtualization hosts without 
any errors).
    > 
    > Perhaps I should destroy and create the zone to make sure this case won't 
resolve to any glitches...
    > 
    > On Mon, Apr 02, 2018 at 04:26:58PM +0000, Dag Sonstebo wrote:
    > > Hi Vladimir,
    > > 
    > > It won’t cause any damage – but if you are concerned just do a 
mysqldump beforehand.
    > > 
    > > One thing though – have you already added the new zone and secondary 
storage pool? If store ID 41 is your new secondary pool then the second entry 
in your template_store_ref shows the template already downloaded?
    > > 
    > > Regards,
    > > Dag Sonstebo
    > > Cloud Architect
    > > ShapeBlue
    > > 
    > > On 02/04/2018, 17:05, "Vladimir Melnik" <v.mel...@uplink.ua> wrote:
    > > 
    > >     Thank you, Dag!
    > >     
    > >     Wouldn't it damage the existing records?
    > >     
    > >     I have the following one in the `vm_template` table:
    > >     
    > >     *************************** 1. row ***************************
    > >                       id: 3
    > >              unique_name: routing-3
    > >                     name: SystemVM Template (KVM)
    > >                     uuid: b51f9ef8-bd2f-11e6-b74f-06973a00088a
    > >                   public: 0
    > >                 featured: 0
    > >                     type: SYSTEM
    > >                      hvm: 0
    > >                     bits: 64
    > >                      url: 
http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2
    > >                   format: QCOW2
    > >                  created: 2016-12-08 12:18:48
    > >                  removed: NULL
    > >               account_id: 1
    > >                 checksum: c059b0d051e0cd6fbe9d5d4fc40c7e5d
    > >             display_text: SystemVM Template (KVM)
    > >          enable_password: 0
    > >            enable_sshkey: 0
    > >              guest_os_id: 15
    > >                 bootable: 1
    > >              prepopulate: 0
    > >              cross_zones: 1
    > >              extractable: 0
    > >          hypervisor_type: KVM
    > >       source_template_id: NULL
    > >             template_tag: NULL
    > >                 sort_key: 0
    > >                     size: 322954240
    > >                    state: Active
    > >             update_count: 0
    > >                  updated: NULL
    > >     dynamically_scalable: 0
    > >     
    > >     And also there are 2 ones in the `template_store_ref` table:
    > >     
    > >     *************************** 1. row ***************************
    > >                       id: 41
    > >                 store_id: 1
    > >              template_id: 3
    > >                  created: 2016-12-08 11:45:54
    > >             last_updated: 2018-04-01 19:25:34
    > >                   job_id: NULL
    > >             download_pct: 100
    > >                     size: 322954240
    > >               store_role: Image
    > >            physical_size: 322954240
    > >           download_state: DOWNLOADED
    > >                error_str: NULL
    > >               local_path: NULL
    > >             install_path: 
template/tmpl/1/3/612564dc-8119-4c58-ae4c-df965ee99447.qcow2
    > >                      url: 
http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2
    > >                    state: Ready
    > >                destroyed: 0
    > >                  is_copy: 0
    > >             update_count: 0
    > >                  ref_cnt: 0
    > >                  updated: NULL
    > >     download_url_created: 1970-01-01 00:00:00
    > >             download_url: NULL
    > >     *************************** 2. row ***************************
    > >                       id: 4151
    > >                 store_id: 41
    > >              template_id: 3
    > >                  created: 2018-04-02 14:43:49
    > >             last_updated: 2018-04-02 14:43:49
    > >                   job_id: NULL
    > >             download_pct: 100
    > >                     size: 0
    > >               store_role: Image
    > >            physical_size: 0
    > >           download_state: DOWNLOADED
    > >                error_str: NULL
    > >               local_path: NULL
    > >             install_path: template/tmpl/1/3/
    > >                      url: 
http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2
    > >                    state: Ready
    > >                destroyed: 0
    > >                  is_copy: 0
    > >             update_count: 0
    > >                  ref_cnt: 0
    > >                  updated: NULL
    > >     download_url_created: NULL
    > >             download_url: NULL
    > >     
    > >     Maybe it's stupid, but I'm afraid that the script will make changes 
to the record #41 instead of updating the record #4151. How will it know that 
we need to install the template to the store #41 (a new secondary storage of a 
new zone)?
    > >     
    > >     Best regards,
    > >     Vlad
    > >     
    > >     
    > >     On Mon, Apr 02, 2018 at 03:42:38PM +0000, Dag Sonstebo wrote:
    > >     > Vladimir,
    > >     > 
    > >     > Secondary storage is always zone wide, and if you have multiple 
zones then you also select which zone to add the new secondary storage pool to. 
    > >     > So as long as you prepopulate the template as per documentation 
you will be fine.
    > >     > 
    > >     > Regards,
    > >     > Dag Sonstebo
    > >     > Cloud Architect
    > >     > ShapeBlue
    > >     > 
    > >     > On 02/04/2018, 16:37, "Vladimir Melnik" <v.mel...@uplink.ua> 
wrote:
    > >     > 
    > >     >     Hello,
    > >     >     
    > >     >     It might be a bit stupid question, but I'd like to ask for 
some help :)
    > >     >     
    > >     >     How to add a new SystemVM template to a new zone? The 
documentation 
(http://docs.cloudstack.apache.org/projects/cloudstack-installation/en/4.9/management-server/_systemvm.html)
 is quite clear, but I can't see how will ACS understand that the template is 
being added to a new zone. Should I indicate the zone's ID somehow? How to do 
that?
    > >     >     
    > >     >     Thanks in advance!
    > >     >     
    > >     >     -- 
    > >     >     V.Melnik
    > >     >     
    > >     > 
    > >     > 
    > >     > dag.sonst...@shapeblue.com 
    > >     > www.shapeblue.com
    > >     > 53 Chandos Place, Covent Garden, London  WC2N 4HSUK
    > >     > @shapeblue
    > >     >   
    > >     >  
    > >     > 
    > >     
    > >     -- 
    > >     V.Melnik
    > >     
    > > 
    > > 
    > > dag.sonst...@shapeblue.com 
    > > www.shapeblue.com
    > > 53 Chandos Place, Covent Garden, London  WC2N 4HSUK
    > > @shapeblue
    > >   
    > >  
    > > 
    > 
    > -- 
    > V.Melnik
    
    -- 
    V.Melnik
    


dag.sonst...@shapeblue.com 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue
  
 

Reply via email to