Finding conflicts v7
You can find conflicts on the Conflict History tab as described in Viewing conflict history. In the Conflict History tab, select Refresh to show all the latest conflicts.
Note
The View Data link and Conflict Details window appear only for multi-master replication systems configured with the trigger-based method of synchronization replication. They aren't available for multi-master replication systems configured with the log-based method of synchronization replication.
The Source DB and Target DB columns provide the IP address and database names of the source and target primary nodes involved in the conflict.
You can get this same information from a SQL query. You can run the following query from a primary node to display information regarding pending (unresolved) conflicts:
SELECT DISTINCT conflict_type, t.table_name, pk_value, d1.db_host AS src_db_host, d1.db_port AS src_db_port, d1.db_name AS src_db_name, src_rrep_sync_id, d2.db_host AS target_db_host, d2.db_port AS target_db_port, d2.db_name AS target_db_name, target_rrep_sync_id, c.notes FROM _edb_replicator_pub.xdb_conflicts c JOIN _edb_replicator_pub.xdb_pub_database d1 ON c.src_db_id = d1.pub_db_id JOIN _edb_replicator_pub.xdb_pub_database d2 ON c.target_db_id = d2.pub_db_id JOIN _edb_replicator_pub.rrep_tables t ON c.table_id = t.table_id WHERE resolution_status = 'P' ORDER BY t.table_name;
The following shows example output from the query:
-[ RECORD 1 ]-------+------------- conflict_type | II table_name | dept pk_value | deptno=50 src_db_host | 192.168.2.22 src_db_port | 5444 src_db_name | edb src_rrep_sync_id | 41939160 target_db_host | 192.168.2.22 target_db_port | 5444 target_db_name | MMRnode target_rrep_sync_id | 42289824 notes | -[ RECORD 2 ]-------+------------- conflict_type | DU table_name | emp pk_value | empno=9003 src_db_host | 192.168.2.22 src_db_port | 5444 src_db_name | edb src_rrep_sync_id | 41940704 target_db_host | 192.168.2.22 target_db_port | 5444 target_db_name | MMRnode target_rrep_sync_id | 42292848 notes |