MySQL Forums
Forum List  »  Replication

Error code 1032
Posted by: GCG Support
Date: June 28, 2021 03:07AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Error code 1032
462
June 28, 2021 03:07AM
164
June 28, 2021 01:29PM
199
June 30, 2021 03:44AM
197
June 30, 2021 07:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.