Even thought the error I see is: The server quit without u[FAILED]PID file - I think the error is supposed to be: The server quit without updating PID file (however this tends to be a different problem and you should look in the error log)
I created some new VMs using VMWare fusion and I kept getting this error after installing Percona Server 5.6 and adding in a custom my.cnf file.
The error is vague an doesn't provide any context. I am running CentOS 6.8.
[root@vmware mysql]# /etc/init.d/mysql start
Starting MySQL (Percona Server)...The server quit without u[FAILED]PID file (/var/run/mysqld/mysqld.pid).
I saw this in the error log file:
160826 03:47:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
The error log also mentioned that multiple instances of MySQL might be running. I did find multiple instances of MySQL running but every time I killed them and tried to re-start I would get the problem again.
I didn't see an error code in the log file but I thought it might be a permissions problem after reading on this site:
https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/6431-percona-server-not-starting
The my.cnf file that came with the install and which works fine is very simple like this:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Since I couldn't figure out exactly what the problem was was with my settings, I went through each section and each line until mysql would start with my settings.
I had this in my.cnf:
lc_messages_dir = /usr/share/mysql
When I commented that out, MySQL started fine. I still don't know what it is with that dir that it doesn't like. After commenting it, I checked to see what Percona Server was using:
mysql> show global variables like '%lc_messages_dir%';
+-----------------+----------------------------+
| Variable_name | Value |
+-----------------+----------------------------+
| lc_messages_dir | /usr/share/percona-server/ |
+-----------------+----------------------------+
I've had this same problem but with other settings and I've followed the same approach my commenting out lines until I've figured out what the offending my.cnf entry is.
No comments:
Post a Comment