Ignore my last comment - I now see the -- prefx!
Regards Alex Hitchins D: +44 1892 523 587 | S: +44 2036 030 540<tel:+442036030540> | M: +44<tel:+447968161581> 7788 423 969 alex.hitch...@shapeblue.com<mailto:alex.hitch...@shapeblue.com> From: Geoff Higginbottom [mailto:geoff.higginbot...@shapeblue.com] Sent: 26 March 2014 15:10 To: dev@cloudstack.apache.org Subject: Upgrade problems 3.0.7 - 4.2.1 Hi, I am trying to upgrade a CloudPlatfom 3.0.7 build to Apache CloudStack 4.2.1 The DB upgrade keeps failing with the logs highlighting a 'system integrity check failure' Any help would be greatly appreciated 2014-03-26 14:53:31,883 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- http://www.apache.org/licenses/LICENSE-2.0 2014-03-26 14:53:31,883 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- 2014-03-26 14:53:31,883 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- Unless required by applicable law or agreed to in writing, 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- software distributed under the License is distributed on an 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- KIND, either express or implied. See the License for the 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- specific language governing permissions and limitations 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- under the License. 2014-03-26 14:53:31,884 DEBUG [utils.db.ScriptRunner] (Timer-2: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)') 2014-03-26 14:53:31,885 DEBUG [utils.db.ScriptRunner] (Timer-2:null) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `concurrent_connections` int(10) unsigned COMMENT 'concurrent connections supported on this network' 2014-03-26 14:53:31,912 DEBUG [db.Transaction.Transaction] (Timer-2:null) Rolling back the transaction: Time = 36 Name = -CloudStartupServlet$1.run:52-TimerThread.mainLoop:534-TimerThread.run:484; called by -Transaction.rollback:897-Transaction.removeUpTo:840-Transaction.close:664-DatabaseUpgradeChecker.upgrade:298-DatabaseUpgradeChecker.check:394-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:54-TimerThread.mainLoop:534-TimerThread.run:484 2014-03-26 14:53:31,916 ERROR [utils.component.ComponentContext] (Timer-2:null) System integrity check failed. Refuse to startup javax.persistence.EntityExistsException: Entity already exists: at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1346) at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:290) at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:394) at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90) at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54) at java.util.TimerThread.mainLoop(Timer.java:534) at java.util.TimerThread.run(Timer.java:484) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '3.0.7' for key 'version' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:534) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1311) ... 6 more Regards Geoff Higginbottom CTO / Cloud Architect [Description: Mail Logo Bottom Align] D: +44 20 3603 0542<tel:+442036030542> | S: +44 20 3603 0540<tel:+442036030540> | M: +447968161581<tel:+447968161581> geoff.higginbot...@shapeblue.com<mailto:geoff.higginbot...@shapeblue.com> | www.shapeblue.com<htp://www.shapeblue.com/> | Twitter:@cloudstackguru<https://twitter.com/#!/cloudstacguru> ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS Need Enterprise Grade Support for Apache CloudStack? Our CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/> offers the best 24/7 SLA for CloudStack Environments. Apache CloudStack Bootcamp training courses **NEW!** CloudStack 4.2.1 training<http://shapeblue.com/cloudstack-training/> 18th-19th February 2014, Brazil. Classroom<http://shapeblue.com/cloudstack-training/> 17th-23rd March 2014, Region A. Instructor led, On-line<http://shapeblue.com/cloudstack-training/> 24th-28th March 2014, Region B. Instructor led, On-line<http://shapeblue.com/cloudstack-training/> 16th-20th June 2014, Region A. Instructor led, On-line<http://shapeblue.com/cloudstack-training/> 23rd-27th June 2014, Region B. Instructor led, On-line<http://shapeblue.com/cloudstack-training/> This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark. This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
