[
https://issues.apache.org/jira/browse/CLOUDSTACK-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13709594#comment-13709594
]
ASF subversion and git services commented on CLOUDSTACK-3293:
-------------------------------------------------------------
Commit d0955663cf0324afda52765801033f92b94bf52f in branch refs/heads/4.2 from
[~likithas]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=d095566 ]
CLOUDSTACK-3293. DeleteAccount fails with ConstraintViolation on
snapshot_store_ref.
> [Automation] DeleteAccount fails with ConstraintViolation on
> snapshot_store_ref
> -------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3293
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3293
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Storage Controller
> Affects Versions: 4.2.0
> Reporter: Prasanna Santhanam
> Assignee: Likitha Shetty
> Priority: Blocker
> Fix For: 4.2.0
>
>
> The following issue was encountered when deleting accounts:
> 2013-06-30 13:38:49,034 DEBUG [cloud.async.AsyncJobManagerImpl]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ])
> Executing org.apache.cloudstack.api.command.admin.account.DeleteAccountCmd
> for job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ]
> 2013-06-30 13:38:49,036 DEBUG [cloud.api.ApiServlet]
> (706873057@qtp-20348362-3:null) ===END=== 127.0.0.1 -- GET
> signature=oO%2FgP9Ffx%2FlE%2FYIC7tXPcFfb8Pg%3D&apiKey=oN8VZaaSyTapdOEJPP29padHk23dgCof3zxoaH9rMm4V4XUpNv2EAkSTixufmjQLr-kbdwLphVC8UQnkcfdUNw&command=queryAsyncJobResult&response=json&jobid=bb4be72e-a4a1-4d1d-9ecd-f4516807990b
> 2013-06-30 13:38:49,043 DEBUG [cloud.user.AccountManagerImpl]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ]) Removed
> account 28
> 2013-06-30 13:38:49,053 WARN [storage.snapshot.SnapshotManagerImpl]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ]) Failed
> to delete all snapshot for volume 47 on secondary storage
> nfs://10.147.28.6:/export/home/sandbox/secondary
> 2013-06-30 13:38:49,053 ERROR [storage.snapshot.SnapshotManagerImpl]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ])
> unsupported command:com.cloud.agent.api.DeleteSnapshotsDirCommand
> 2013-06-30 13:38:49,055 DEBUG [db.Transaction.Transaction]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ]) Rolling
> back the transaction: Time = 1 Name =
> -AsyncJobManagerImpl$1.run:418-Executors$RunnableAdapter.call:439-FutureTask$Sync.innerRun:303-FutureTask.run:138-ThreadPoolExecutor$Worker.runTask:895-ThreadPoolExecutor$Worker.run:918-Thread.run:680;
> called by
> -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-SnapshotManagerImpl.deleteSnapshotDirsForAccount:682-AccountManagerImpl.cleanupAccount:581-AccountManagerImpl.deleteAccount:544-AccountManagerImpl.deleteUserAccount:1255-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-RegionManagerImpl.deleteUserAccount:177-RegionServiceImpl.deleteUserAccount:118
> 2013-06-30 13:38:49,056 WARN [cloud.user.AccountManagerImpl]
> (Job-Executor-72:job-142 = [ bb4be72e-a4a1-4d1d-9ecd-f4516807990b ]) Failed
> to cleanup account Acct[28-test-5E4I97] due to
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> com.mysql.jdbc.JDBC4PreparedStatement@3632317c: DELETE FROM snapshots WHERE
> snapshots.id= 3
> at com.cloud.utils.db.GenericDaoBase.expunge(GenericDaoBase.java:1137)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.storage.snapshot.SnapshotManagerImpl.deleteSnapshotDirsForAccount(SnapshotManagerImpl.java:682)
> at
> com.cloud.user.AccountManagerImpl.cleanupAccount(AccountManagerImpl.java:581)
> at
> com.cloud.user.AccountManagerImpl.deleteAccount(AccountManagerImpl.java:544)
> at
> com.cloud.user.AccountManagerImpl.deleteUserAccount(AccountManagerImpl.java:1255)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> org.apache.cloudstack.region.RegionManagerImpl.deleteUserAccount(RegionManagerImpl.java:177)
> at
> org.apache.cloudstack.region.RegionServiceImpl.deleteUserAccount(RegionServiceImpl.java:118)
> at
> org.apache.cloudstack.api.command.admin.account.DeleteAccountCmd.execute(DeleteAccountCmd.java:100)
> at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:155)
> at
> com.cloud.async.AsyncJobManagerImpl$1.run(AsyncJobManagerImpl.java:455)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> at java.lang.Thread.run(Thread.java:680)
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
> Cannot delete or update a parent row: a foreign key constraint fails
> (`cloud`.`snapshot_store_ref`, CONSTRAINT
> `fk_snapshot_store_ref__snapshot_id` FOREIGN KEY (`snapshot_id`) REFERENCES
> `snapshots` (`id`))
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> 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)
--
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
