[ https://issues.apache.org/jira/browse/CLOUDSTACK-4516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
manasaveloori updated CLOUDSTACK-4516: -------------------------------------- Attachment: management-server.zip mysqldumpBeforeUp.dmp mysqldumpAfterUp.dmp > [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 > 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