Deadlocked Error

, ,
1

Hi All,

We are randomly getting the “Deadlock error” while invoking the JDBC adapter service. Below are the detailed error logs. Could anyone please help to resolve this.

(40001/1205) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 195) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Thanks,
Mohit K

2

Hi Mohit,

Are you using two transactions in one commit? Is your table used by other service/process/DML query?

Can you share your code algorithm?

Thanks,
Rankesh

3

Hi Rankesh,

Thanks for the quick response.

Logic is nearly like:

  1. In flow service - we have multiple child services which later on performing the actions on dB based on the branch conditions.
  2. All these child services are calling one Java service which in turn invokes the JDBC adapter services (Insert/select/update/delete).
  3. Transaction type is defined as “No Transaction” in JDBC connection

Thanks
Mohit K

4

Hi Mohit,

I hope it is clear after our discussion.

Thanks,
Rankesh