My Oracle Support Banner

slave_rows_search_algorithms With HASH_SCAN Leads To Slave Failure: ERROR 1032 (HY000) at line 263: Can't find record in table (Doc ID 2473168.1)

Last updated on APRIL 12, 2021

Applies to:

MySQL Server - Version 5.7 to 8.0 [Release 5.7 to 8.0]
Information in this document applies to any platform.

Symptoms

Slave or point in time recovery fails with error:

Changes

The tables don't have a primary key,  or the slave_row_search_algorithms was recently changed to prefer HASH_SCAN.

In 8.0.x the default value for slave_row_search_algorithms includes HASH_SCAN so the bug is more apparent there, out of the box, if upgrade was recently done from 5.7 to 8.0.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.