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

Unable to configure external locking in MariaDB with --skip-external-locking

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • Documentation
    • None
    • ubuntu0.24.04.1 for Linux on x86_64 ((Ubuntu))

    Description

      Description

      In this documentation: https://mariadb.com/kb/en/server-system-variables/#skip_external_locking,
      the option "--skip-external-locking" can be used to configure mariadb to use
      external locking or not. However, this option takes no effect when specified
      in the "/etc/my.cnf" configuration file.

      How to repeat

      Install MariaDB server:

      sudo apt install mariadb-server
      

      Shut down the MariaDB server:

      sudo systemctl stop mariadb.service
      

      Edit the configuration file "/etc/my.cnf" with the following content:

      [mariadb]
      skip-external-locking=OFF
      

      Such that we don't skip external locking, i.e., we use external locking.

      Restart MariaDB server:

      sudo systemctl start mariadb.service
      

      Export the system variables, and observe that external-locking is still ON:

      sudo mariadb -u root -p -e "SHOW VARIABLES LIKE 'skip_external_locking';"
      

      The root cause seems to be that, in line 3164 of commit 3a06964 for mariadb/server
      repo, "--skip-external-locking" seems to be set as a read-only variable with
      default value of true, making it immutable.

      Suggested fix

      The documentation of mysql server states that the variable can be configured.
      However, the source code says otherwise. A potential fix is to clarify whether
      this option is configurable and reject the invalid value if it does not support
      value assignment.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            kubernetes.operator.study KOS
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.