Tomasz Zieba created CLOUDSTACK-2612:
----------------------------------------
Summary: 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
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
