org.jooq.exception.DataAccessException: SQL [update `agent` set `agent`.`state` = ? where `agent`.`id` = ?]; Query execution was interrupted

GitHub | boskiv | 2 months ago
  1. 0

    Errors in log while installing host nodes

    GitHub | 2 months ago | boskiv
    org.jooq.exception.DataAccessException: SQL [update `agent` set `agent`.`state` = ? where `agent`.`id` = ?]; Query execution was interrupted
  2. 0

    "Deadlock found when trying to get lock; try restarting transaction" seen in logs.

    GitHub | 8 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `host` set `host`.`data` = ? where `host`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction
  3. 0

    Deadlock found when trying to get lock; try restarting transaction errors found when trying to update hosts.

    GitHub | 8 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `host` set `host`.`data` = ? where `host`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Deadlock exception seen in logs when host is updated.

    GitHub | 4 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `host` set `host`.`data` = ? where `host`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction
  6. 0

    Exceceptions seen when instances are started.

    GitHub | 9 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `config_item_status` set `config_item_status`.`requested_version` = (`config_item_status`.`requested_version` + ?), `config_item_status`.`requested_updated` = ? where (`config_item_status`.`name` = ? and `config_item_status`.`resource_type` = ? and `config_item_status`.`resource_id` = ?)]; Deadlock found when trying to get lock; try restarting transaction

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.mariadb.jdbc.internal.util.dao.QueryException

      Query execution was interrupted

      at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult()
    2. org.mariadb.jdbc
      AbstractQueryProtocol.executePreparedQuery
      1. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:475)[mariadb-java-client-1.3.4.jar:na]
      2. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)[mariadb-java-client-1.3.4.jar:na]
      2 frames
    3. mariadb-java-client
      MariaDbServerPreparedStatement.execute
      1. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:281)[mariadb-java-client-1.3.4.jar:na]
      2. org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:371)[mariadb-java-client-1.3.4.jar:na]
      2 frames
    4. Commons DBCP
      DelegatingPreparedStatement.execute
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)[commons-dbcp-1.4.jar:1.4]
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)[commons-dbcp-1.4.jar:1.4]
      2 frames
    5. jOOQ
      UpdatableRecordImpl.update
      1. org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)[jooq-3.3.0.jar:na]
      2. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:376)[jooq-3.3.0.jar:na]
      3. org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:289)[jooq-3.3.0.jar:na]
      4. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:322)[jooq-3.3.0.jar:na]
      5. org.jooq.impl.UpdatableRecordImpl.storeUpdate0(UpdatableRecordImpl.java:296)[jooq-3.3.0.jar:na]
      6. org.jooq.impl.UpdatableRecordImpl.access$200(UpdatableRecordImpl.java:90)[jooq-3.3.0.jar:na]
      7. org.jooq.impl.UpdatableRecordImpl$3.operate(UpdatableRecordImpl.java:260)[jooq-3.3.0.jar:na]
      8. org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:123)[jooq-3.3.0.jar:na]
      9. org.jooq.impl.UpdatableRecordImpl.storeUpdate(UpdatableRecordImpl.java:255)[jooq-3.3.0.jar:na]
      10. org.jooq.impl.UpdatableRecordImpl.update(UpdatableRecordImpl.java:149)[jooq-3.3.0.jar:na]
      10 frames
    6. io.cattle.platform
      ProcessEventListenerImpl.processExecute
      1. io.cattle.platform.object.impl.JooqObjectManager.persistRecord(JooqObjectManager.java:223)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      2. io.cattle.platform.object.impl.JooqObjectManager.setFieldsInternal(JooqObjectManager.java:130)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      3. io.cattle.platform.object.impl.JooqObjectManager$3.execute(JooqObjectManager.java:118)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      4. io.cattle.platform.engine.idempotent.Idempotent.change(Idempotent.java:88)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      5. io.cattle.platform.object.impl.JooqObjectManager.setFields(JooqObjectManager.java:115)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      6. io.cattle.platform.object.impl.JooqObjectManager.setFields(JooqObjectManager.java:110)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      7. io.cattle.platform.object.impl.AbstractObjectManager.setFields(AbstractObjectManager.java:135)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na]
      8. io.cattle.platform.process.common.generic.GenericResourceProcessState.setState(GenericResourceProcessState.java:85)[cattle-iaas-logic-common-0.5.0-SNAPSHOT.jar:na]
      9. io.cattle.platform.engine.process.impl.AbstractStatesBasedProcessState.setDone(AbstractStatesBasedProcessState.java:41)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      10. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.setDone(DefaultProcessInstanceImpl.java:561)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      11. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.runWithProcessLock(DefaultProcessInstanceImpl.java:307)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      12. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$2.doWithLockNoResult(DefaultProcessInstanceImpl.java:245)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      13. io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:7)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      14. io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:3)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      15. io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      16. io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      17. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      18. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      19. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.acquireLockAndRun(DefaultProcessInstanceImpl.java:242)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      20. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.runDelegateLoop(DefaultProcessInstanceImpl.java:184)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      21. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.executeWithProcessInstanceLock(DefaultProcessInstanceImpl.java:157)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      22. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$1.doWithLock(DefaultProcessInstanceImpl.java:107)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      23. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$1.doWithLock(DefaultProcessInstanceImpl.java:104)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      24. io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      25. io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      26. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      27. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      28. io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.execute(DefaultProcessInstanceImpl.java:104)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      29. io.cattle.platform.engine.eventing.impl.ProcessEventListenerImpl.processExecute(ProcessEventListenerImpl.java:74)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      30. io.cattle.platform.engine.eventing.impl.ProcessEventListenerImpl.processExecute(ProcessEventListenerImpl.java:56)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na]
      30 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor581.invoke(Unknown Source)[na:na]
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_111]
      3. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_111]
      3 frames
    8. io.cattle.platform
      AbstractThreadPoolingEventService$2.doRun
      1. io.cattle.platform.eventing.annotation.MethodInvokingListener$1.doWithLockNoResult(MethodInvokingListener.java:76)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na]
      2. io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:7)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      3. io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:3)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      4. io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      5. io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      6. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      7. io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na]
      8. io.cattle.platform.eventing.annotation.MethodInvokingListener.onEvent(MethodInvokingListener.java:72)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na]
      9. io.cattle.platform.eventing.impl.AbstractThreadPoolingEventService$2.doRun(AbstractThreadPoolingEventService.java:135)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na]
      9 frames
    9. org.apache.cloudstack
      ManagedContextRunnable.run
      1. org.apache.cloudstack.managed.context.NoExceptionRunnable.runInContext(NoExceptionRunnable.java:15)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      2. org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      3. org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      4. org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:108)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      5. org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      6. org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na]
      6 frames
    10. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_111]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_111]
      3. java.lang.Thread.run(Thread.java:745)[na:1.7.0_111]
      3 frames