Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 271BCF186 for ; Tue, 26 Mar 2013 17:35:15 +0000 (UTC) Received: (qmail 50232 invoked by uid 500); 26 Mar 2013 17:35:15 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 50204 invoked by uid 500); 26 Mar 2013 17:35:15 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cloudstack-dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 50192 invoked by uid 500); 26 Mar 2013 17:35:15 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 50188 invoked by uid 99); 26 Mar 2013 17:35:14 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Mar 2013 17:35:14 +0000 Date: Tue, 26 Mar 2013 17:35:14 +0000 (UTC) From: "Prachi Damle (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-1804) Upgrade 4.0 -> 4.1 - DB upgrade fails. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-1804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13614335#comment-13614335 ] Prachi Damle commented on CLOUDSTACK-1804: ------------------------------------------ Yes. Jayapal your code upgradeEIPNetworkOfferings, is not logging the error - it is just thrown out. Please log the error. > 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: Jayapal Reddy > Priority: Blocker > Fix For: 4.1.0 > > Attachments: Upgrade-4.0-4.1.rar > > > 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