in Databases
432 views
0 votes
0 votes
Is basic 2 phase locking always recoverable?
in Databases
by
432 views

2 Comments

No , it's not always recoverable .

For an instance let's check this schedule.

T1                  T2

w(a)

                       r(a)

                       w(a)

                       commit;

---failure

This schedule is allowed in Basic 2 phase locking , but this is not a recoverable schedule.
3
3
Thanks.. :)
1
1

1 Answer

0 votes
0 votes
yes 2PL locking is always recoverable.

1 comment

No it's not.
0
0

Related questions