MySQL Forums
Forum List  »  Replication

Error code 1032
Posted by: GCG Support
Date: July 13, 2021 04:03AM

Hello all,


I have Server A and Server B.
They are running MySQL community server 8.0.23 on RedHat Linux 7.9 (upgrade from Mysql server 5.7.31) .
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
1587
July 13, 2021 04:03AM
511
July 13, 2021 09:52AM


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.