Sunday, October 27, 2013

Resolved : The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

Starting mysql 5.6 the server generates a true UUID in addition to the –server-id supplied by the user.
 So remove auto.cnf file under data directory then restart mysql server after that new auto.cnf file will be created .

Error:


  Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

 Workaroud:

*Remove auto.cnf file under data dir
*Restart mysql server



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

 

ERROR 1123 (HY000): Can't initialize function 'audit_log'; Plugin initialization function failed

Error:

Master >install plugin audit_log soname 'audit_log.so';
ERROR 1123 (HY000): Can't initialize function 'audit_log'; Plugin initialization function failed.

Workaround:

Add below lines on my.cnf file and restart mysql services

plugin-load=audit_log.so
audit-log=FORCE_PLUS_PERMANENT