[
https://issues.apache.org/jira/browse/CLOUDSTACK-3723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13719580#comment-13719580
]
Sanjay Tripathi commented on CLOUDSTACK-3723:
---------------------------------------------
Similar issue found:
The following are the CentOS Guest OS Types listed in the Database. Observe
that the CentOS 6.1,6.2,6.4 types are missing:
mysql> select * from guest_os where display_name like "%CentOS%";
+-----+-------------+------+--------------------------------------+-----------------------+
| id | category_id | name | uuid | display_name |
+-----+-------------+------+--------------------------------------+-----------------------+
| 1 | 1 | NULL | 111 | CentOS 4.5 (32-bit) |
| 2 | 1 | NULL | 112 | CentOS 4.6 (32-bit) |
| 3 | 1 | NULL | 113 | CentOS 4.7 (32-bit) |
| 4 | 1 | NULL | 114 | CentOS 4.8 (32-bit) |
| 5 | 1 | NULL | 115 | CentOS 5.0 (32-bit) |
| 6 | 1 | NULL | 116 | CentOS 5.0 (64-bit) |
| 7 | 1 | NULL | 117 | CentOS 5.1 (32-bit) |
| 8 | 1 | NULL | 118 | CentOS 5.1 (64-bit) |
| 9 | 1 | NULL | 119 | CentOS 5.2 (32-bit) |
| 10 | 1 | NULL | 120 | CentOS 5.2 (64-bit) |
| 11 | 1 | NULL | 121 | CentOS 5.3 (32-bit) |
| 12 | 1 | NULL | 122 | CentOS 5.3 (64-bit) |
| 13 | 1 | NULL | 123 | CentOS 5.4 (32-bit) |
| 14 | 1 | NULL | 124 | CentOS 5.4 (64-bit) |
| 111 | 1 | NULL | 125 | CentOS 5.5 (32-bit) |
| 112 | 1 | NULL | 126 | CentOS 5.5 (64-bit) |
| 141 | 1 | NULL | 127 | CentOS 5.6 (32-bit) |
| 142 | 1 | NULL | 128 | CentOS 5.6 (64-bit) |
| 143 | 1 | NULL | 129 | CentOS 6.0 (32-bit) |
| 144 | 1 | NULL | 130 | CentOS 6.0 (64-bit) |
| 161 | 1 | NULL | 131 | CentOS 5.7 (32-bit) |
| 162 | 1 | NULL | 132 | CentOS 5.7 (64-bit) |
| 171 | 1 | NULL | 171 | CentOS 6.3 (32-bit) |
| 172 | 1 | NULL | 172 | CentOS 6.3 (64-bit) |
| 200 | 1 | NULL | 133 | Other CentOS (32-bit) |
| 201 | 1 | NULL | 134 | Other CentOS (64-bit) |
+-----+-------------+------+--------------------------------------+-----------------------+
> System VM Template for XenServer has wrong guest OS type Information on the
> Database
> ------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3723
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3723
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Upgrade
> Affects Versions: 4.2.0
> Reporter: Chandan Purushothama
> Assignee: Sanjay Tripathi
> Priority: Critical
> Fix For: 4.2.0
>
>
> Observe that the guest_os id of the System VM Template for XenServer is 133
> mysql> select id,name,type,format,display_text,guest_os_id,hypervisor_type
> from vm_template where id=1 \G
> *************************** 1. row ***************************
> id: 1
> name: SystemVM Template (XenServer)
> type: SYSTEM
> format: VHD
> display_text: SystemVM Template (XenServer)
> guest_os_id: 133
> hypervisor_type: XenServer
> 1 row in set (0.00 sec)
> mysql> select id,name,type,format,display_text,guest_os_id,hypervisor_type
> from vm_template where id=8 \G
> *************************** 1. row ***************************
> id: 8
> name: SystemVM Template (vSphere)
> type: SYSTEM
> format: OVA
> display_text: SystemVM Template (vSphere)
> guest_os_id: 15
> hypervisor_type: VMware
> 1 row in set (0.00 sec)
> mysql> select id,name,type,format,display_text,guest_os_id,hypervisor_type
> from vm_template where id=3 \G
> *************************** 1. row ***************************
> id: 3
> name: SystemVM Template (KVM)
> type: SYSTEM
> format: QCOW2
> display_text: SystemVM Template (KVM)
> guest_os_id: 15
> hypervisor_type: KVM
> 1 row in set (0.00 sec)
> mysql>
> mysql> select * from guest_os where id=133;
> +-----+-------------+------+--------------------------------------+----------------------------+
> | id | category_id | name | uuid |
> display_name |
> +-----+-------------+------+--------------------------------------+----------------------------+
> | 133 | 2 | NULL | 0099b9c8-f320-11e2-b49d-06cba2000705 | Debian
> GNU/Linux 6(64-bit) |
> +-----+-------------+------+--------------------------------------+----------------------------+
> 1 row in set (0.00 sec)
> The System VM deployed from the XenServer System VM Template is not a 64 bit
> machine.
> The above correction is crucial for Upgrades
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
