Friday, September 2, 2016

Percona Server Error - The server quit without u[FAILED]PID file

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