[ https://issues.apache.org/jira/browse/CLOUDSTACK-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhinandan Prateek updated CLOUDSTACK-3608: ------------------------------------------- Assignee: (was: Abhinandan Prateek) > "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 > Fix For: 4.3.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.1.5#6160)