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

wsrep_slave_fk_checks=OFF results in inconsistency

    XMLWordPrintable

Details

    • Can result in hang or crash
    • 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.
    • Q1/2026 Galera Development, 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

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34822 Skip FK checks in Galera during applying in IST

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36360 Disabling FK and UK checks on appliers may lead to deadlock

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Yurchenko Alexey
              Yurchenko Alexey
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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