Hi there
I’m having a weird problem after a fresh installation of RHEL6 and MariaDB:
[root@server ~]# yum install MariaDB-10.1.1-centos6-x86_64-server.rpm MariaDB-10.1.1-centos6-x86_64-client.rpm MariaDB-10.1.1-centos6-x86_64-compat.rpm MariaDB-10.1.1-centos6-x86_64-common.rpm
[…]
[root@server ~]# /etc/init.d/mysql status
MySQL is not running [FAILED]
[root@server ~]# /etc/init.d/mysql start
Starting MySQL. [ OK ]
[root@server ~]# /etc/init.d/mysql status
MySQL is running but PID file could not be found [FAILED]
[root@spch9140 ~]# ls -al /var/lib/mysql/server.local-recover.pid
-rw-rw---- 1 mysql mysql 6 Nov 14 07:41 /var/lib/mysql/server.local-recover.pid
[root@server ~]# more /var/lib/mysql/server.local-recover.pid
25071
[root@server ~]# ps aux | grep 25071
mysql 25071 0.0 2.9 795548 116980 pts/0 Sl 07:41 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.local.err --pid-file=/var/lib/mysql/server.local.pid
--wsrep_recover --log_error=/var/lib/mysql/wsrep_recovery.U7vwNv --pid-file=/var/lib/mysql/server.local-recover.pid
root 27665 0.0 0.0 103256 856 pts/0 S+ 08:30 0:00 grep 25071
Also tried version 10.0.14, same issue..
Putting ‘pid-file’ option into /etc/my.cnf.d/server.cnf doesn’t help either :(
Anyone seen this too or have a suggestion?
Thanks
Sandro