首页 > 应用开发 > IT综合 > Deadlocks (337)

Deadlocks (337)

原创 IT综合 作者:tsinglee 时间:2007-12-10 11:42:54 0 删除 编辑

A deadlock can occur when two or more users are waiting for data locked by each
other. Deadlocks prevent some transactions from continuing to work. Figure 13–3 is a
hypothetical illustration of two transactions in a deadlock.

In Figure 13–3, no problem exists at time point A, as each transaction has a row lock on
the row it attempts to update. Each transaction proceeds without being terminated.
However, each tries next to update the row currently held by the other transaction.
Therefore, a deadlock results at time point B, because neither transaction can obtain
the resource it needs to proceed or terminate. It is a deadlock because no matter how
long each transaction waits, the conflicting locks are held.

1. 当两个用户互相等待对方释放锁定的资源时就会发生死锁 , 死锁将阻止事务继续执行


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: what is lost update?
请登录后发表评论 登录
  • 博文量
  • 访问量