[MDEV-33175] Retrying logic for foreign key check failures in applying Created: 2024-01-04  Updated: 2024-01-04

Status: Open
Project: MariaDB Server
Component/s: Galera
Fix Version/s: 10.4

Type: Task Priority: Major
Reporter: Seppo Jaakola Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 0
Labels: 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.


Generated at Thu Feb 08 10:36:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.