Receiving "Transaction (Process ID #) was deadlocked on lock resources with another process and has been chosen as the deadlock victim." error in EDS

Solution Verified - Updated -

Issue

  • When using LoadTest within SoapUI, upon increase the number of threads to greater than 1, we encounter the ATOMIC transaction encountering roll back and the following error is found. However, when the threads only set to 1, everything works fine.
14:27:55,824 WARN  [CONNECTOR] Connector worker process failed for atomic-request=yxHQEa3Rfujg.5.8.179
org.teiid.translator.jdbc.JDBCExecutionException: Error Code:1205 Message:'Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.' error executing statement(s): [Prepared Values: [] SQL: SELECT MAX(v_0.c_0) FROM (SELECT g_0."advertisement_id" AS c_0 FROM "advertisement" g_0) v_0 HAVING COUNT(*) > 0]
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:276)
        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)
        at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)
        at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)
        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
        at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:90)
        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
        at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:86)
        at org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:367)
        at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:311)
        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)
        at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)...

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In