

In WFG, processes are represented by nodes while dependencies are represented by edges. The result of such state is that none of the process will be complete.ĭeadlock detection finds and resolves deadlocks. A live lock is similar to a deadlock except the process states keeps changing. What is a deadlock and what is a live lock? How will you go about resolving deadlocks? A deadlock occurs when two or more processes waits for a resource that is acquired by or is under the control of another process.
#Livelock vs deadlock code#
If the code inside a TRY statement fails, the CATCH automatically catches the control of the flow letting the transaction rollback and resume execution.

One can resolve deadlocks by using TRY CATCH blocks. When a request for exclusive lock is denied again and again because a series of overlapping shared locks are interfering with each other and to adapt from each other they keep on changing the status, it is known as live lock. In such a scenario each process is waiting for the other process to release the lock to acquire a lock on the object itself. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?Deadlock occurs when two user processes/transactions have locks on 2 separate objects and each process is trying to acquire a lock on the object that has been acquired by the other process.
