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

Be more helpful on unknown parameter messages

    XMLWordPrintable

Details

    Description

      A user just had a case where they were getting

      [ERROR] /usr/libexec/mysqld: unknown variable 'innobdb_lock_wait_timeout=1000'

      due to the rather hard to spot extra b in innobdb.

      Many other tools check such unknown values against a list of known one, e.g. comparing them via metrics like the Levenshtein distance, to add suggestions like:

      unknown variable 'innobdb_lock_wait_timeout', did you mean 'innodb_lock_wait_timeout'?

      I think this would be a great help and easy win.

      (PS: I'm a bit biased about the Levenshtein distance as it was a key part of my original diploma thesis, and as I'm also responsible for having it in the PHP core)

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            hholzgra Hartmut Holzgraefe
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 2.5h
                2.5h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.