[jira] [Commented] (CLOUDSTACK-3607) guest_os_hypervisor table has values that are not registered in guest_os table
[ https://issues.apache.org/jira/browse/CLOUDSTACK-3607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14217072#comment-14217072 ] Amogh Vasekar commented on CLOUDSTACK-3607: --- Fixed already as a part of guest OS changes. mysql select * from guest_os_hypervisor where guest_os_id not in (select id from guest_os); Empty set (0.01 sec) The table is now used for guest OS mappings coming from DB rather than hardcoded guest_os_hypervisor table has values that are not registered in guest_os table -- Key: CLOUDSTACK-3607 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3607 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.4.0, 4.5.0 mysql select * from guest_os_hypervisor where guest_os_id not in (select id from guest_os); +-+-++-+ | id | hypervisor_type | guest_os_name | guest_os_id | +-+-++-+ | 128 | VmWare | Red Hat Enterprise Linux 6(32-bit) | 204 | | 129 | VmWare | Red Hat Enterprise Linux 6(64-bit) | 205 | +-+-++-+ 2 rows in set (0.07 sec) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CLOUDSTACK-3607) guest_os_hypervisor table has values that are not registered in guest_os table
[ https://issues.apache.org/jira/browse/CLOUDSTACK-3607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14199425#comment-14199425 ] Chandan Purushothama commented on CLOUDSTACK-3607: -- I still see the table in 4.5: mysql show tables like guest_os_hypervisor; +---+ | Tables_in_cloud (guest_os_hypervisor) | +---+ | guest_os_hypervisor | +---+ 1 row in set (0.01 sec) mysql select * from version; ++-+-+--+ | id | version | updated | step | ++-+-+--+ | 1 | 4.0.0 | 2014-11-04 22:31:30 | Complete | | 2 | 4.1.0 | 2014-11-04 22:32:01 | Complete | | 3 | 4.2.0 | 2014-11-04 22:32:01 | Complete | | 4 | 4.2.1 | 2014-11-04 22:32:01 | Complete | | 5 | 4.3.0 | 2014-11-04 22:32:01 | Complete | | 6 | 4.4.0 | 2014-11-04 22:32:01 | Complete | | 7 | 4.4.1 | 2014-11-04 22:32:01 | Complete | | 8 | 4.5.0 | 2014-11-04 22:32:01 | Complete | ++-+-+--+ 8 rows in set (0.01 sec) mysql guest_os_hypervisor table has values that are not registered in guest_os table -- Key: CLOUDSTACK-3607 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3607 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: Chandan Purushothama Fix For: 4.4.0, 4.5.0 mysql select * from guest_os_hypervisor where guest_os_id not in (select id from guest_os); +-+-++-+ | id | hypervisor_type | guest_os_name | guest_os_id | +-+-++-+ | 128 | VmWare | Red Hat Enterprise Linux 6(32-bit) | 204 | | 129 | VmWare | Red Hat Enterprise Linux 6(64-bit) | 205 | +-+-++-+ 2 rows in set (0.07 sec) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CLOUDSTACK-3607) guest_os_hypervisor table has values that are not registered in guest_os table
[ https://issues.apache.org/jira/browse/CLOUDSTACK-3607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14090510#comment-14090510 ] Rohit Yadav commented on CLOUDSTACK-3607: - Chandan, can you confirm if this is still valid? guest_os_hypervisor table has values that are not registered in guest_os table -- Key: CLOUDSTACK-3607 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3607 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.4.0 mysql select * from guest_os_hypervisor where guest_os_id not in (select id from guest_os); +-+-++-+ | id | hypervisor_type | guest_os_name | guest_os_id | +-+-++-+ | 128 | VmWare | Red Hat Enterprise Linux 6(32-bit) | 204 | | 129 | VmWare | Red Hat Enterprise Linux 6(64-bit) | 205 | +-+-++-+ 2 rows in set (0.07 sec) -- This message was sent by Atlassian JIRA (v6.2#6252)