You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Andreas Huser <ah...@7five-edv.de> on 2013/07/12 13:53:59 UTC
Error at upgrade from 4.0.2 to 4.1
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
ahuser@7five-edv.de
Re: Error at upgrade from 4.0.2 to 4.1
Posted by Andreas Huser <ah...@7five-edv.de>.
Hi Rohit,
many thanks for your reply!
it was my error i was too hasty! After upgrade and starting the management server I not had waiting and restart the server after few minutes.
When you upgarde you must wait! and look in the management-server.log till the database upgrade 4.0to4.1 is finished. this can take some minutes.
I think it that the Web Interface are crashed and restart hasty the server.
I reset the database to the previous dump and i try it again with positive result :-)
now it works fine :-)
Regards Andreas
----- Ursprüngliche Mail -----
Von: "Rohit Yadav" <bh...@apache.org>
An: users@cloudstack.apache.org
Gesendet: Freitag, 12. Juli 2013 20:35:22
Betreff: Re: Error at upgrade from 4.0.2 to 4.1
On Fri, Jul 12, 2013 at 5:23 PM, Andreas Huser <ah...@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
> ahuser@7five-edv.de
>
>
>
>
>
Re: Error at upgrade from 4.0.2 to 4.1
Posted by Rohit Yadav <bh...@apache.org>.
On Fri, Jul 12, 2013 at 5:23 PM, Andreas Huser <ah...@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
> ahuser@7five-edv.de
>
>
>
>
>