[
https://issues.apache.org/jira/browse/CLOUDSTACK-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chip Childers resolved CLOUDSTACK-2612.
---------------------------------------
Resolution: Fixed
Fix Version/s: 4.2.0
4.1.0
pushed fix to both master and 4.1
> some typo in schema-302to40.sql
> -------------------------------
>
> Key: CLOUDSTACK-2612
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2612
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.0.2
> Environment: upgrade from CS 3.0.2 to CS 4.0.2
> Reporter: Tomasz Zieba
> Fix For: 4.1.0, 4.2.0
>
>
> Please change the following lines to make upgrade successful:
> /usr/share/cloud/setup/db/schema-302to40.sql
> 137c137
> < DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id
> FROM storage_pool WHERE removed IS NOT NULL);
> ---
> > DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id
> > FROM cloud.storage_pool WHERE removed IS NOT NULL);
> 182c182
> < DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id
> FROM storage_pool WHERE removed IS NOT NULL);
> ---
> > DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id
> > FROM cloud.storage_pool WHERE removed IS NOT NULL);
> 189c189
> < ALTER TABLE `storage_pool` ADD `user_info` VARCHAR( 255 ) NULL COMMENT
> 'Authorization information for the storage pool. Used by network filesystems'
> AFTER `host_address`;
> ---
> > ALTER TABLE `cloud`.`storage_pool` ADD `user_info` VARCHAR( 255 ) NULL
> > COMMENT 'Authorization information for the storage pool. Used by network
> > filesystems' AFTER `host_address`;
> 235c235
> < ALTER TABLE physical_network_service_providers DROP FOREIGN KEY
> fk_pnetwork_service_providers__physical_network_id;
> ---
> > ALTER TABLE `cloud`.`physical_network_service_providers` DROP FOREIGN KEY
> > fk_pnetwork_service_providers__physical_network_id;
> 237c237
> < SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ',
> A.CONSTRAINT_NAME), ' ON physical_network_service_providers' )
> ---
> > SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ',
> > A.CONSTRAINT_NAME), ' ON cloud.physical_network_service_providers' )
> 246c246
> < AlTER TABLE physical_network_service_providers ADD CONSTRAINT
> `fk_pnetwork_service_providers__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE;
> ---
> > AlTER TABLE `cloud`.`physical_network_service_providers` ADD CONSTRAINT
> > `fk_pnetwork_service_providers__physical_network_id` FOREIGN KEY
> > (`physical_network_id`) REFERENCES `cloud`.`physical_network`(`id`) ON
> > DELETE CASCADE;
> 481,482d480
> <
> <
--
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
