[ https://issues.apache.org/jira/browse/CLOUDSTACK-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Angus updated CLOUDSTACK-3910: ----------------------------------- Description: 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. was: 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. > 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 was sent by Atlassian JIRA (v6.1#6144)