[
https://issues.apache.org/jira/browse/CLOUDSTACK-4516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
manasaveloori closed CLOUDSTACK-4516.
-------------------------------------
Verified with latest build.Working fine.Hence closing the issue
> [Upgrade][VMWare] MySQLIntegrityConstraintViolationException while performing
> any task using local storage after upgrade from 3.0.7 to 4.2
> -------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-4516
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4516
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Upgrade, VMware
> Affects Versions: 4.2.0
> Environment: Upgraded from 3.0.7 to 4.2
> Reporter: manasaveloori
> Assignee: Min Chen
> Priority: Blocker
> Fix For: 4.2.1
>
> Attachments: management-server.zip, mysqldumpAfterUp.dmp,
> mysqldumpBeforeUp.dmp
>
>
> Steps:
> 1. Have CS with 3.0.7 build.
> 2. Configuration 2 primary storages (NFS and Local) and one NFS secondary.
> 3. Deploy some VMs using local and NFS primary. Have some
> snapshots,templates,ISO before upgrade.
> 4. Upgrade the setup to 4.2 .
> 5. Now try to deploy an instance using local storage(compute and disk
> offerings).or try to take snapshot of local storage volume.
> Observation :
> 2013-08-27 21:00:21,613 DEBUG [agent.manager.AgentAttache]
> (DirectAgent-85:null) Seq 1-462029284: No more commands found
> 2013-08-27 21:00:21,632 DEBUG [storage.image.TemplateDataFactoryImpl]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) template
> 7 is already in store:2, type:Image
> 2013-08-27 21:00:21,643 DEBUG [storage.image.TemplateDataFactoryImpl]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) template
> 7 is already in store:200, type:Primary
> 2013-08-27 21:00:21,675 DEBUG [storage.motion.AncientDataMotionStrategy]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) copyAsync
> inspecting src type TEMPLATE copyAsync inspecting dest type VOLUME
> 2013-08-27 21:00:21,688 WARN [storage.endpoint.DefaultEndPointSelector]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) can't
> find endpoint
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
> Column 'id' in where clause is ambiguous
> 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)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.findEndPointInScope(DefaultEndPointSelector.java:119)
> at
> org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.findEndpointForPrimaryStorage(DefaultEndPointSelector.java:198)
> at
> org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.select(DefaultEndPointSelector.java:241)
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.cloneVolume(AncientDataMotionStrategy.java:290)
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsync(AncientDataMotionStrategy.java:398)
> at
> org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(DataMotionServiceImpl.java:55)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromBaseImageAsync(VolumeServiceImpl.java:510)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromTemplateAsync(VolumeServiceImpl.java:547)
> at
> com.cloud.storage.VolumeManagerImpl.recreateVolume(VolumeManagerImpl.java:2526)
> at
> com.cloud.storage.VolumeManagerImpl.prepare(VolumeManagerImpl.java:2582)
> at
> com.cloud.vm.VirtualMachineManagerImpl.advanceStart(VirtualMachineManagerImpl.java:888)
> at
> com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerImpl.java:578)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VMEntityManagerImpl.deployVirtualMachine(VMEntityManagerImpl.java:227)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VirtualMachineEntityImpl.deploy(VirtualMachineEntityImpl.java:209)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:3406)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2966)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2952)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> org.apache.cloudstack.api.command.user.vm.DeployVMCmd.execute(DeployVMCmd.java:420)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158)
> at
> com.cloud.async.AsyncJobManagerImpl$1.run(AsyncJobManagerImpl.java:531)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:679)
> 2013-08-27 21:00:21,690 DEBUG [storage.motion.AncientDataMotionStrategy]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Failed to
> send to storage pool
> java.lang.NullPointerException
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.cloneVolume(AncientDataMotionStrategy.java:291)
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsync(AncientDataMotionStrategy.java:398)
> at
> org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(DataMotionServiceImpl.java:55)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromBaseImageAsync(VolumeServiceImpl.java:510)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromTemplateAsync(VolumeServiceImpl.java:547)
> at
> com.cloud.storage.VolumeManagerImpl.recreateVolume(VolumeManagerImpl.java:2526)
> at
> com.cloud.storage.VolumeManagerImpl.prepare(VolumeManagerImpl.java:2582)
> at
> com.cloud.vm.VirtualMachineManagerImpl.advanceStart(VirtualMachineManagerImpl.java:888)
> at
> com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerImpl.java:578)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VMEntityManagerImpl.deployVirtualMachine(VMEntityManagerImpl.java:227)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VirtualMachineEntityImpl.deploy(VirtualMachineEntityImpl.java:209)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:3406)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2966)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2952)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> org.apache.cloudstack.api.command.user.vm.DeployVMCmd.execute(DeployVMCmd.java:420)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158)
> at
> com.cloud.async.AsyncJobManagerImpl$1.run(AsyncJobManagerImpl.java:531)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:679)
> 2013-08-27 21:00:21,691 DEBUG [storage.motion.AncientDataMotionStrategy]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) copy
> failed
> com.cloud.utils.exception.CloudRuntimeException: Failed to send to storage
> pool
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.cloneVolume(AncientDataMotionStrategy.java:295)
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsync(AncientDataMotionStrategy.java:398)
> at
> org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(DataMotionServiceImpl.java:55)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromBaseImageAsync(VolumeServiceImpl.java:510)
> at
> org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFromTemplateAsync(VolumeServiceImpl.java:547)
> at
> com.cloud.storage.VolumeManagerImpl.recreateVolume(VolumeManagerImpl.java:2526)
> at
> com.cloud.storage.VolumeManagerImpl.prepare(VolumeManagerImpl.java:2582)
> at
> com.cloud.vm.VirtualMachineManagerImpl.advanceStart(VirtualMachineManagerImpl.java:888)
> at
> com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerImpl.java:578)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VMEntityManagerImpl.deployVirtualMachine(VMEntityManagerImpl.java:227)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VirtualMachineEntityImpl.deploy(VirtualMachineEntityImpl.java:209)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:3406)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2966)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2952)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> org.apache.cloudstack.api.command.user.vm.DeployVMCmd.execute(DeployVMCmd.java:420)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158)
> at
> com.cloud.async.AsyncJobManagerImpl$1.run(AsyncJobManagerImpl.java:531)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: java.lang.NullPointerException
> at
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.cloneVolume(AncientDataMotionStrategy.java:291)
> ... 27 more
> 2013-08-27 21:00:21,701 WARN
> [storage.datastore.ObjectInDataStoreManagerImpl] (Job-Executor-14:job-45 = [
> 80c3342c-799c-44de-9761-24b48e45fe54 ]) Unsupported data object (VOLUME,
> org.apache.cloudstack.storage.datastore.PrimaryDataStoreImpl@123682c0), no
> need to delete from object in store ref table
> 2013-08-27 21:00:21,704 DEBUG [cloud.storage.VolumeManagerImpl]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Unable to
> create Vol[19|vm=9|ROOT]:com.cloud.utils.exception.CloudRuntimeException:
> Failed to send to storage pool
> 2013-08-27 21:00:21,704 INFO [cloud.vm.VirtualMachineManagerImpl]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Unable to
> contact resource.
> com.cloud.exception.StorageUnavailableException: Resource [StoragePool:200]
> is unreachable: Unable to create
> Vol[19|vm=9|ROOT]:com.cloud.utils.exception.CloudRuntimeException: Failed to
> send to storage pool
> at
> com.cloud.storage.VolumeManagerImpl.recreateVolume(VolumeManagerImpl.java:2534)
> at
> com.cloud.storage.VolumeManagerImpl.prepare(VolumeManagerImpl.java:2582)
> at
> com.cloud.vm.VirtualMachineManagerImpl.advanceStart(VirtualMachineManagerImpl.java:888)
> at
> com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerImpl.java:578)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VMEntityManagerImpl.deployVirtualMachine(VMEntityManagerImpl.java:227)
> at
> org.apache.cloudstack.engine.cloud.entity.api.VirtualMachineEntityImpl.deploy(VirtualMachineEntityImpl.java:209)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:3406)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2966)
> at
> com.cloud.vm.UserVmManagerImpl.startVirtualMachine(UserVmManagerImpl.java:2952)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> org.apache.cloudstack.api.command.user.vm.DeployVMCmd.execute(DeployVMCmd.java:420)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158)
> at
> com.cloud.async.AsyncJobManagerImpl$1.run(AsyncJobManagerImpl.java:531)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:679)
> 2013-08-27 21:00:21,711 DEBUG [cloud.vm.VirtualMachineManagerImpl]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Cleaning
> up resources for the vm VM[User|LocAU] in Starting state
> 2013-08-27 21:00:21,714 DEBUG [agent.transport.Request]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Seq
> 1-462029285: Sending { Cmd , MgmtId: 7067804893289, via: 1, Ver: v1, Flags:
> 100111,
> [{"com.cloud.agent.api.StopCommand":{"isProxy":false,"executeInSequence":true,"vmName":"i-2-9-VM","wait":0}}]
> }
> 2013-08-27 21:00:21,714 DEBUG [agent.transport.Request]
> (Job-Executor-14:job-45 = [ 80c3342c-799c-44de-9761-24b48e45fe54 ]) Seq
> 1-462029285: Executing: { Cmd , MgmtId: 7067804893289, via: 1, Ver: v1,
> Flags: 100111,
> [{"com.cloud.agent.api.StopCommand":{"isProxy":false,"executeInSequence":true,"vmName":"i-2-9-VM","wait":0}}]
> }
> 2013-08-27 21:00:21,715 DEBUG [agent.manager.DirectAgentAttache]
> (DirectAgent-369:null) Seq 1-462029285: Executing request
> Note: Instance deployment using NFS primary is working fine.
> Attaching the MS logs and DB dumps .
>
--
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
