ERR-610F7 Receiver Unable to find record in executeDelete() or executeUpdate() function#
Version#
7.1.0 or later
In 4.3.9, this error is output as two separate errors:
- DELETE: ERR-61036 [Receiver] err_not found in deleteXlog()
- UPDATE: ERR-6103A [Receiver] err_not_found in updateXlog()
Explanation#
The DELETE or UPDATE statement received through replication cannot be applied on the receiving server.
Cause#
This error occurs when the record to be deleted or updated is not found on the receiving server. It is a replication conflict that occurs when the data on the two servers do not match.
The function name in the error message shows which statement failed.
- executeDelete() : The DELETE statement failed.
- executeUpdate() : The UPDATE statement failed.
Action#
Check the error and the statement that failed in $ALTIBASE_HOME/trc/altibase_rp_conflict.log on the receiving server.
ERR-610f7(errno=16) [Receiver] Unable to find record in executeDelete() function
DELETE FROM SYS.JV_R WHERE C1 = 1; (TID : 145425)
ERR-610f7(errno=16) [Receiver] Unable to find record in executeUpdate() function
UPDATE SYS.JV_R SET C2 = 'x' WHERE C1 = 2; (TID : 147473)
Match the data on both servers, or find and resolve the cause of the conflict (such as application logic).
Reference#
N/A