[CLOUDSTACK-3607] "guest_os_hypervisor" table has values that are not registered in "guest_os" table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0
• Fix Version/s: 4.4.0, 4.5.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Amogh Vasekar
• Reporter: Chandan Purushothama
• Created: 17/Jul/13 21:15
• Updated: 18/Nov/14 23:57
• Resolved: 18/Nov/14 23:57

Description

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)