[Maria-discuss] pid file could not be found
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 This email message and any attachments are confidential and may be privileged. If you are not the intended recipient, please notify us immediately and destroy the original transmittal. You are hereby notified that any review, copying or distribution of it is strictly prohibited. Thank you for your cooperation. Header information contained in E-mails to and from the company are monitored for operational reasons in accordance with swiss data protection act.
Hi Sandro, On Fri, Nov 14, 2014 at 3:48 AM, Roth, Sandro < Sandro.Roth@zurich-airport.com> wrote:
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?
This issue has been reported here : https://mariadb.atlassian.net/browse/MDEV-6961 Until its fixed, you can using mysqladmin tool directly to ping or stop mysqld. Best, Nirbhay
Thanks
Sandro
This email message and any attachments are confidential and may be privileged. If you are not the intended recipient, please notify us immediately and destroy the original transmittal. You are hereby notified that any review, copying or distribution of it is strictly prohibited. Thank you for your cooperation.
Header information contained in E-mails to and from the company are monitored for operational reasons in accordance with swiss data protection act.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Nirbhay Choubey
-
Roth, Sandro