日期:2014-05-16  浏览次数:20707 次

mysql主从同步报错

120213 11:53:51 [ERROR] Failed to open log (file './localhost-relay-bin.000018', errno 2)
120213 11:53:51 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
120213 11:53:51 [ERROR] Could not open log file
120213 11:53:59 [ERROR] Failed to open log (file './localhost-relay-bin.000018', errno 2)
120213 11:53:59 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
120213 11:53:59 [ERROR] Could not open log file
120213 12:59:50 [ERROR] Error reading master configuration
120213 13:00:39 [ERROR] Failed to open log (file './localhost-relay-bin.000018', errno 2)
120213 13:00:39 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
120213 13:00:39 [ERROR] Could not open log file
120213 13:00:42 [ERROR] Error reading master configuration
120213 13:00:42 [ERROR] Error reading master configuration
120213 13:00:43 [ERROR] Error reading master configuration
120213 13:00:44 [ERROR] Error reading master configuration
120213 13:00:44 [ERROR] Error reading master configuration
120213 13:00:45 [ERROR] Error reading master configuration
120213 13:00:48 [ERROR] Error reading master configuration
120213 13:13:18 [ERROR] Error reading master configuration
120213 13:14:37 [ERROR] Error reading master configuration
120213 13:14:55 [ERROR] Error reading master configuration
120213 14:45:51 [ERROR] Error reading master configuration
120213 14:46:26 [ERROR] Error reading master configuration
120213 14:46:33 [ERROR] Error reading master configuration
120213 14:46:59 [ERROR] Error reading master configuration
120213 14:47:47 [ERROR] Failed to open log (file './localhost-relay-bin.000018', errno 2)
120213 14:47:47 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4)
120213 14:47:47 [ERROR] Could not open log file
120213 14:48:23 [ERROR] Error reading master configuration
120213 14:48:45 [ERROR] Error reading master configuration
120213 14:56:14 [ERROR] Error reading master configuration


这是日志 现在 start slave 也报错! 这个该怎么解决?

------解决方案--------------------
探讨
引用:

重新change master一下,看看master和slave下面的主从配置文件是的信息是否正常relay-log.info和master的。如果还报错的话看看是不是日志的增长格式有问题。flush一下


reset slave reset master之后 再change master 配置relay-log.info和master都是……