[
https://issues.apache.org/jira/browse/CLOUDSTACK-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14195368#comment-14195368
]
Amogh Vasekar commented on CLOUDSTACK-3608:
-------------------------------------------
Issue -
Below query may help to verify :
select * from (select hypervisor_type, hypervisor_version, guest_os_id,
guest_os_name, count(id) as counted from guest_os_hypervisor group by
hypervisor_type, hypervisor_version, guest_os_id) as a where a.counted > 1;
+-----------------+--------------------+-------------+------------------------------+---------+
| hypervisor_type | hypervisor_version | guest_os_id | guest_os_name | counted |
+-----------------+--------------------+-------------+------------------------------+---------+
| KVM | default | 15 | Debian GNU/Linux 5 | 2 |
| KVM | default | 72 | Debian GNU/Linux 5 | 2 |
| KVM | default | 162 | Ubuntu 10.04 | 2 |
| LXC | default | 15 | Debian GNU/Linux 5 | 2 |
| LXC | default | 72 | Debian GNU/Linux 5 | 2 |
| LXC | default | 162 | Ubuntu 10.04 | 2 |
| VmWare | default | 59 | Ubuntu 10.10 (32-bit) | 2 |
| VmWare | default | 100 | Ubuntu 10.10 (64-bit) | 2 |
| VmWare | default | 165 | Windows 8 (32-bit) | 2 |
| VmWare | default | 166 | Windows 8 (64-bit) | 2 |
| VmWare | default | 167 | Windows Server 2012 (64-bit) | 2 |
| Xenserver | 6.2.5 | 168 | Windows Server 2012 (64-bit) | 2 |
| XenServer | default | 111 | CentOS 5.5 (32-bit) | 2 |
| XenServer | default | 112 | CentOS 5.5 (64-bit) | 2 |
| XenServer | default | 141 | CentOS 5.6 (32-bit) | 2 |
| XenServer | default | 142 | CentOS 5.6 (64-bit) | 2 |
| XenServer | default | 143 | CentOS 6.0 (32-bit) | 2 |
| XenServer | default | 144 | CentOS 6.0 (64-bit) | 2 |
| XenServer | default | 161 | CentOS 5.7 (32-bit) | 2 |
| XenServer | default | 162 | CentOS 5.7 (64-bit) | 2 |
| XenServer | default | 165 | Windows 8 (32-bit) | 2 |
| XenServer | default | 166 | Windows 8 (64-bit) | 2 |
| XenServer | default | 167 | Windows Server 2012 (64-bit) | 2 |
| XenServer | default | 171 | CentOS 6.3 (32-bit) | 2 |
| XenServer | default | 172 | CentOS 6.3 (64-bit) | 2 |
| XenServer | default | 173 | CentOS 5.8 (32-bit) | 2 |
| XenServer | default | 174 | CentOS 5.8 (64-bit) | 2 |
| XenServer | default | 175 | CentOS 5.9 (32-bit) | 2 |
| XenServer | default | 176 | CentOS 5.9 (64-bit) | 2 |
| XenServer | default | 177 | CentOS 6.1 (32-bit) | 2 |
| XenServer | default | 178 | CentOS 6.1 (64-bit) | 2 |
| XenServer | default | 179 | CentOS 6.2 (32-bit) | 2 |
| XenServer | default | 180 | CentOS 6.2 (64-bit) | 2 |
| XenServer | default | 181 | CentOS 6.4 (32-bit) | 2 |
| XenServer | default | 182 | CentOS 6.4 (64-bit) | 2 |
+-----------------+--------------------+-------------+------------------------------+---------+
RCA - Old entries existed in guest_os_hypervisor table. Though it is harmless,
better to remove duplicate entries
Solution - Remove duplicate system-defined entries from table, keep the ones
with older ID
> "guest_os_hypervisor" table has repeated mappings of hypervisor and guest OS
> ----------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3608
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3608
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Management Server
> Affects Versions: 4.2.0
> Reporter: Chandan Purushothama
> Assignee: Amogh Vasekar
> Fix For: 4.5.0
>
>
> mysql> select hypervisor_type,guest_os_name,guest_os_id from
> guest_os_hypervisor where guest_os_id in (165,166,167,168);
> +-----------------+------------------------------+-------------+
> | hypervisor_type | guest_os_name | guest_os_id |
> +-----------------+------------------------------+-------------+
> | XenServer | Windows 8 (32-bit) | 165 |
> | XenServer | Windows 8 (64-bit) | 166 |
> | XenServer | Windows Server 2012 (64-bit) | 167 |
> | XenServer | Windows Server 8 (64-bit) | 168 |
> | VmWare | Windows 8 (32-bit) | 165 |
> | VmWare | Windows 8 (64-bit) | 166 |
> | VmWare | Windows Server 2012 (64-bit) | 167 |
> | VmWare | Windows Server 8 (64-bit) | 168 |
> | VmWare | Windows 8 (32-bit) | 165 |
> | VmWare | Windows 8 (64-bit) | 166 |
> | VmWare | Windows Server 2012 (64-bit) | 167 |
> | VmWare | Windows Server 8 (64-bit) | 168 |
> | XenServer | Windows 8 (32-bit) | 165 |
> | XenServer | Windows 8 (64-bit) | 166 |
> | XenServer | Windows Server 2012 (64-bit) | 167 |
> | XenServer | Windows Server 8 (64-bit) | 168 |
> +-----------------+------------------------------+-------------+
> 16 rows in set (0.00 sec)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
