CLOUDSTACK-2318: update volumes.path to fix stop/start vm error after upgrade from 2.2.14 to 3.0.0
Signed-off-by: Chip Childers <chip.child...@gmail.com> Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/99d09363 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/99d09363 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/99d09363 Branch: refs/heads/planner_reserve Commit: 99d0936314571e645f62e40bf4d227232be89632 Parents: 44f3f5e Author: Wei Zhou <w.z...@leaseweb.com> Authored: Wed May 8 17:44:46 2013 +0100 Committer: Chip Childers <chip.child...@gmail.com> Committed: Wed May 8 17:45:56 2013 +0100 ---------------------------------------------------------------------- setup/db/db/schema-2214to30.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/99d09363/setup/db/db/schema-2214to30.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-2214to30.sql b/setup/db/db/schema-2214to30.sql index 60eceea..e288b0f 100755 --- a/setup/db/db/schema-2214to30.sql +++ b/setup/db/db/schema-2214to30.sql @@ -664,6 +664,7 @@ ALTER TABLE `cloud`.`dc_storage_network_ip_range` ADD COLUMN `gateway` varchar(1 ALTER TABLE `cloud`.`volumes` ADD COLUMN `last_pool_id` bigint unsigned; UPDATE `cloud`.`volumes` SET `last_pool_id` = `pool_id`; +UPDATE `cloud`.`volumes` SET `path` = SUBSTRING_INDEX(`path`, '/', -1); ALTER TABLE `cloud`.`user_ip_address` ADD COLUMN `is_system` int(1) unsigned NOT NULL default '0'; ALTER TABLE `cloud`.`volumes` ADD COLUMN `update_count` bigint unsigned NOT NULL DEFAULT 0;
