# Deadlock Detected Error **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [November 13, 2024, 4:39pm UTC](https://forum.inductiveautomation.com/t/deadlock-detected-error/98572 "2024-11-13T16:39:23Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![PRASHANTH\_KAKKIRALA](https://avatars.discourse-cdn.com/v4/letter/p/76d3ee/32.png) [@PRASHANTH\_KAKKIRALA](https://forum.inductiveautomation.com/u/PRASHANTH_KAKKIRALA)\ **Post date:** [November 13, 2024, 4:39pm UTC](https://forum.inductiveautomation.com/t/deadlock-detected-error/98572/1 "2024-11-13T16:39:23Z")
What can cause this error ? Using Ignition 8.1.35 ```python com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most recent call last): File "", line 237, in runAction File "", line 159, in modelApply Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:407) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.execute(NamedQueryExecutor.java:173) at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.execute(GatewayNamedQueryManager.java:92) at com.inductiveautomation.ignition.common.db.namedquery.SecuredNamedQueryManager.execute(SecuredNamedQueryManager.java:78) at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.runNamedQuery(GatewayDBUtilities.java:419) at jdk.internal.reflect.GeneratedMethodAccessor202.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) java.lang.Exception: java.lang.Exception: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" at org.python.core.Py.JavaError(Py.java:545) at org.python.core.Py.JavaError(Py.java:536) at org.python.core.PyReflectedFunction. __call__ (PyReflectedFunction.java:192) at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. __call__ (ScriptManager.java:553) at org.python.core.PyObject. __call__ (PyObject.java:477) at org.python.core.PyObject. __call__ (PyObject.java:481) at org.python.pycode._pyx1128.modelApply$1(:22) at org.python.pycode._pyx1128.call_function() at org.python.core.PyTableCode.call(PyTableCode.java:173) at org.python.core.PyBaseCode.call(PyBaseCode.java:306) at org.python.core.PyFunction.function ___call__ (PyFunction.java:474) at org.python.core.PyFunction. __call__ (PyFunction.java:469) at org.python.core.PyFunction. __call__ (PyFunction.java:459) at org.python.pycode._pyx1219.runAction$1(:258) at org.python.pycode._pyx1219.call_function() at org.python.core.PyTableCode.call(PyTableCode.java:173) at org.python.core.PyBaseCode.call(PyBaseCode.java:306) at org.python.core.PyFunction.function ___call__ (PyFunction.java:474) at org.python.core.PyFunction. __call__ (PyFunction.java:469) at org.python.core.PyFunction. __call__ (PyFunction.java:464) at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:847) at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:829) at com.inductiveautomation.ignition.gateway.project.ProjectScriptLifecycle$TrackingProjectScriptManager.runFunction(ProjectScriptLifecycle.java:868) at com.inductiveautomation.ignition.common.script.ScriptManager$ScriptFunctionImpl.invoke(ScriptManager.java:1010) at com.inductiveautomation.ignition.gateway.project.ProjectScriptLifecycle$AutoRecompilingScriptFunction.invoke(ProjectScriptLifecycle.java:950) at com.inductiveautomation.perspective.gateway.script.ScriptFunctionHelper.invoke(ScriptFunctionHelper.java:161) at com.inductiveautomation.perspective.gateway.script.ScriptFunctionHelper.invoke(ScriptFunctionHelper.java:98) at com.inductiveautomation.perspective.gateway.action.ScriptAction.runAction(ScriptAction.java:80) at com.inductiveautomation.perspective.gateway.action.ActionDecorator.runAction(ActionDecorator.java:18) at com.inductiveautomation.perspective.gateway.action.SecuredAction.runAction(SecuredAction.java:44) at com.inductiveautomation.perspective.gateway.model.ActionCollection$ActionSequence$ExecuteActionsTask.lambda$call$0(ActionCollection.java:263) at com.inductiveautomation.perspective.gateway.api.LoggingContext.mdc(LoggingContext.java:54) at com.inductiveautomation.perspective.gateway.model.ActionCollection$ActionSequence$ExecuteActionsTask.call(ActionCollection.java:252) at com.inductiveautomation.perspective.gateway.model.ActionCollection$ActionSequence$ExecuteActionsTask.call(ActionCollection.java:221) at com.inductiveautomation.perspective.gateway.threading.BlockingTaskQueue$TaskWrapper.run(BlockingTaskQueue.java:154) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at com.inductiveautomation.perspective.gateway.threading.BlockingWork$BlockingWorkRunnable.run(BlockingWork.java:58) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.python.core.PyException: java.lang.Exception: java.lang.Exception: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" ... 41 common frames omitted Caused by: java.lang.Exception: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:407) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor.execute(NamedQueryExecutor.java:173) at com.inductiveautomation.ignition.gateway.db.namedquery.GatewayNamedQueryManager.execute(GatewayNamedQueryManager.java:92) at com.inductiveautomation.ignition.common.db.namedquery.SecuredNamedQueryManager.execute(SecuredNamedQueryManager.java:78) at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.runNamedQuery(GatewayDBUtilities.java:419) at jdk.internal.reflect.GeneratedMethodAccessor202.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.python.core.PyReflectedFunction. __call__ (PyReflectedFunction.java:190) ... 38 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:134) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:981) at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:181) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.runPrepQuery(NamedQueryExecutor.java:507) at com.inductiveautomation.ignition.gateway.db.namedquery.NamedQueryExecutor$NamedQueryInstance.execute(NamedQueryExecutor.java:399) ``` ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [November 13, 2024, 4:42pm UTC](https://forum.inductiveautomation.com/t/deadlock-detected-error/98572/2 "2024-11-13T16:42:47Z")
> [@PRASHANTH\_KAKKIRALA](#): > > ```python > at com.inductiveautomation.perspective.gateway.threading.BlockingWork$BlockingWorkRunnable.run(BlockingWork.java:58) > > ``` > [@PRASHANTH\_KAKKIRALA](#): > > Using Ignition 7.9.15 No you're not; Perspective isn't compatible with Ignition 7.9. That said: ```python Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 38680 waits for ShareLock on transaction 2401420; blocked by process 37632. Process 37632 waits for ShareLock on transaction 2401419; blocked by process 38680. Hint: See server log for query details. Where: while updating tuple (26678,18) in relation "Metadata" ``` This deadlock is entirely in PostgreSQL, not Ignition. All Ignition is doing is reporting the error message your database sent us. Investigate inside your DB.