Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33175

Retrying logic for foreign key check failures in applying

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4
    • Galera
    • 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.

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            seppo Seppo Jaakola
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.