cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "manasaveloori (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CLOUDSTACK-4516) [Upgrade][VMWare] MySQLIntegrityConstraintViolationException while performing any task using local storage after upgrade from 3.0.7 to 4.2
Date Thu, 29 Aug 2013 07:59:52 GMT

     [ 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

Mime
View raw message