Assuming that strict two-phase locking is in use, describe how the actions of the two-phase
commit protocol relate to the concurrency control actions of each individual server. How does
distributed deadlock detection fit in?

What will be an ideal response?


Each individual server sets locks on its own data items according to the requests it receives, making
transactions wait when others hold locks.
When the coordinator in the two-phase commit protocol sends the doCommit or doAbort request for a
particular transaction, each individual server (including the coordinator) first carries out the commit or abort
action and then releases all the local locks held by that transaction.
(Workers in the uncertain state may hold locks for a very long time if the coordinator fails)
Only transactions that are waiting on locks can be involved in deadlock cycles. When a transaction is waiting
on a lock it has not yet reached the client request to commit, so a transaction in a deadlock cycle cannot be
involved in the two-phase commit protocol.
When a transaction is aborted to break a cycle, the coordinator is informed by the deadlock detector. The
coordinator then sends the doAbort to the workers.

Computer Science & Information Technology

You might also like to view...

You can press and hold the ____ key, and then click a layer to deselect it.

a. F3 b. Shift c. Ctrl d. Alt

Computer Science & Information Technology

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

When you want to work on a document on which you have worked recently, you can quickly open it by clicking the filename in the Recent section of the app's start screen.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

What type of virtual switch should be used when devices on the physical network do not need direct access to the VMs and vice versa?

What will be an ideal response?

Computer Science & Information Technology