Manager of pid file quit without updating f failed
Then, you need to verify if all the permissions are intact or not.
Next helpline could be your error log and when you read the error log, you get following details- Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.
/bin/sh -x It appears that the script is working correctly. After intalling rpms for My SQL client/server version 5.1.25 on Centos 5.1 I cannot start the cluster. Once the database folder is chown'ed to the My SQL user, it worked fine. When I later rebooted, the server did not start automatically, and now I can't start it: [[email protected] mysql]# /sbin/service mysql start Starting My SQL.
But mysqld_safe doesn't create the pid file in the first case, and doesn't write anything to the error log. Tim "sudo /bin/sh /etc/init.d/mysql start" indeed is allowing the My SQL to start correctly, whereas "sudo /etc/rc.d/init.d/mysql start" will not start it on my Fedora 9. Error reported is the same as mentioned in this bug . Manager of pid-file quit without updating file.[FAILED] I have tried the 'sudo /bin/sh /etc/init.d/mysql start but error continues. Manager of pid-file quit without updating fi[FAILED] [[email protected] mysql]# There is another server I maintain, that is a heavily used production server, that had mysql 5.1.26 installed on it -- it is a RHEL 4 server however.
141106 Inno DB: Retrying to lock the first data file Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.
Inno DB: Unable to lock ./ibdata1, error: 11 Inno DB: Check that you do not already have another mysqld process Inno DB: using the same Inno DB data or log files.
Description: Failed to install an the client server RPM.
Did some investigation to find out that /etc/rc,d/init.d/mysql restart doesn't work.
141106 Inno DB: Shutdown completed; log sequence number 882 2873506614 141106 [Note] /usr/sbin/mysqld: Shutdown complete 141106 mysqld_safe mysqld from pid file /var/lib/mysql/*******ended 141106 Inno DB: Started; log sequence number 882 2873506614 /usr/sbin/mysqld: File ” not found (Errcode: 2) 141106 [ERROR] Failed to open log (file ”, errno 2) 141106 [ERROR] Could not open log file 141106 [ERROR] Can’t init tc log 141106 [ERROR] Aborting Referring to these logs, it looked to be an issue with the log or data files.
I decided to delete the ib_logfile0 and ib_logfile1 files, and tried restarting My SQL Service once again but it was still throwing the same error.
(Note that once My SQL Service is restarted, these log files shall be created again).
Another area to look for is to rename your file and try restarting the service again. Next, I tried renaming the data file (Be very cautious here- you need to take a backup of the original file, later rename the actual file).