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

mysql_upgrade attempts to remove plugins which it failed to install

    XMLWordPrintable

Details

    Description

      When mysql_upgrade is run on a MySQL datadir with JSON type, it attempts to install type_mysql_json. In reality, it is likely to fail (e.g. due to MDEV-26230).
      Further in the logic it attempts to uninstall previously installed plugins. Since it failed to install this one, it should be skipped upon uninstallation, but it is not:

      10.5 5518c320

      Checking for tables with unknown storage engine
      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)
      Phase 3/7: Fixing views from mysql
      

      test.t
      Error    : Unknown data type: 'MYSQL_JSON'
      error    : Corrupt
      uninstalling plugin for 'type_mysql_json' data type
      ERROR 1305 (42000) at line 1: SONAME type_mysql_json.so does not exist
      Phase 7/7: Running 'FLUSH PRIVILEGES'
      

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.