My Oracle Support Banner

Multi-Threadded Applier ( replica_parallel_type = LOGICAL_CLOCK ) Stops Due To Foreign Key Error (Doc ID 3052107.1)

Last updated on OCTOBER 29, 2024

Applies to:

HeatWave - Version N/A and later
MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

On a replica with the multi-threaded applier (MTA), which is enabled by replica_parallel_type=LOGICAL_CLOCK, and binlog_transaction_dependency_tracking is set to WRITESET or WRITESET_SESSION on its source, the applier stops due to a foreign key error. An error like below is typically raised:

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!

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.