[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-3607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)

Reply via email to