Hi at all,
I have an database issue with upgrade Cloudstack from 4.0.2 to 4.1.
The management Server running on rhel-6.4
can someone help me?
many thanks from germany
Regards Andreas
2013-07-12 13:43:18,355 DEBUG [utils.db.ScriptRunner] (Timer-1:null) use cloud
2013-07-12 13:43:18,356 DEBUG [utils.db.ScriptRunner] (Timer-1:null) SET
foreign_key_checks = 0
2013-07-12 13:43:18,356 DEBUG [utils.db.ScriptRunner] (Timer-1:null) alter
table vm_template add size bigint unsigned
2013-07-12 13:43:18,359 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error
executing: alter table vm_template add size bigint unsigned
2013-07-12 13:43:18,360 ERROR [utils.db.ScriptRunner] (Timer-1:null)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
name 'size'
2013-07-12 13:43:18,365 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Unable to execute upgrade script:
/usr/share/cloudstack-management/setup/db/schema-40to410.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
name 'size'
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:173)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:233)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:358)
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-12 13:43:18,371 DEBUG [db.Transaction.Transaction] (Timer-1:null)
Rolling back the transaction: Time = 39 Name = Upgrade; called by
-Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:263-DatabaseUpgradeChecker.check:358-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:534-TimerThread.run:484
Mit freundlichen Grüßen
Andreas Huser
Geschäftsführer
System Engineer / Consultant
(Cisco Certified Solaris, Linux)
---------------------------------------
Zellerstraße 28 - 77654 Offenburg
Tel: +49(781) 1278689 0
Mobil: +49(176) 10308549
[email protected]
