Why can't MYSQL access the aria control file?

Linode Staff

[ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11.

3 Replies

The error message you posted seems to point to the fact that another application currently has access to the file /var/lib/mysql/aria_log_control. There are a few steps that may help you solve this issue.

First, I recommend checking your MYSQL logs for more information as to what this other application could be. They are typically found in the location below, and can be viewed with the cat command.

cat /var/log/mysql

You can also try running the below commands to see which processes are running with the word mysql. The second command will list the open file specified.

ps -ef | grep mysqld
lsof '/var/lib/mysql/aria_log_control'

If the process occupying aria_log_control should not be running. You can kill the process with the command below.

sudo kill -SIGTERM <PID>

If that doesn't work, there may be a permissions issue with this file. You will want to make sure MYSQL has permission to use the file. You can change ownership to it with the below commands.

chown -R mysql:mysql /var/lib/mysql

This StackOverflow forum post goes more into the above error troubleshooting tips.

I hope this information has been helpful!

Here's what worked for me. This may be an issue with Debian 10 / MariaDB or just the Linode config.

  • apt-get to install mariadb
  • reboot the linode
  • /etc/init.d/mysql stop

Now run mysql_install_db.

Worked from there.

You write:

  • apt-get to install mariadb
  • reboot the linode
  • /etc/init.d/mysql stop

If you

  • apt-get uninstall mysql

before this sequence of events, you can skip step 3.

-- sw


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct