[CLOUDSTACK-568] Source template id is recorded incorrectly.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.2.0
• Component/s: ISO, Template, Volumes
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: Operating System: All; Platform: PC
• Assignee: Bharat Kumar
• Reporter: Bharat Kumar
• Created: 30/Nov/12 05:18
• Updated: 08/Aug/13 09:28
• Resolved: 08/Aug/13 09:27

Description

In the database, there appears to be three templates that have their parents (source_template_id) set to the VMWare tools or XenServer tools ISOs instead of the ISO actually used to install the VM the template was generated from:

mysql> select id, name, format, source_template_id from vm_template where source_template_id in (200,201);
-------------------------------------------------------------+

id

name

format

source_template_id

-------------------------------------------------------------+

271	Windows 2008 Ent. R2 64bit (XEN)	VHD	200
272	W2k8 R2 Ent 64 bit vSphere	OVA	201
273	W2K8 R2 Ent. 64bit	OVA	201

-------------------------------------------------------------+
3 rows in set (0.00 sec)

According to Kelven, this could happen if you launch a VM from an ISO, then later attach the tools ISOs before taking a snapshot and creating the template.

The source_template_id is often used to determine billing information by upstream systems (such as CloudPortal), so this can cause incorrect billing.

Issue Links

• Is contained by: CLOUDSTACK-3836 3.0.6 to ASF 4.2 Upgrade: "cloud" Database Schema Inconsistencies on the Upgraded Setup - Table "volumes"