Thursday, October 24, 2013

Starting MySQL...The server quit without updating PID file [FAILED]/mysqld.pid)

Error 1:


Starting MySQL...The server quit without updating PID file [FAILED]/mysqld.pid)

Check Mysql logfile


131014 14:12:53 [ERROR] Plugin 'audit_log' init function returned error.

131014 14:12:53 [ERROR] Plugin 'audit_log' registration as a AUDIT failed.

131014 14:12:53 [ERROR] Failed to initialize plugins.

131014 14:12:53 [ERROR] Aborting


Workaround:

rename or remove audit.log files and restart mysql services


Ref:
http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-logging-control.html



Error 2:


InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
131029 18:33:09 [ERROR] Plugin 'InnoDB' init function returned error.
131029 18:33:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131029 18:33:09 [ERROR] Unknown/unsupported storage engine: InnoDB
131029 18:33:09 [ERROR] Aborting

Workaround :

remove ib_logfile1,ib_logfile0 files and start mysql services

 

No comments: