topic RE: Deadlock Issue in Product Forum

Deadlock Issue

Yeswa_Vaibhav_1 — Thu, 25 Jun 2020 06:24:00 GMT

Hi All,

I am running my BOT suddenly after completing few records, BOT is terminating by showing the below error as reason: "Transaction (Process ID 335) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction"
Process ID changes time to time, but issue is same and process is running on one VM only. No parallel process is happening. Can any one tell me it is occurring and how to handle this.

Regards

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------

RE: Deadlock Issue

expertcr — Thu, 02 Jul 2020 05:47:00 GMT

Hello Yeswa

To try to understand your issue we need more details about what is happening in your process, the selection log will help to review what you doing.
Also see how is the current stage of your DB, is this a test environment? only one bot and server?

------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------

RE: Deadlock Issue

chris.mcgowan — Wed, 15 Jul 2020 08:31:00 GMT

Hi Yeswa,

When a deadlock occurs in SQL Server, two or more tasks are running simultaneously and holding locks on data. Then, each task requests to lock the data the other task is already holding. Both tasks wait for the other to give up, neither does. SQL Server could let this showdown continue indefinitely, but it won't. It picks one task – usually, whichever will be the least expensive to roll back – as the victim, and that task is killed.

To assist with raising this issue with support please could you speak to your Database Administration team and ask them to collect the deadlock information relating to this issue and provide this to support so they can investigate and help understand the issue. Collecting the deadlock information can be done by either enabling trace flags 1204 and 1222 or filtering the system_health Extended Events Session (Provided this is enabled) for "xml_deadlock_report".

------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------