org.jooq.exception.DataAccessException

SQL [update `agent` set `agent`.`state` = ? where `agent`.`id` = ?]; Query execution was interrupted

Samebug tips1

It was a database inconsistency issue in the integration test dataset.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web174

  • SQL [update `agent` set `agent`.`state` = ? where `agent`.`id` = ?]; Query execution was interrupted
  • SQL [select `agent`.`id`, `agent`.`name`, `agent`.`account_id`, `agent`.`kind`, `agent`.`uuid`, `agent`.`description`, `agent`.`st ate`, `agent`.`created`, `agent`.`removed`, `agent`.`remove_time`, `agent`.`data`, `agent`.`uri`, `agent`.`managed_config`, `agent`.`agent_group_id`, `agent`.`zone_id` from `agent` where `agent`.`id` = ?]; Could not connect: Too many connections
  • SQL [update `environment` set `environment`.`state` = ? where `environment`.`id` = ?]; Lock wait timeout exceeded; try restarting transaction
  • Stack trace

    • org.jooq.exception.DataAccessException: SQL [update `agent` set `agent`.`state` = ? where `agent`.`id` = ?]; Query execution was interrupted at org.jooq.impl.Utils.translate(Utils.java:1287)[jooq-3.3.0.jar:na] at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:495)[jooq-3.3.0.jar:na] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:326)[jooq-3.3.0.jar:na] at org.jooq.impl.UpdatableRecordImpl.storeUpdate0(UpdatableRecordImpl.java:296)[jooq-3.3.0.jar:na] at org.jooq.impl.UpdatableRecordImpl.access$200(UpdatableRecordImpl.java:90)[jooq-3.3.0.jar:na] at org.jooq.impl.UpdatableRecordImpl$3.operate(UpdatableRecordImpl.java:260)[jooq-3.3.0.jar:na] at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:123)[jooq-3.3.0.jar:na] at org.jooq.impl.UpdatableRecordImpl.storeUpdate(UpdatableRecordImpl.java:255)[jooq-3.3.0.jar:na] at org.jooq.impl.UpdatableRecordImpl.update(UpdatableRecordImpl.java:149)[jooq-3.3.0.jar:na] at io.cattle.platform.object.impl.JooqObjectManager.persistRecord(JooqObjectManager.java:223)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.object.impl.JooqObjectManager.setFieldsInternal(JooqObjectManager.java:130)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.object.impl.JooqObjectManager$3.execute(JooqObjectManager.java:118)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.idempotent.Idempotent.change(Idempotent.java:88)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.object.impl.JooqObjectManager.setFields(JooqObjectManager.java:115)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.object.impl.JooqObjectManager.setFields(JooqObjectManager.java:110)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.object.impl.AbstractObjectManager.setFields(AbstractObjectManager.java:135)[cattle-framework-object-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.process.common.generic.GenericResourceProcessState.setState(GenericResourceProcessState.java:85)[cattle-iaas-logic-common-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.AbstractStatesBasedProcessState.setDone(AbstractStatesBasedProcessState.java:41)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.setDone(DefaultProcessInstanceImpl.java:561)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.runWithProcessLock(DefaultProcessInstanceImpl.java:307)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$2.doWithLockNoResult(DefaultProcessInstanceImpl.java:245)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:7)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:3)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.acquireLockAndRun(DefaultProcessInstanceImpl.java:242)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.runDelegateLoop(DefaultProcessInstanceImpl.java:184)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.executeWithProcessInstanceLock(DefaultProcessInstanceImpl.java:157)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$1.doWithLock(DefaultProcessInstanceImpl.java:107)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl$1.doWithLock(DefaultProcessInstanceImpl.java:104)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.process.impl.DefaultProcessInstanceImpl.execute(DefaultProcessInstanceImpl.java:104)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.eventing.impl.ProcessEventListenerImpl.processExecute(ProcessEventListenerImpl.java:74)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.engine.eventing.impl.ProcessEventListenerImpl.processExecute(ProcessEventListenerImpl.java:56)[cattle-framework-engine-0.5.0-SNAPSHOT.jar:na] at sun.reflect.GeneratedMethodAccessor581.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_111] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_111] at io.cattle.platform.eventing.annotation.MethodInvokingListener$1.doWithLockNoResult(MethodInvokingListener.java:76)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:7)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.LockCallbackNoReturn.doWithLock(LockCallbackNoReturn.java:3)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl$3.doWithLock(AbstractLockManagerImpl.java:40)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.LockManagerImpl.doLock(LockManagerImpl.java:33)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:13)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.lock.impl.AbstractLockManagerImpl.lock(AbstractLockManagerImpl.java:37)[cattle-framework-lock-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.eventing.annotation.MethodInvokingListener.onEvent(MethodInvokingListener.java:72)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.eventing.impl.AbstractThreadPoolingEventService$2.doRun(AbstractThreadPoolingEventService.java:135)[cattle-framework-eventing-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.NoExceptionRunnable.runInContext(NoExceptionRunnable.java:15)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:108)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)[cattle-framework-managed-context-0.5.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_111] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_111] at java.lang.Thread.run(Thread.java:745)[na:1.7.0_111] Caused by: java.sql.BatchUpdateException: Query execution was interrupted at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:376)[mariadb-java-client-1.3.4.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)[commons-dbcp-1.4.jar:1.4] at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)[jooq-3.3.0.jar:na] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:376)[jooq-3.3.0.jar:na] at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:289)[jooq-3.3.0.jar:na] at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:322)[jooq-3.3.0.jar:na] ... 57 more Caused by: java.sql.SQLTransientException: Query execution was interrupted at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:131)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQueryEpilog(MariaDbServerPreparedStatement.java:338)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:293)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:371)[mariadb-java-client-1.3.4.jar:na] ... 63 more Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Query execution was interrupted at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:475)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)[mariadb-java-client-1.3.4.jar:na] at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:281)[mariadb-java-client-1.3.4.jar:na] ... 64 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    2 times, 2 months ago
    6 times, 2 months ago
    Once, 2 months ago
    4 times, 3 months ago
    2 times, 5 months ago
    1 more bugmates