Viewing Conflict History v6.2
Conflict history shows the following types of events that occurred during synchronization replication:
- Uniqueness conflicts where two or more primary nodes attempted to insert a row with the same primary key value or unique column value.
Update/updateconflicts where two or more primary nodes attempted to update the same column of the same rowUpdate/deleteanddelete/updateconflicts where one primary node attempted to update a row that was deleted by another primary node.
See Section Conflict Resolution for more information on conflict resolution.
Note
The conflict history can be viewed from the Publication node under any primary node in the multi-primary replication system. The history shows conflicts on all publication tables of all primary nodes that occurred during synchronization, and hence, the history appears the same regardless of the primary node under which it is viewed.
Note
For uniqueness (insert/insert) conflicts the number of entries appearing under the Conflict History tab differs when the trigger-based method of synchronization replication is used as compared to the log-based method. If the trigger-based method is used, a single insert/insert conflict appears as two entries in the conflict history. Each entry differs in that the source and target database fields for the two conflicting primary nodes are interchanged. If the same conflict occurs when the log-based method is used, only one entry appears in the conflict history.
The following steps describe how to view the conflict history.
Step 1: Select any Publication node under a Database node representing a primary node. Tabs labeled General, Realtime Monitor, Replication History, and Conflict History appear.
Figure 6-56: Selecting a publication on which to view conflict history
Step 2: Click the Conflict History tab to show conflict history. Click Refresh to ensure all the conflicts are listed.
Figure 6-57: Conflict History tab
Step 3: Use the Conflict Display Criteria drop-down list to display only conflicts of the chosen status.
Figure 6-58: Selecting conflict history by status
Step 4: Click the View Data link to show the details of a particular conflict.
Note
The View Data link and Conflict Details window are available only for multi-primary replication systems configured with the trigger-based method of synchronization replication. There is no View Data link or Conflict Details window for multi-primary replication systems configured with the log-based method of synchronization replication.
Figure 6-59: Conflict Details window