mysql主从同步报错

virginpirate 2012-02-13 02:57:12

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 也报错！这个该怎么解决？

...全文

270 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

caipengai 2012-02-22

打赏
举报

权限问题，查看一下复制用户的权限

coky20009 2012-02-14

打赏
举报

[Quote=引用 3 楼 virginpirate 的回复:]
引用 1 楼 coky20009 的回复:

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

reset slave reset master之后再change master 配置relay-log.info和master都是……
[/Quote]
都是空文件就说明没有change成功啊，他会把配置写到文件里面的。你把原来的文件删了再change一下。
仔细检查下配置项。看看有没有那个地方的配置出错了。

rucypli 2012-02-13

打赏
举报

master salve上serverid设置得是什么

virginpirate 2012-02-13

打赏
举报

[Quote=引用 1 楼 coky20009 的回复:]

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

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

virginpirate 2012-02-13

打赏
举报

[Quote=引用 1 楼 coky20009 的回复:]

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

change之后 master配置不变

coky20009 2012-02-13