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