[CLOUDSTACK-9637] Template create from snapshot does not populate vm_template_details

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.8.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: VMware ESX , CS 4.8.0
• Assignee: Sudhansu Sahu
• Reporter: Sudhansu Sahu
• Created: 01/Dec/16 05:43
• Updated: 08/Dec/16 11:49

Description

ISSUE
============
Template create from snapshot does not populate vm_template_details

TROUBLESHOOTING
==================

mysql> select id,name,uuid,instance_name,vm_template_id from vm_instance where uuid='453313f5-ef97-461a-94f5-0838617fe826'
    -> ;
+----+-------+--------------------------------------+---------------+----------------+
| id | name  | uuid                                 | instance_name | vm_template_id |
+----+-------+--------------------------------------+---------------+----------------+
|  9 | vm001 | 453313f5-ef97-461a-94f5-0838617fe826 | i-2-9-VM      |            202 |
+----+-------+--------------------------------------+---------------+----------------+
1 row in set (0.00 sec)

mysql> select id,name,source_template_id from vm_template where id=202; 
+-----+--------+--------------------+
| id  | name   | source_template_id |
+-----+--------+--------------------+
| 202 | Debian |               NULL |
+-----+--------+--------------------+
1 row in set (0.00 sec)

mysql> select * from vm_template_details where template_id=202; 
+----+-------------+--------------------+-------+---------+
| id | template_id | name               | value | display |
+----+-------------+--------------------+-------+---------+
|  1 |         202 | keyboard           | us    |       1 |
|  2 |         202 | nicAdapter         | E1000 |       1 |
|  3 |         202 | rootDiskController | scsi  |       1 |
+----+-------------+--------------------+-------+---------+
3 rows in set (0.00 sec)

mysql> select id,name,source_template_id from vm_template where source_template_id=202;
+-----+----------------+--------------------+
| id  | name           | source_template_id |
+-----+----------------+--------------------+
| 203 | derived-debian |                202 |
+-----+----------------+--------------------+
1 row in set (0.00 sec)

mysql> select * from vm_template_details where template_id=203;
Empty set (0.00 sec)

REPRO STEPS
==================
1. Register a template A and specify property:
Root disk controller: scsi
NIC adapter type: E1000
Keyboard type: us

2. Create a vm instance from template A

3. Take volume snapshot for vm instance

4. Delete VM instance

5. Switch to "Storage->Snapshots", convert snapshot to a template B

6. Observe template B does not inherit property from template A, the table vm_template_details is empty

EXPECTED BEHAVIOR
==================
Template should inherit property from source template

ACTUAL BEHAVIOR
==================
Detail template property lost

Issue Links

• links to: GitHub Pull Request #1805