Handling
deadlocks
: introduction
Review
Recall:
2-phase locking
can
result
in
deadlock
conditions
See:
click here
In this
chapter
we will study
techniques
to
resolve
deadlocks
Techniques to resolve
deadlocks
Techniques
for
handling deadlocks
:
Deadlock
detection
(and
break
the
deadlock
when one is
detected
):
Timeout
Wait-for graph
Deadlock
prevention
: (do
not
allow
deadlocks
to
develop
)
Ordering
the
DB elements
Ordering
on
transactions
:
Wait-die
scheme
Wound-wait
scheme