Error code 1032

[GCG Support]

Hello team,


I have Server A and Server B.
They are running MySQL community server 8.023 on RedHat Linux 7.9.
Mysql replication (row--based replication) has been setup between the two servers.
Server A is master and server B is slave.

The replication runs smoothly for a period of time.
However, the replication encounter errors last week.

The error was:
Could not execute Update_rows event on table user-table;
Can't find record in 'user-table', Error_code: 1032; Can't find record in 'user-table',
Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log pxibdb01_binlog.146468, end_log_pos 3041936

By using mysqlbinlog to examine the binlog pxibdb01_binlog.146468, i finally located the missing records in user-table of slave DB and update them manually. The replication resumed.

As there was no network connection lost or OS error message, may i ask what may be the cause of this error.


Kindly request your assistance.

Regards,
Alex