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? Databases databases transaction-and-concurrency 2phaselocking concurrency + – aditi19 asked Nov 25, 2018 • edited Nov 25, 2018 by aditi19 aditi19 455 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
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. Yashad145 answered Dec 9, 2018 • edited Dec 9, 2018 by Yashad145 Yashad145 comment Share Follow See 1 comment See all 1 1 comment reply aditi19 commented Dec 9, 2018 reply Follow Share yes 0 votes 0 votes Please log in or register to add a comment.