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

Creating partitioned tables should not be allowed with wsrep_osu_method=TOI and wsrep_strict_ddl=ON

Details

    Description

      When a galera cluster is configured with wsrep_osu_method=TOI and wsrep_strict_ddl=ON it's not possible to alter or delete partitioned tables (You will get the error message ERROR 4165 (HY000): DDL-statement is forbidden as table storage engine does not support Galera replication.

      However it's still possible to create partitioned tables with those settings.
      This should be disallowed, as it doesn't make sense to have partitioned tables, when you can't alter them (eg when you want to run a reorganize of the table).

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36372 Compilation is broken with the PLUGIN_PARTITION=NO

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

          Activity

            Ascending order - Click to sort in descending order
            janlindstrom Jan Lindström added a comment -

            nicolas.bigler Based on documentation "If set, reject DDL on affected tables not supporting Galera replication", thus it should not effect InnoDB but it seems to do so in ALTER. This is a bug.

            janlindstrom Jan Lindström added a comment - nicolas.bigler Based on documentation "If set, reject DDL on affected tables not supporting Galera replication", thus it should not effect InnoDB but it seems to do so in ALTER. This is a bug.
            janlindstrom Jan Lindström added a comment -
            janlindstrom Jan Lindström added a comment - 10.5 : https://github.com/MariaDB/server/pull/2716 10.6+: https://github.com/MariaDB/server/pull/2717
            sysprg Julius Goryavsky added a comment -

            janlindstrom Thanks, the fix has been merged into the main revision.

            sysprg Julius Goryavsky added a comment - janlindstrom Thanks, the fix has been merged into the main revision.
            sysprg Julius Goryavsky added a comment -

            The fix has been merged into the main revision:
            10.5: https://github.com/MariaDB/server/commit/22414d2ed0f1f8be26fb5e82e0129b629e5dbd20
            10.6: https://github.com/MariaDB/server/commit/9389428380afcef4f0a148e4e2e3327c1584d265

            sysprg Julius Goryavsky added a comment - The fix has been merged into the main revision: 10.5: https://github.com/MariaDB/server/commit/22414d2ed0f1f8be26fb5e82e0129b629e5dbd20 10.6: https://github.com/MariaDB/server/commit/9389428380afcef4f0a148e4e2e3327c1584d265
            marko Marko Mäkelä added a comment -

            This broke the build with cmake -DPLUGIN_PARTITION=NO.

            marko Marko Mäkelä added a comment - This broke the build with cmake -DPLUGIN_PARTITION=NO .
            janlindstrom Jan Lindström added a comment -

            sysprg https://github.com/MariaDB/server/pull/3915

            janlindstrom Jan Lindström added a comment - sysprg https://github.com/MariaDB/server/pull/3915
            sysprg Julius Goryavsky added a comment -

            janlindstrom Thanks, the fix has been merged with the head revision (https://github.com/MariaDB/server/commit/1277f9b4513a0f4c3303a41e142465dc7e403ad7)

            sysprg Julius Goryavsky added a comment - janlindstrom Thanks, the fix has been merged with the head revision ( https://github.com/MariaDB/server/commit/1277f9b4513a0f4c3303a41e142465dc7e403ad7 )

            People

              sysprg Julius Goryavsky
              nicolas.bigler Nicolas Bigler
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.