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

mysqld: unknown option '--disable-sync-sys'

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • N/A
    • Documentation
    • None

    Description

      I have been trying to turn off syncing to disk in my testing-only setup and found out this is supposed to be done with the --disable-sync-sys option. As far as I can tell this was introduced a long time ago and specifically to fit this case (see Revision #2891.1.5).

      So if this was not deprecated/removed somehow (which I would hope would be mentioned in the docs) I think this is an error.

      I already asked in the Docker image repository whether this could be due to how the image is prepared, but they assured me, that they do not disable any such settings.

      docker run --rm -e MYSQL_ROOT_PASSWORD=my-secret-pw mariadb:10.3 --disable-sync-sys
       
      ERROR: mysqld failed while attempting to check config
      command was: "mysqld --disable-sync-sys --verbose --help --log-bin-index=/tmp/tmp.tk2GTl2LRR"
       
      2019-02-19 12:37:29 0 [Note] Plugin 'FEEDBACK' is disabled.
      2019-02-19 12:37:29 0 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
      2019-02-19 12:37:29 0 [ERROR] mysqld: unknown option '--disable-sync-sys'
      2019-02-19 12:37:29 0 [ERROR] Aborting
      

      I have tested with older versions as well but the oldest I found is 5.5 and it is not working there either:

      docker run --rm -e MYSQL_ROOT_PASSWORD=my-secret-pw mariadb:5.5 --disable-sync-sys
       
      ERROR: mysqld failed while attempting to check config
      command was: "mysqld --disable-sync-sys --verbose --help --log-bin-index=/tmp/tmp.XtPsrUyUkY"
       
      190221 15:13:01 [Note] Plugin 'FEEDBACK' is disabled.
      190221 15:13:01 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
      190221 15:13:01 [ERROR] mysqld: unknown option '--disable-sync-sys'
      190221 15:13:01 [ERROR] Aborting
      

      Using --sync-sys=0 is not working either.

      I have also found out that more of the debug options are not recognized in the same manner.

      When searching around here I found a lot of issues reported around 2010 were using these options, but then it stopped.

      Commit that introduced these options: https://github.com/MariaDB/server/commit/12648015b322e885923f87d919c07529423a0eca

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            VasekPurchart Vašek Purchart
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.