GR Secondary Nodes Fails With HA_ERR_KEY_NOT_FOUND Error On Tables With GENERATED Column (Doc ID 2808533.1)

Last updated on OCTOBER 02, 2023

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

In 8.0.24+, Group replication secondary nodes are failing to apply the update statement though the row exists and fails with HA_ERR_KEY_NOT_FOUND error:

Changes

The following changes exists in the environment:

Problematic table has a GENERATED column.
Specific GENERATED column is part of a PRIMARY KEY.
binlog_row_image is set to MINIMAL.

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

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

GR Secondary Nodes Fails With HA_ERR_KEY_NOT_FOUND Error On Tables With GENERATED Column (Doc ID 2808533.1)

Applies to:

Symptoms

Changes

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!