enterprise replication (Error: Failed conflict r
Posted in 2011
IBM Informix Dynamic Server Version 11.50.FC6 HP-UX auast120 B.11.23 U 9000/800 331862253 hello we are getting replication errors with following message TXH One or more rows in a transaction defined with tx scope were rejected TXH CDR:14 (Error: Failed conflict resolution rule) / SQL:0 / ISAM:0 This is happenning on a table that has smart blobs . We only see the error when a row is being changed on the system. There are only 2 nodes in the replication. Replication is like a master slave that is we only replicate from a to b never b to a (though we are using update anywhere) . Has anyone else struck this issue. a check gives following Table scan for ec_accept_ec_certificate_file_output start -------- data mismatch key: cert_id:11589 key: file_type:off_xml column: file_snapshot ec_ap_uat_wlg:CHECKSUM<576648714> ec_ap_uat_akl:CHECKSUM<39554179> ------------------------------------------------------------------ Node Rows Extra Missing Mismatch Processed ---------------- --------- --------- --------- --------- --------- ec_ap_uat_wlg 2364 0 0 0 0 ec_ap_uat_akl 2364 0 0 1 0 WARNING: replicate is not in sync running cdr check replicate --master ec_ap_uat_wlg --repl= ec_accept_ec_certificate_file_output ec_ap_uat_akl --repair fixes the the problem. the system is not busy and there are no network errors. It is a test system hence lightly loaded