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

[Warning] Could not open mysql.plugin table. Some options may be missing from the help text

    XMLWordPrintable

Details

    Description

      Upgraded to MariaDB 10.4 (from 10.3) on a new server. Used MariaBackup to restore, and then ran mysql_upgrade.

      Everything loads well, MariaDB works, but I get the following warning:

      [root@server ~]# mysqld --verbose --help 1>/dev/null
      2020-05-20  0:56:22 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-05-20  0:56:22 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
      

      I'm just worried that this might cause a problem, even though it's just a warning.

      By searching other people having this warning (sometimes as an 'error'), all of them said that it was solved by deleting the datadir and restarting, which is obviously not what I want...

      This doesn't seem to be a permission problem, as the table is well visible (but empty):

      [root@server ~]# mysql -e "show create table mysql.plugin"
      +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Table  | Create Table                                                                                                                                                                                                                 |
      +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | plugin | CREATE TABLE `plugin` (
        `name` varchar(64) NOT NULL DEFAULT '',
        `dl` varchar(128) NOT NULL DEFAULT '',
        PRIMARY KEY (`name`)
      ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='MySQL plugins' |
      +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      [root@server ~]# mysql -e "select count(*) from mysql.plugin"
      +----------+
      | count(*) |
      +----------+
      |        0 |
      +----------+
      [root@server ~]#
      

      How can I fix the warning? Or... is this just a false positive that can safely be ignored?

      Attachments

        Activity

          People

            Unassigned Unassigned
            nunop Nuno
            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.