cloudstack-issues mailing list archives

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

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Abhinandan Prateek reassigned CLOUDSTACK-3910:
----------------------------------------------

    Assignee: Bharat Kumar

The HAProxy maxconn feature exists in 3.0.7 and then in 4.2. The upgrade code needs to be
made conditional.
                
> 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
>            Assignee: Bharat Kumar
>            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