Sangeetha Hariharan created CLOUDSTACK-1804:
-----------------------------------------------
Summary: Upgrade 4.0 -> 4.1 - DB upgrade fails.
Key: CLOUDSTACK-1804
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1804
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 from 4.0 - > 4.1
Reporter: Sangeetha Hariharan
Assignee: Prachi Damle
Fix For: 4.1.0
1. Install and configure 4.0 setup
2. Create 4.1 repo and update the packages to 4.1
3. Tried to start Management server.
Management server fails to start.
To proceed further , I had to do the following steps manually:
Issue1 : Failed to start management server as there is no tomcat6.conf file
Resolved: Created a copy of tomcat6-nonssl.conf to tomcat6.conf
Issue2 : Failed to start MS as there is no server.xml
Resolved: Created a copy of server-nonssl.xml to server.xml
Issue3: Failed to start MS as connection to DB failed.
Resolved this issue by copying the original db.properties (which used to be in
/etc/cloud/management/db.properties .It is removed as part of upgrade) to
/etc/cloudstack/management/db.properties.
After this we see the management server starts.
But we see the version in DB is still at 4.0.
Also we are able to log in to the management server as admin user but we are
not presented with the dashboard view and user is presented with the following
error message - "The given command does not exist or it is not available for
user"
013-03-25 13:40:13,470 INFO [cloud.api.ApiServer] (catalina-exec-19:null)
(userId=2 accountId=2 sessionId=477A36D68C43BF607B120C101BAC9394) 10.216.132.72
-- POST command=login domain=/
2013-03-25 13:40:13,530 INFO [cloud.api.ApiServer] (catalina-exec-18:null)
10.216.132.72 -- GET
command=listCapabilities&response=json&sessionkey=j1yRhgpqVLP55aACJc1tnMvsgoo%3D&_=1364244047351
432 The given command does not exist or it is not available for user
2013-03-25 13:40:13,552 INFO [cloud.api.ApiServer] (catalina-exec-5:null)
10.216.132.72 -- GET
command=listSwifts&response=json&sessionkey=j1yRhgpqVLP55aACJc1tnMvsgoo%3D&_=1364244047413
432 The given command does not exist or it is not available for user
mysql> select * from version;
+----+----------------------+---------------------+----------+
| id | version | updated | step |
+----+----------------------+---------------------+----------+
| 1 | 4.0.0.20130314045651 | 2013-03-25 10:54:37 | Complete |
+----+----------------------+---------------------+----------+
1 row in set (0.00 sec)
>From management server , we see upgrade scripts being executed , but there is
>a rollback that happens during the upgrade process that indicates a failure in
>upgrade procedure. No sql exceptions seen during the upgrade steps.
2013-03-25 13:26:03,427 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Schema
upgrade from 4.0.0 to 4.1.0;
2013-03-25 13:26:03,427 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-03-25 13:26:03,427 DEBUG [utils.db.ScriptRunner] (Timer-1:null) use cloud
2013-03-25 13:26:03,429 DEBUG [utils.db.ScriptRunner] (Timer-1:null) SET
foreign_key_checks = 0
2013-03-25 13:26:03,430 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_template add size bigint unsigned
2013-03-25 13:26:03,602 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_template add state varchar(255)
2013-03-25 13:26:03,638 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_template add update_count bigint unsigned
2013-03-25 13:26:03,659 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_template add updated datetime
2013-03-25 13:26:03,673 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table storage_pool add storage_provider_id bigint unsigned
2013-03-25 13:26:03,728 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table storage_pool add scope varchar(255)
2013-03-25 13:26:03,755 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
2013-03-25 13:26:03,766 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table template_spool_ref add state varchar(255)
2013-03-25 13:26:03,778 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table template_spool_ref add update_count bigint unsigned
2013-03-25 13:26:03,788 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table volumes add disk_type varchar(255)
2013-03-25 13:26:03,824 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table volumes drop foreign key `fk_volumes__account_id`
2013-03-25 13:26:03,858 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column disk_offering_id bigint unsigned
2013-03-25 13:26:03,920 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column cpu int(10) unsigned
2013-03-25 13:26:03,942 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column ram bigint unsigned
2013-03-25 13:26:03,955 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column owner varchar(255)
2013-03-25 13:26:03,968 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column speed int(10) unsigned
2013-03-25 13:26:03,980 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column host_name varchar(255)
2013-03-25 13:26:03,997 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column display_name varchar(255)
2013-03-25 13:26:04,031 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_instance add column `desired_state` varchar(32) NULL
2013-03-25 13:26:04,047 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table data_center add column owner varchar(255)
2013-03-25 13:26:04,424 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table data_center add column created datetime COMMENT 'date created'
2013-03-25 13:26:04,438 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table data_center add column lastUpdated datetime COMMENT 'last updated'
2013-03-25 13:26:04,448 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table data_center add column engine_state varchar(32) NOT NULL DEFAULT
'Disabled' CO
MMENT 'the engine state of the zone'
2013-03-25 13:26:04,459 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host_pod_ref add column owner varchar(255)
2013-03-25 13:26:04,526 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host_pod_ref add column created datetime COMMENT 'date created'
2013-03-25 13:26:04,536 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host_pod_ref add column lastUpdated datetime COMMENT 'last updated'
2013-03-25 13:26:04,548 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host_pod_ref add column engine_state varchar(32) NOT NULL DEFAULT
'Disabled' C
OMMENT 'the engine state of the zone'
2013-03-25 13:26:04,562 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host add column owner varchar(255)
2013-03-25 13:26:04,587 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host add column lastUpdated datetime COMMENT 'last updated'
2013-03-25 13:26:04,600 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled'
COMMENT '
the engine state of the zone'
2013-03-25 13:26:04,612 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table cluster add column owner varchar(255)
2013-03-25 13:26:04,665 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table cluster add column created datetime COMMENT 'date created'
2013-03-25 13:26:04,676 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table cluster add column lastUpdated datetime COMMENT 'last updated'
2013-03-25 13:26:04,688 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled'
COMMEN
T 'the engine state of the zone'
2013-03-25 13:26:04,701 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE
TABLE `cloud`.`vm_compute_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT
CO
MMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `compute_tag`
varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoD
B DEFAULT CHARSET=utf8
2013-03-25 13:26:04,715 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE
TABLE `cloud`.`vm_root_disk_tags` ( `id` bigint unsigned NOT NULL
AUTO_INCREMENT
COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `root_disk_tag`
varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=I
nnoDB DEFAULT CHARSET=utf8
2013-03-25 13:26:04,719 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE
TABLE `cloud`.`vm_network_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT
COM
MENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `network_id`
bigint unsigned NOT NULL COMMENT 'network id', PRIMARY KEY(`id`) ) ENGINE=InnoD
B DEFAULT CHARSET=utf8
................
................
2013-03-25 13:26:06,022 DEBUG [utils.db.ScriptRunner] (Timer-1:null) SET
foreign_key_checks = 1
2013-03-25 13:26:06,022 DEBUG [upgrade.dao.Upgrade40to41] (Timer-1:null)
Updating region table with Id: 1
2013-03-25 13:26:06,033 DEBUG [db.Transaction.Transaction] (Timer-1:null)
Rolling back the transaction: Time = 2630 Name = Upgrade; called by
-Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:263-DatabaseUpgradeChecker.check:358-NativeMethodAccessorImpl.invoke0:-2-NativeMethodAccessorImpl.invoke:57-DelegatingMethodAccessorImpl.invoke:43-Method.invoke:616-AopUtils.invokeJoinpointUsingReflection:319-ReflectiveMethodInvocation.invokeJoinpoint:183-ReflectiveMethodInvocation.proceed:150
2013-03-25 13:26:13,390 INFO [utils.component.ComponentContext] (main:null)
Configuring com.cloud.bridge.persist.dao.CloudStackAccountDaoImpl
2013-03-25 13:26:13,402 INFO [utils.db.GenericDaoBase] (main:null) Register dao
interface in GenericDaoBase entity-DAO map.
com.cloud.bridge.persist.dao.CloudStackAccountDao
--
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
