cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "manasaveloori (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-3910) Upgrade from 3.0.6 to 4.2 is failing with DB exceptions.
Date Mon, 29 Jul 2013 12:27:48 GMT
manasaveloori created CLOUDSTACK-3910:
-----------------------------------------

             Summary: Upgrade from 3.0.6 to 4.2 is failing with DB exceptions.
                 Key: CLOUDSTACK-3910
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3910
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Upgrade
    Affects Versions: 4.2.0
         Environment: upgrade from 3.0.6 to 4.2
            Reporter: manasaveloori
            Priority: Blocker
             Fix For: 4.2.0


Steps:
 
1.	Install 3.0.6 patch E build.
2.	Added 2 hosts with different zones(KVM and xen6.1)
3.	Added SRX,Netscaler,F5 devices to the setup.
4.	Configured the static nat using SRX,LB using Netscaler and F5.
5.	Upgarde the build to 4.2
Observing the following exceptions:

-07-29 23:02:23,185 DEBUG [upgrade.dao.VersionDaoImpl] (Timer-1:null) Checking to see if the
database is at a version before it was the version table is created
2013-07-29 23:02:23,195 INFO  [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) DB version
= 3.0.6.20130524112703 Code Version = 4.2.0-SNAPSHOT
2013-07-29 23:02:23,202 INFO  [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Database
upgrade must be performed from 3.0.6.20130524112703 to 4.2.0-SNAPSHOT
2013-07-29 23:02:23,202 DEBUG [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Running
upgrade Upgrade306to307 to upgrade from 3.0.6-3.0.7 to 3.0.7
2013-07-29 23:02:23,226 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-306to307.sql
in the classpath
2013-07-29 23:02:23,227 DEBUG [utils.script.Script] (Timer-1:null) System resource: file:/usr/share/cloudstack-management/setup/db/schema-306to307.sql
2013-07-29 23:02:23,227 DEBUG [utils.script.Script] (Timer-1:null) Absolute path =  /usr/share/cloudstack-management/setup/db/schema-306to307.sql
2013-07-29 23:02:23,231 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Licensed to the Apache
Software Foundation (ASF) under one
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- or more contributor
license agreements.  See the NOTICE file
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- distributed with this
work for additional information
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- regarding copyright
ownership.  The ASF licenses this file
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- to you under the Apache
License, Version 2.0 (the
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- "License"); you may
not use this file except in compliance
2013-07-29 23:02:23,234 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- with the License.
 You may obtain a copy of the License at
2013-07-29 23:02:23,235 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
2013-07-29 23:02:23,235 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --   http://www.apache.org/licenses/LICENSE-2.0
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Unless required by
applicable law or agreed to in writing,
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- software distributed
under the License is distributed on an
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- "AS IS" BASIS, WITHOUT
WARRANTIES OR CONDITIONS OF ANY
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- KIND, either express
or implied.  See the License for the
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- specific language
governing permissions and limitations
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- under the License.
2013-07-29 23:02:23,237 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration`
VALUES ('Network', 'DEFAULT', 'management-server', 'network.loadbalancer.haproxy.max.conn',
'4096', 'Load Balancer(haproxy) maximum number of concurrent connections(global max)')
2013-07-29 23:02:23,243 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings`
ADD COLUMN `concurrent_connections` int(10) unsigned COMMENT 'concurrent connections supported
on this network'
2013-07-29 23:02:23,245 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error executing: ALTER
TABLE `cloud`.`network_offerings` ADD COLUMN `concurrent_connections` int(10) unsigned COMMENT
'concurrent connections supported on this network'
2013-07-29 23:02:23,248 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Duplicate column name 'concurrent_connections'
2013-07-29 23:02:23,250 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable
to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-306to307.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'concurrent_connections'
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:215)
        at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:276)
        at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:405)
        at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
        at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
        at java.util.TimerThread.mainLoop(Timer.java:534)
        at java.util.TimerThread.run(Timer.java:484)
2013-07-29 23:02:23,257 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable
to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-306to307.sql
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:224)
        at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:276)
        at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:405)
        at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
        at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
        at java.util.TimerThread.mainLoop(Timer.java:534)
        at java.util.TimerThread.run(Timer.java:484)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name
'concurrent_connections'
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:215)
        ... 6 more
2013-07-29 23:02:23,262 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the
transaction: Time = 59 Name =  null; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:309-DatabaseUpgradeChecker.check:405-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:534-TimerThread.run:484
2013-07-29 23:02:23,267 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity
check failed. Refuse to startup


Note:
I have upgraded from 3.0.6 patchE to 4.2 (CloudPlatform-4.2-dbupgrade-35-rhel6.2.tar.gz )
without any rules and external devices. It went fine. I did not face any issue.

Attaching the Ms logs and db dumps.





--
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

Mime
View raw message