0 votes 0 votes Is basic 2 phase locking always recoverable? Databases databases 2phaselocking two-phase-locking-protocol + – Hirak asked Jun 10, 2019 Hirak 574 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply prashant jha 1 commented Jun 10, 2019 reply Follow Share 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 votes 3 votes Hirak commented Jun 10, 2019 reply Follow Share Thanks.. :) 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes yes 2PL locking is always recoverable. DIBAKAR MAJEE answered Apr 19, 2020 DIBAKAR MAJEE comment Share Follow See 1 comment See all 1 1 comment reply biswajitbora commented Jun 20, 2021 reply Follow Share No it's not. 0 votes 0 votes Please log in or register to add a comment.