{新}数据库系统概念第八章.pptVIP

Deadlock Since T3 is holding an exclusive mode lock on B and T4 is requesting a shared-mode lock on B, T4 is waiting for T3 to unlock B. Similarly, since T4 is holding a shared-mode lock on A and T3 is requesting an exclusive-mode lock on A, T3 is waiting for T4 to unlock A. Thus, we have arrived at a state where neither of these transactions can ever proceed with its normal execution. This situation is called deadlock. SSDUT-Software School of DUT * Deadlock When deadlock occurs, the system must roll back one of the two transactions. Once a transaction has been rolled back, the data items th