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

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