weizhouapache commented on issue #6826:
URL: https://github.com/apache/cloudstack/issues/6826#issuecomment-1288609147

   > @DaanHoogland @weizhouapache @slavkap
   > 
   > The Second storage config is `nfs://10.26.246.10/image`
   > 
   > ```
   > # tree ./*
   > ./tmpl
   > ├── 1
   > │   ├── 3
   > │   │   ├── afd37f36-3775-49b7-bd1e-1af1c52cfe1c.qcow2
   > │   │   └── template.properties
   > │   └── 4
   > │       └── template.properties
   > └── 2
   >     ├── 232
   >     │   └── template.properties
   >     ├── 247
   >     │   ├── 247-2-d800137d-4247-3e93-a3cb-915ba60c921e.iso
   >     │   └── template.properties
   >     └── 248
   >         ├── 4b1ec60e-f0d3-3307-a321-a13152959117.qcow2
   >         └── template.properties
   > 
   > 7 directories, 8 files
   > 
   > 
   > # cat tmpl/1/3/template.properties 
   > filename=afd37f36-3775-49b7-bd1e-1af1c52cfe1c.qcow2
   > description=SystemVM Template
   > hvm=false
   > size=453181440
   > qcow2=true
   > id=3
   > public=true
   > qcow2.filename=afd37f36-3775-49b7-bd1e-1af1c52cfe1c.qcow2
   > uniquename=routing-3
   > qcow2.virtualsize=4194304000
   > virtualsize=4194304000
   > qcow2.size=453181440
   > ```
   > 
   > The path is `afd37f36-3775-49b7-bd1e-1af1c52cfe1c`
   > 
   > and the mysql `template_spool_ref` related to primary storage is 
`c3098158-93e3-40b1-a3e4-882c0f2a47b5` and 
`dea9fed0-a166-45f3-b4d9-39edc1744ff6`
   > 
   > I delete the record using:
   > 
   > ```
   > # DELETE from template_spool_ref WHERE local_path = 
'c3098158-93e3-40b1-a3e4-882c0f2a47b5';
   > # DELETE from template_spool_ref WHERE local_path = 
'dea9fed0-a166-45f3-b4d9-39edc1744ff6';
   > ```
   > 
   > I delete record in `template_spool_ref` and delete the systemvm in 
cloudstack web ui.
   > 
   > But when the new systemvms restarted. there is no new records in mysql
   > 
   > 
![image](https://user-images.githubusercontent.com/4197714/197473741-be9edb1b-e343-4dbe-8c32-c94ce2551d59.png)
   > 
   > and the system vm version is still:
   > 
   > ```
   > root@s-27372-VM:/usr/local/cloud# cat /etc/cloudstack-release 
   > Cloudstack Release 4.16.1 Mon 31 Jan 2022 10:02:56 AM UTC
   > root@s-27372-VM:/usr/local/cloud# ls /usr/local/cloud/
   > root@s-27372-VM:/usr/local/cloud# 
   > root@s-27372-VM:/usr/local/cloud# df -h
   > Filesystem      Size  Used Avail Use% Mounted on
   > udev            640M     0  640M   0% /dev
   > tmpfs           262M  468K  262M   1% /run
   > /dev/vda6       3.2G  1.3G  2.0G  40% /
   > tmpfs           655M     0  655M   0% /dev/shm
   > tmpfs           5.0M     0  5.0M   0% /run/lock
   > /dev/vda1       366M   45M  322M  13% /boot
   > tmpfs           131M     0  131M   0% /run/user/0
   > ```
   > 
   > There is no copy the systemvm template from secondary storage to primary 
storage pools when new systemvms/vrs are created.
   
   
   @xuanyuanaosheng 
   can you check if the vm_template_id of the vm_instance is 3 ?
   
   select vm_template_id from vm_instance where id=27372;
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to