Manual conflict resolution for the log-based method v7

Note

See Manual conflict resolution for the trigger-based method for information on manual conflict resolution for multi-master replication systems configured with the trigger-based method of synchronization replication.

As discussed in Conflict prevention - uniqueness case there's no built-in, automatic conflict-resolution strategy for the uniqueness (insert/insert) conflict. If a uniqueness conflict occurs, to resolve this conflict you must modify rows in the publication tables containing the conflict and modify rows in the control schema tables in the primary nodes.

Similarly, you must use manual correction for update/delete and delete/update conflicts. In addition, if the conflict resolution option is set to Manual (see Updating the conflict-resolution options) and a conflict occurs, you must also resolve this conflict manually.

finding_conflict conflict_resolution_for_log_based overview_correction_strategies_log_based manual_publication_table_correction_log_based correction_using_new_txn_log_based