How to produce Deadlock Exception in D365FO using X++

(4) Share

Report

Posted on by Sachin Mittal

Hi All,

I am working on application insights, and I have a log for exceptions generated, I want to check if deadlock exception will be shown in that log or not. in order to check this, first I have to generate deadlock exception.

Can anyone let me know how we can we produce the deadlock exception in D365FO using x++

Thanks In Advance…!

All responses (3)

Answers (1)

Sort by

Verified answer

Martin Dráb 241,515 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

I would do something like this:

Have two separate DB connections. One will be the default one, the other created by UserConnection class. You'll update two tables with pessimistic locking, i.e. either the tables will have Ooc Enabled = No or you'll select records for update with pessimisticLock keyword.

Let's say you have one record in TableA and one in table B. Update TableA record in connection 1. Update TableB record in connection 2. Then update the same TableB record in connection 1 and TableA record in connection 2. Each connection will have both updates in the same transaction.

Now connection 1 is waiting for the lock on TableB held by connection 2. And connection 2 is waiting for the lock on TableA held by connection 1. That's a deadlock - if the DB server didn't detect this situation, they would stay blocked forever.
Suggested answer

Sachin Mittal 6 on at

Like (0)

Report
Copy link

Link copied!
Thanks this Worked for me, adding code here two, what I did is created two runnable classes and run these using class runner, and deadlock exception is generated
internal final class DeadLock_B { static void execute1() { InventSum inventSum; CustTable custTable; ttsBegin; select forUpdate inventSum where inventSum.RecId == 68719638196; sleep(10000); select pessimisticlock custTable where custTable.RecId == 22565424065; custTable.selectForUpdate(true); ttsCommit; } /// <summary> /// Class entry point. The system will call this method when a designated menu /// is selected or when execution starts and this class is set as the startup class. /// </summary> /// <param name = "_args">The specified arguments.</param> public static void main(Args _args) { OA_DeadLock_B::execute1(); } } internal final class DeadLock_A { static void execute2() { InventSum inventSum; CustTable custTable; ttsBegin; select pessimisticlock custTable where custTable.RecId == 22565424065; custTable.selectForUpdate(true); sleep(10000); // Attempt to access Resource X select forUpdate inventSum where inventSum.RecId == 68719638196; ttsCommit; } /// <summary> /// Class entry point. The system will call this method when a designated menu /// is selected or when execution starts and this class is set as the startup class. /// </summary> /// <param name = "_args">The specified arguments.</param> public static void main(Args _args) { OA_DeadLock_A::execute2(); } }
generated
Diana Sousa 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I tried replicate the example from @Sachin Mittal but i don´t have the exception deadlock.
Why ?
I use two users different, and 2 browsers different.
Really he has behavior correct, but does not show any error.