Question: Consider a distributed transaction T operating under the two-phase commit protocol. Let N 5 be the coordinator node, and N 6 , N 7 ,

  1. Consider a distributed transaction T operating under the two-phase commit protocol. Let N5 be the coordinator node, and N6, N7, N8 be the participant nodes. The following messages have been sent:

time message

1 N5 to N6: Phase1: PREPARE

2 N5 to N7: Phase1: PREPARE

3 N5 to N8: Phase1: PREPARE

4 N6 to N5: OK

5 N7 to N5: OK

  1. Who should send a message next at time 6? Explain.
  2. To whom?
  3. Suppose that N5 never received the OK response from N7 at time 5 (the message got dropped due to a hardware failure). Instead, N5 times out after waiting a certain amount of time. What should happen under the two-phase commit protocol in this scenario?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!