Saturday, September 29, 2012
Monday, September 3, 2012
MySQL: fix : Could not parse relay log event entry
Steps:
- mysql> stop slave;
- mysql> show slave status\G
- copy the values Relay_Master_Log_File, Exec_Master_Log_Pos
- mysql> CHANGE master TO master_log_file=<Relay_Master_Log_File>, master_log_pos=<Exec_Master_Log_Pos>;
- mysql> start slave;
Reference:
- mysql> stop slave;
- mysql> show slave status\G
- copy the values Relay_Master_Log_File, Exec_Master_Log_Pos
- mysql> CHANGE master TO master_log_file=<Relay_Master_Log_File>, master_log_pos=<Exec_Master_Log_Pos>;
- mysql> start slave;
Reference:
- http://www.gustavomejia.com/blog/2008/12/02/1228210800000.html
- http://www.mysqlperformanceblog.com/2008/08/02/troubleshooting-relay-log-corruption-in-mysql/
- https://www.google.com/#hl=en&sugexp=les%3B&gs_nf=1&tok=i8vkKBQNNInCf7ZBcqQgIg&cp=20&gs_id=27&xhr=t&q=could+not+parse+relay+log+event+entry&pf=p&output=search&sclient=psy-ab&oq=could+not+parse+rela&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&fp=77b9feddd4c5d47e&biw=702&bih=461
Subscribe to:
Posts (Atom)