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

Marcus Sorensen commented on CLOUDSTACK-1310:
---------------------------------------------

Thanks. I'm not familiar with the citric internal builds, but I'll assume its 
recent. I need a bit more information than that, because set up of advanced 
zone works for me. This "duplicate physical network" makes it sound like the 
database is already populated. Was table cloud dropped and 
cloudstack-setup-databases run prior to setting up zone? Or are you creating a 
second zone in a system where one already exists?
                
> ASF-build-master-nonoss-rhel63 - create advance zone FAIL - 
> CreatePhysicalNetworkCmd FAIL - MySQLIntegrityConstraintViolationException: 
> Duplicate entry '200-Public' for key 'physical_network_id'
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-1310
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1310
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the 
> default.) 
>          Components: Management Server
>    Affects Versions: 4.1.0
>         Environment: MS    rhel6.3      ASF-build-master-nonoss-rhel63   
> build  68  CloudStack-non-OSS-68-rhel6.3.tar.gz
> host  kvm  6.3   ASF-build-master-nonoss-rhel63   build  68  
> CloudStack-non-OSS-68-rhel6.3.tar.gz
> qemu-img-0.12.1.2-3.295.el6.10.x86_64
> qemu-guest-agent-0.12.1.2-2.295.el6.x86_64
> qemu-kvm-0.12.1.2-3.295.el6.10.x86_64
> qemu-kvm-tools-0.12.1.2-2.295.el6.x86_64
> Create advance zone FAIL - CreatePhysicalNetworkCmd FAIL 
> Caused by: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Duplicate entry '200-Public' for key 'physical_network_id'
>            Reporter: angeline shen
>            Assignee: angeline shen
>            Priority: Blocker
>             Fix For: 4.1.0
>
>         Attachments: cloud-backup.dmp, cloud-backup.sql, 
> management-server.log.gz
>
>
> MS    rhel6.3      ASF-build-master-nonoss-rhel63   build  68  
> CloudStack-non-OSS-68-rhel6.3.tar.gz
> host  kvm  6.3   ASF-build-master-nonoss-rhel63   build  68  
> CloudStack-non-OSS-68-rhel6.3.tar.gz
> qemu-img-0.12.1.2-3.295.el6.10.x86_64
> qemu-guest-agent-0.12.1.2-2.295.el6.x86_64
> qemu-kvm-0.12.1.2-3.295.el6.10.x86_64
> qemu-kvm-tools-0.12.1.2-2.295.el6.x86_64
> 2013-02-17 19:14:45,090 DEBUG [db.Transaction.Transaction] 
> (catalina-exec-24:null) Rolling back the transaction: Time = 114 Name =  
> addTrafficTypeToPhysicalNetwork; called by -Transaction.rollback:890-Tra
> nsaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.AroundAnyMethod:39-GeneratedMethodAccessor35.invoke:-1-DelegatingMethodAccessorImpl.invoke:43-Method.invoke:616-AbstractAspectJAdvic
> e.invokeAdviceMethodWithGivenArgs:621-AbstractAspectJAdvice.invokeAdviceMethod:610-AspectJAroundAdvice.invoke:65-ReflectiveMethodInvocation.proceed:172-ExposeInvocationInterceptor.invoke:90
> 2013-02-17 19:14:45,092 WARN  [cloud.network.NetworkServiceImpl] 
> (catalina-exec-21:null) Exception: 
> javax.persistence.EntityExistsException: Entity already exists: 
>         at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1337)
>         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:37)
>         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:616)
>         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.network.NetworkServiceImpl.addTrafficTypeToPhysicalNetwork(NetworkServiceImpl.java:2610)
>         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.event.ActionEventInterceptor.AroundAnyMethod(ActionEventInterceptor.java:41)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:616)
>         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:161)
>         at 
> org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
>         at 
> com.cloud.utils.db.TransactionContextBuilder.AroundAnyMethod(TransactionContextBuilder.java:37)
>         at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:616)
>         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 
> org.apache.cloudstack.api.command.admin.usage.AddTrafficTypeCmd.create(AddTrafficTypeCmd.java:132)
>         at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
>         at 
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> :
> .......
> Caused by: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Duplicate entry '200-Public' for key 'physical_network_id'
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
> Method)
>         at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>         at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
>         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>         at com.mysql.jdbc.Util.getInstance(Util.java:386)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
> ...............
> Caused by: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Duplicate entry '200-Management' for key 'physical_network_id'

--
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

Reply via email to