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

Using unique option prefix 'ignore_db_dir' is error-prone

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1.17, 10.3.6
    • 10.1
    • None
    • None
    • Red Hat Linux 6.8

    Description

      see the following message in mysqld.log file:

      2016-06-30 17:41:37 140391378425696 [Note] Using unique option prefix 'ignore_db_dir' is error-prone and can break in the future. Please use the full name 'ignore_db_dirs' instead.
      

      when replaced 'ignore_dir_db' in my my.cnf file and restart the DB, the warning message went away. But according to the documentation:

      --ignore-db-dir
      Commandline: --ignore-db-dir=name
      Description: Tells the server that this directory can never be a database. That means two things - firstly it is ignored by the SHOW DATABASES command and INFORMATION_SCHEMA tables. And secondly, USE, CREATE DATABASE and SELECT statements will return an error if the database from the ignored list specified. Use this option several times if you need to ignore more than one directory. To make the list empty set the void value to the option as --ignore-db-dir=. Corresponding read-only variable ignore_db_dirs shows the current list.
      Introduced: MariaDB 5.3.9

      ignore_db_dirs
      Description: Comma-delimited list of directories in the data directory that are not considered as database directories. Set from --ignore-db-dir at startup.
      Scope: Global
      Dynamic: No
      Data Type: string
      Introduced: MariaDB 5.5

      So am I supposed to replace 'ignore_db_dir' with 'ignore_db_dirs' or should I just ignore the warning in the mysqld.log file?

      Thanks,
      Chunli

      Attachments

        Activity

          People

            serg Sergei Golubchik
            cy3572 Chunli Yao
            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.