cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amogh Vasekar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-3608) "guest_os_hypervisor" table has repeated mappings of hypervisor and guest OS
Date Mon, 03 Nov 2014 23:39:34 GMT

    [ 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)

Mime
View raw message