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

GitHub | boskiv | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Errors in log while installing host nodes

    GitHub | 8 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 | 1 year 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 | 1 year 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 | 9 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 | 1 year 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