[
https://issues.apache.org/jira/browse/CLOUDSTACK-1839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13616863#comment-13616863
]
Sangeetha Hariharan commented on CLOUDSTACK-1839:
-------------------------------------------------
Seems like all the indexes and Keys that are missing in the fresh 4.1 install
are present in /usr/share/cloud/setup/create-index-fk.sql from a 4.0
installation.
> Upgrade 4.0 -> 4.1 - Upgraded DB has lot more keys and indexes for many
> tables compare to the fresh installed 4.1 DB.
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-1839
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1839
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Management Server
> Affects Versions: 4.1.0
> Environment: Upgrade 4.0 -> 4.1
> Reporter: Sangeetha Hariharan
> Priority: Critical
> Fix For: 4.1.0
>
> Attachments: upgrade-db-dumps.rar
>
>
> Upgrade 4.0 -> 4.1 - Upgraded DB has lot more keys and indexes for many
> tables compare to the fresh installed 4.1 DB.
> Scenario 1:
> Fresh install of 4.0.
> Upgrade the set up to 4.1.
> Scenario 2:
> Fresh install of 4.1 and started the management server.
> Comparing the schema between Scenario1 and Scenario2 shows that the Upgraded
> DB has lot more keys and indexes for many tables compare to the fresh
> installed 4.1 DB.
> Will attach database dump for both the cases.
--
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
