Error code 1032
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
Subject
Views
Written By
Posted
Error code 1032
4176
June 28, 2021 03:07AM
1383
June 28, 2021 01:29PM
1301
June 30, 2021 03:44AM
1159
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.