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