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

mysql_upgrade -s still checks for non system tables

    XMLWordPrintable

Details

    Description

      mysql_upgrade -s is supposed to just check system tables, and leave customer tables alone. well, this does not seem the case:

      | 918965 | root | localhost | mysql | Query   |  244 | checking permissions | SELECT table_comment FROM information_schema.tables WHERE table_comment LIKE 'Unknown data type: %' |    0.000 |

      this is not expected and on a database with millions of tables, can take a VERY long time.

      We need to respect the "-s" flag and just check system tables.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-24093 Detect during mysql_upgrade if type_mysql_json.so is needed and load it

          • Major - Major loss of function.
          • Closed
          links to

          Web Link PR 2790

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              rpizzi Rick Pizzi (Inactive)
              Votes:
              4 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.