Handling of Failures -Network Partition If the coordinator and all its participants remain in one partition,the failure has no effect on the commit protocol. If the coordinator and its participants belong to several partitions: Sites that are not in the partition containing the coordinator think the coordinator has failed,and execute the protocol to deal with failure of the coordinator. No harm results,but sites may still have to wait for decision from coordinator. The coordinator and the sites are in the same partition as the coordinator think that the sites in the other partition have failed,and follow the usual commit protocol. ■Again,no harm results Database System Concepts-7th Edition 23.13 ©Silberscha乜，Korth and SudarshanDatabase System Concepts - 7 23.13 ©Silberschatz, Korth and Sudarshan th Edition Handling of Failures - Network Partition ▪ If the coordinator and all its participants remain in one partition, the failure has no effect on the commit protocol. ▪ If the coordinator and its participants belong to several partitions: • Sites that are not in the partition containing the coordinator think the coordinator has failed, and execute the protocol to deal with failure of the coordinator. ▪ No harm results, but sites may still have to wait for decision from coordinator. ▪ The coordinator and the sites are in the same partition as the coordinator think that the sites in the other partition have failed, and follow the usual commit protocol. ▪ Again, no harm results