ocr: TASK A TASK B LOCK MANAGER Waiting for Waiting for release of release of RID 2001 by RID4221 by TASK B TASK A 1.Task A issues Select"from Employee; (1000 shared locks set) 2.Task B issues Update employee set salary= salary1.1; (waits for Task. a to release its shared locks) 3.Task A now issues Update employee set bonus llag =1;( (Task. A now waits for the exclusive locks set by TASK B1 to release, unaware that Task. Ai is waiting on its own locks) FIGURE 3. Database deadlocks (the perpetual embrace).
