Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
Replication applier may fail to check foreign key constraint when applying row event for a table with foreign key constraint definition.
In testing, it has turned out that such FK check failure may be temporary and just retrying the FK constraint verification may turn out successful and helps the applier to continue.
The retrying should happen inside InnoDB soon after the initial FK constraint failure happens, and should be configurable to allow given number of retry attempts. Also, FK constraint retrying should affect only replication applier or replayer.