MS SQL Server deadlocking messages when RHPAM is under load

Solution Verified - Updated -

Issue

  • When executing load tests it possible to notice some MS SQL deadlocking messages appearing in the log. The test used 10 concurrent threads to go through a simple process that had 1 human node. The test starts the process and claims, starts, completes the human task. All this works when it's used a single thread on the test script.
  • However when ramping up the tests occassionally messages like the following shows up on the log. This is only happening on the task complete (which is the end of the process).
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 504) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:578)

Environment

  • Red Hat Process Automation Manager (RHPAM)
    • 7.x
  • Microsoft SQL Server driver
    • 7

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