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

MariaDB 10.5: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11

Details

    Description

      Hello,

      I'm testing MariaDB 10.5 on a new server.
      I have updated the "my.cnf" file, but haven't migrated any databases yet. It's a fresh install.

      MariaDB starts without any errors or warnings.

      > mysql.log:2021-02-05 6:28:12 0 [Note] /usr/sbin/mariadbd: ready for connections.
      > mysql.log:Version: '10.5.8-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server

      However, while MariaDB is running, I run:

      > mysqld --verbose --help 1>/dev/null

      I get:

      > 2021-02-05 6:31:51 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 0 seconds
      > 2021-02-05 6:31:51 0 [ERROR] Plugin 'Aria' init function returned error.
      > 2021-02-05 6:31:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
      > 2021-02-05 6:31:51 0 [Warning] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some options may be missing from the help text

      Any ideas why? This doesn't happen with MariaDB 10.4.

      > # ll /var/lib/mysql
      > total 5267520
      > drwxr-xr-x 5 mysql mysql 4096 2021-02-05 06:31 .
      > drwxr-xr-x. 38 root root 4096 2021-02-04 08:24 ..
      > rw-rw--- 1 mysql mysql 24576 2021-02-05 06:28 aria_log.00000001
      > rw-rw--- 1 mysql mysql 52 2021-02-05 06:28 aria_log_control
      > ...

      Thank you

      Attachments

        Activity

          danblack Daniel Black added a comment -

          This occurs in 10.5 because of https://github.com/MariaDB/server/commit/8eba777c2bbad7721c818936a3a0ced3b2fcd59c

          monty is this acceptable - https://github.com/MariaDB/server/compare/10.5...bb-10.5-danielblack-MDEV-24788-mysqld--help-cannot-lock-aria-control?expand=1

          opt_help implies aria_readonly which in ha_maria_init means no recovery is done. In this case is it acceptable to not exclusively lock the control file?

          danblack Daniel Black added a comment - This occurs in 10.5 because of https://github.com/MariaDB/server/commit/8eba777c2bbad7721c818936a3a0ced3b2fcd59c monty is this acceptable - https://github.com/MariaDB/server/compare/10.5...bb-10.5-danielblack-MDEV-24788-mysqld--help-cannot-lock-aria-control?expand=1 opt_help implies aria_readonly which in ha_maria_init means no recovery is done. In this case is it acceptable to not exclusively lock the control file?

          People

            danblack Daniel Black
            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.