[
https://issues.apache.org/jira/browse/CLOUDSTACK-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13583255#comment-13583255
]
Rohit Yadav commented on CLOUDSTACK-1355:
-----------------------------------------
Thanks for reporting Gavin, will look into that tomorrow morning if I survive :)
> Exception when DB upgrade from 4.0.0 to 4.2.0-SNAPSHOT
> -------------------------------------------------------
>
> Key: CLOUDSTACK-1355
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1355
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Install and Setup
> Affects Versions: 4.2.0
> Environment: osx 10.8.2
> apache-maven-3.0.4
> Reporter: gavin lee
> Assignee: Rohit Yadav
> Labels: db, upgrade
> Fix For: 4.2.0
>
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> Build for DevCloud on master, after pull latest code, run jetty will raise
> below Exception:
> bash$ mvn -pl client jetty:run
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) Grabbing lock to check
> for database upgrade.
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) DB version = 4.0.0 Code
> Version = 4.2.0-SNAPSHOT
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) Database upgrade must be
> performed from 4.0.0 to 4.2.0-SNAPSHOT
> ERROR [utils.db.ScriptRunner] (main:) Error executing: alter table
> storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
> ERROR [utils.db.ScriptRunner] (main:) java.sql.SQLException: Cannot change
> column 'id': used in a foreign key constraint
> 'fk_storage_pool_details__pool_id' of table 'cloud.storage_pool_details'
> ERROR [cloud.upgrade.DatabaseUpgradeChecker] (main:) Unable to execute
> upgrade script:
> /Users/gavin_lee/projects/cs-apache/incubator-cloudstack/client/target/utilities/scripts/db/db/schema-40to410.sql
> java.sql.SQLException: Cannot change column 'id': used in a foreign key
> constraint 'fk_storage_pool_details__pool_id' of table
> 'cloud.storage_pool_details'
> 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:172)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:232)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:357)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at
> org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
> at
> com.cloud.utils.db.TransactionContextBuilder.AroundAnyMethod(TransactionContextBuilder.java:43)
> at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
> at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
> at
> org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> at
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:72)
> When apply following work around:
> SET foreign_key_checks = 0;
> on top of setup/db/db/schema-40to410.sql
> and
> SET foreign_key_checks = 1;
> at bottom of setup/db/db/schema-40to410.sql
> Another exception will raise:
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) Grabbing lock to check
> for database upgrade.
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) DB version = 4.0.0 Code
> Version = 4.2.0-SNAPSHOT
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (main:) Database upgrade must be
> performed from 4.0.0 to 4.2.0-SNAPSHOT
> ERROR [utils.db.ScriptRunner] (main:) Error executing: alter table
> vm_template add image_data_store_id bigint unsigned
> ERROR [utils.db.ScriptRunner] (main:)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
> name 'image_data_store_id'
> ERROR [cloud.upgrade.DatabaseUpgradeChecker] (main:) Unable to execute
> upgrade script:
> /Users/gavin_lee/projects/cs-apache/incubator-cloudstack/client/target/utilities/scripts/db/db/schema-40to410.sql
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column
> name 'image_data_store_id'
> 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:172)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:232)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:357)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> at
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at
> org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
> at
> com.cloud.utils.db.TransactionContextBuilder.AroundAnyMethod(TransactionContextBuilder.java:43)
> at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
> at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
> at
> org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
--
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
