[
https://issues.apache.org/jira/browse/CLOUDSTACK-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13713355#comment-13713355
]
Koushik Das commented on CLOUDSTACK-3649:
-----------------------------------------
The HV type and version columns are not marked as unique keys in the
hypervisor_capabilities table and so the 'insert ignore' statement is not
effective.
> 3.0.6 to ASF 4.2 Upgrade: "hypervisor_capabilites" table has duplicate
> XenServer 6.1 entries and no XenServer 6.2 entry on the Upgraded Setup
> ---------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3649
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3649
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Upgrade
> Affects Versions: 4.2.0
> Reporter: Chandan Purushothama
> Assignee: Koushik Das
> Fix For: 4.2.0
>
>
> mysql> select hypervisor_type,hypervisor_version from hypervisor_capabilities
> where hypervisor_type like "Xen%";
> +-----------------+--------------------+
> | hypervisor_type | hypervisor_version |
> +-----------------+--------------------+
> | XenServer | default |
> | XenServer | XCP 1.0 |
> | XenServer | 5.6 |
> | XenServer | 5.6 FP1 |
> | XenServer | 5.6 SP2 |
> | XenServer | 6.0 |
> | XenServer | 6.0.2 |
> | XenServer | 6.1.0 |
> | XenServer | 6.1.0 |
> +-----------------+--------------------+
> 9 rows in set (0.00 sec)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
