in Databases edited by
311 views
1 vote
1 vote

T1: W(X), T2: R(Y), T1: R(Y), T2: R(X)

does 2PL protocol allows it?
 

     T1      T2
L-X(X)
W(X)

L-S(Y)
R(Y)
U(X)
 

L-S(Y)
R(Y)



L-S(X)
R(X)

here T2 is granted lock on X as T1 enters shrinking phase as no exclusive locks are held on X
is my solution correct?

in Databases edited by
by
311 views

1 Answer

0 votes
0 votes
I think you're correct because the growing and shrinking phase is for transaction and not for the schedule. T2 will grant lock because T2 is not in shrinking phase, T1 is in shrinking phase.

hope you understood.correct me if i am wrong.
edited by

1 comment

yes
0
0