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

mysql_upgrade fails to load type_mysql_json due to insufficient maturity level

Details

    Description

      When mysql_upgrade encounters MySQL JSON type, it attempts to load type_mysql_json. In reality it cannot do so, because the plugin is Alpha, and the default allowed plugin maturity level for GA releases is gamma:

      10.5 5518c320

      		 
      installing plugin for MYSQL_JSON data type
      		 
      ERROR 1126 (HY000) at line 1: Can't open shared library 'type_mysql_json.so' (errno: 1, Loading of alpha plugin MYSQL_JSON is prohibited by --plugin-maturity=gamma)

      It can be especially problematic for Debian package installation, as it runs mysql_upgrade automatically.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26231 mysql_upgrade attempts to remove plugins which it failed to install

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • In Review

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik added a comment -

            bumped to beta, will bump to gamma after the 2022-Q1 release

            serg Sergei Golubchik added a comment - bumped to beta, will bump to gamma after the 2022-Q1 release
            serg Sergei Golubchik added a comment -

            rucha174, could you please change the maturity of the mysql_json plugin to gamma?

            serg Sergei Golubchik added a comment - rucha174 , could you please change the maturity of the mysql_json plugin to gamma?
            rucha174 Rucha Deodhar added a comment -

            serg sure

            rucha174 Rucha Deodhar added a comment - serg sure
            rucha174 Rucha Deodhar added a comment -

            Patch: https://github.com/MariaDB/server/commit/e431f4b6e0fff25c3042aad205732b2862aee793

            rucha174 Rucha Deodhar added a comment - Patch: https://github.com/MariaDB/server/commit/e431f4b6e0fff25c3042aad205732b2862aee793
            serg Sergei Golubchik added a comment -

            e431f4b6e0fff25c3042aad205732b2862aee793 is, obviously, ok to push.

            Just make sure all tests pass, because the plugin maturity level can show up in some test results that will need to be updated. So, just double-check tests are fine (or fix results if needed) — and then, please, push

            serg Sergei Golubchik added a comment - e431f4b6e0fff25c3042aad205732b2862aee793 is, obviously, ok to push. Just make sure all tests pass, because the plugin maturity level can show up in some test results that will need to be updated. So, just double-check tests are fine (or fix results if needed) — and then, please, push
            rucha174 Rucha Deodhar added a comment -

            double checked that all tests are passing.

            rucha174 Rucha Deodhar added a comment - double checked that all tests are passing.

            People

              rucha174 Rucha Deodhar
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.