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

wsrep_slave_fk_checks=OFF results in inconsistency

    XMLWordPrintable

Details

    • Bug
    • Status: Approved (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 12.2.1, 10.6.25, 11.4.10, 11.8.6
    • N/A
    • Galera
    • wsrep_slave_FK_checks configuration option was deprecated and from no on has no effect. Slave foreign key checks are always on as otherwise leads to massive data inconsistency on all replicas which subsequently results in master node abort.
    • Q2/2026 Galera Maintenance

    Description

      Since ATM wsrep does not replicate any cascaded changes (because they are not binlogged in the upstream code) we have to rely on foreign checks on replicas to reproduce the cascade. Thus setting wsrep_slave_fk_checks=OFF will result in inconsistency in any setup where there are cascading relations.
      Mark this option as deprecated and make it a NOOP.

      The issue can be confirmed by running galera_fk_cascade_delete MTR test with wsrep_slave_fk_checks=OFF

      Attachments

        Activity

          People

            Yurchenko Alexey
            Yurchenko Alexey
            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.