On Fri, Jul 12, 2013 at 5:23 PM, Andreas Huser <ahu...@7five-edv.de> wrote:
> 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? > Hi Andreas, >From the log looks like the 402 to 4.1.0 sql migration script does not check whether there were existing column in the db table. Looks like this upgrade case went unnoticed and surely it's a bug. If it was a production system you were trying to upgrade (even though it says it rolled back the transaction) I think a custom sql upgrade will have to be run which is ugly in most cases. Let's hear from our database ninjas on how to fix it. Can you please open a bug with the error log and other details on Apache CloudStack's JIRA? Cheers. > 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 > ahu...@7five-edv.de > > > > >
