org.jooq.exception.DataAccessException: SQL [update `host` set `host`.`data` = ? where `host`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction

GitHub | sangeethah | 4 months ago
  1. 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
  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

    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
  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

      Deadlock found when trying to get lock; try restarting transaction

      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
      ServiceDiscoveryServiceImpl.hostEndpointsUpdate
      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.servicediscovery.service.impl.ServiceDiscoveryServiceImpl.updateObjectEndPoints(ServiceDiscoveryServiceImpl.java:491)[cattle-iaas-service-discovery-server-0.5.0-SNAPSHOT.jar:na]
      9. io.cattle.platform.servicediscovery.service.impl.ServiceDiscoveryServiceImpl.reconcileHostEndpointsImpl(ServiceDiscoveryServiceImpl.java:508)[cattle-iaas-service-discovery-server-0.5.0-SNAPSHOT.jar:na]
      10. io.cattle.platform.servicediscovery.service.impl.ServiceDiscoveryServiceImpl$7.run(ServiceDiscoveryServiceImpl.java:781)[cattle-iaas-service-discovery-server-0.5.0-SNAPSHOT.jar:na]
      11. io.cattle.platform.servicediscovery.service.impl.ServiceDiscoveryServiceImpl.reconcileForHost(ServiceDiscoveryServiceImpl.java:792)[cattle-iaas-service-discovery-server-0.5.0-SNAPSHOT.jar:na]
      12. io.cattle.platform.servicediscovery.service.impl.ServiceDiscoveryServiceImpl.hostEndpointsUpdate(ServiceDiscoveryServiceImpl.java:776)[cattle-iaas-service-discovery-server-0.5.0-SNAPSHOT.jar:na]
      12 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1284.invoke(Unknown Source)[na:na]
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_101]
      3. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_101]
      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_101]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_101]
      3. java.lang.Thread.run(Thread.java:745)[na:1.7.0_101]
      3 frames