edited by
446 views
1 votes
1 votes

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?

edited by

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

Related questions

2 votes
2 votes
0 answers
1
vinay chauhan asked Jan 18, 2019
575 views
Is different 2 phase locking a subset of each other? For example, if the schedule is Strict 2PL then it will also be simple 2PL.Something like a 2PL is a subset of Strict...
0 votes
0 votes
0 answers
2
jayadev asked Jul 2, 2022
347 views
question about concurrency control methods
1 votes
1 votes
0 answers
3
0 votes
0 votes
0 answers
4
aditi19 asked Dec 8, 2018
336 views
pls explain why C is correct not A?isn’t every schedule that is supported by 2PL conflict serializable?