-
Member
MySQL Error Linux Debian
I had a bug with the mysql service on my dedicated with Linux Debian 8.7.
The error started in the morning when it was not connected using SQLyog to the database.
After that I tried to start the service from the console but it gives me the following error:
- MySQL works perfectly for 4 days since its installation.
uSrOx9Ta.jpg
9PBZjbgV.jpg
NEyvysXe.jpg
8rmJMJ1c.jpg
I also have a vps in which MySQL works normally for almost 2 months.
PLSS!! Help me to solve the problem, I really appreciate that
-
Code:
The /var/lib/mysql/aria_log_control file is open by another process and consequently, mysqld fails to start.
Check who/what is currently has the file open with:
Code:
lsof `/var/lib/mysql/aria_log_control`
It should list the process(es) that has it open.
Code:
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 1506 mysql 10uW REG 253,1 52 263948 /var/lib/mysql/aria_log_control
If the process definitely shouldn't be running, then shut it down with:
Code:
sudo kill -SIGTERM <PID>
If that fails:
Code:
sudo kill -SIGKILL <PID>
Or reboot.
This and other suggestions here: opensuse - Can't start mysql service - Unix & Linux Stack Exchange
-
Post Thanks / Like - 1 Thanks
Peronomejodan (1 members gave Thanks to stoneharry for this useful post)
-
Member
This not work for me
-
Member
Help me pls i don't know how to solve this problem
-
Member
Originally Posted by
Peronomejodan
Help me pls i don't know how to solve this problem
Can you try running the following command;
Code:
mysqld_safe --log-error=/var/log/mysql.err
If the system cannot find mysqld_safe try prepending with /usr/bin/.
Copy-paste the results of /var/log/mysql.err to this thread so that we can see the problem.
-
Post Thanks / Like - 1 Thanks
stoneharry (1 members gave Thanks to Mimmil for this useful post)