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.
Slave or point in time recovery fails with error:
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.
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