Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-5365

Deadlock detected for oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 4.0
    • Fix Version/s: 4.0, 3.9.1
    • Component/s: Repository
    • Labels:
    • Subscription:
      Active subscription
    • Milestone:
      RELEASE

      Description

      2019-05-15 17:54:14,253 [] [pool-5-thread-2] DEBUG (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): could not execute batch [delete from m_object where oid=?]
      java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource

      at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
      at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
      at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:111)
      at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)
      at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
      at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:212)
      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:618)
      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
      at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
      at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
      at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
      at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:493)
      at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3207)
      at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2413)
      at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
      at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
      at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
      at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
      at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
      at com.evolveum.midpoint.repo.sql.helpers.ObjectUpdater.deleteObjectAttempt(ObjectUpdater.java:355)
      at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.lambda$deleteObject$11(SqlRepositoryServiceImpl.java:511)
      at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.executeAttempts(SqlRepositoryServiceImpl.java:233)
      at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.executeAttemptsNoSchemaException(SqlRepositoryServiceImpl.java:247)
      at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.deleteObject(SqlRepositoryServiceImpl.java:510)
      at com.evolveum.midpoint.repo.cache.RepositoryCache.deleteObject(RepositoryCache.java:500)
      at com.evolveum.midpoint.provisioning.impl.ShadowManager.deleteShadow(ShadowManager.java:2078)
      at com.evolveum.midpoint.provisioning.impl.ShadowCache.cleanUpDeadShadow(ShadowCache.java:1659)
      at com.evolveum.midpoint.provisioning.impl.ShadowCache.refreshShadow(ShadowCache.java:1292)
      at com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.refreshShadow(ProvisioningServiceImpl.java:927)
      at com.evolveum.midpoint.model.impl.cleanup.ShadowRefreshTaskHandler$1.handleObject(ShadowRefreshTaskHandler.java:114)
      at com.evolveum.midpoint.repo.common.task.AbstractSearchIterativeResultHandler.processRequest(AbstractSearchIterativeResultHandler.java:349)
      at com.evolveum.midpoint.repo.common.task.AbstractSearchIterativeResultHandler.access$200(AbstractSearchIterativeResultHandler.java:64)
      at com.evolveum.midpoint.repo.common.task.AbstractSearchIterativeResultHandler$WorkerHandler.run(AbstractSearchIterativeResultHandler.java:310)
      at com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl.lambda$startLightweightTask$0(TaskManagerQuartzImpl.java:1248)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at java.lang.Thread.run(Thread.java:745)
      2019-05-15 17:54:14,256 [] [pool-5-thread-2] WARN (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): SQL Error: 60, SQLState: 61000
      2019-05-15 17:54:14,256 [] [pool-5-thread-2] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): ORA-00060: deadlock detected while waiting for resource

      2019-05-15 17:54:14,256 [] [pool-5-thread-2] WARN (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): SQL Error: 60, SQLState: 61000
      2019-05-15 17:54:14,256 [] [pool-5-thread-2] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper): ORA-00060: deadlock detected while waiting for resource

       

      This is a problem of transaction not set up correctly.

        Attachments

          Activity

            People

            • Assignee:
              lazyman Viliam Repan
              Reporter:
              lazyman Viliam Repan
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: