cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wei Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-3898) Upgrade failed from 3.0.3 to 4.2 htitting db exception
Date Mon, 29 Jul 2013 18:41:55 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13722810#comment-13722810
] 

Wei Zhou commented on CLOUDSTACK-3898:
--------------------------------------

Alena,

I was wondering is there another way to fix this issue as your patch may set the existing
virtual_size value in CCP 3.0.7 to default value (null?) in the upgrade (I am not sure). 

-Wei
                
> Upgrade failed from 3.0.3 to 4.2 htitting db exception
> ------------------------------------------------------
>
>                 Key: CLOUDSTACK-3898
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3898
>             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 performed from 3.0.3  to 4.2
>            Reporter: shweta agarwal
>            Assignee: Alena Prokharchyk
>            Priority: Blocker
>             Fix For: 4.2.0
>
>         Attachments: cloudafterupgrade_backup.dmp, cloud_backup.dmp, cloud_usageafterupgrade_backup.dmp,
cloud_usage_backup.dmp, management-server.log, management-server.log, mysqldump1.dmp, mysqldumpafterUpgrade.dmp
>
>
> Install 3.0.3 setup
> upgrade to 4.2 
> start management server
> Hitting DB exception :
> 2013-07-29 15:22:37,330 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`usage_event`
ADD COLUMN `virtual_size` bigint unsigned
> 2013-07-29 15:22:37,355 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error executing:
ALTER TABLE `cloud`.`usage_event` ADD COLUMN `virtual_size` bigint unsigned
> 2013-07-29 15:22:37,355 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Duplicate column name 'virtual_size'
> 2013-07-29 15:22:37,357 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable
to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'virtual_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: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 15:22:37,359 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-410to420.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 'virtual_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:215)
>         ... 6 more
> 2013-07-29 15:22:37,364 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back
the transaction: Time = 6161 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 15:22:37,366 ERROR [utils.component.ComponentContext] (Timer-1:null) System
integrity check failed. Refuse to startup

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message