问题:
主从同步不了;但是
Slave_IO_Running: Yes
Slave_SQL_Running: Yes主从一致
查看从日志显示如下错误:
111201 16:26:12 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
111201 16:26:12 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000048' position 432318024
111201 16:26:12 [Note] Slave: connected to master 'emuser@221.10.1.60:3306',replication resumed in log 'mysql-bin.000048' at position 432318024
111202 20:19:20 [ERROR] Slave: Error 'Column 'refresh' cannot be null' on query. Default database: 'cdn_view'. Query: 'insert into DNS_ALL values (NULL,'eqifa.com','pvyigao','A','210.51.100.11',360,'CNC',NULL,NULL,NULL,NULL,NULL,'2011092000','root.eqifa.com.','ns.esoso.com.',0)', Error_code: 1048
111202 20:19:20 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000049' position 263269149
111209 9:32:41 [Note] /usr/libexec/mysqld: Normal shutdown
解决方法:
从日志上看可能是插入数据,从的没有正常同步;或者主的插入记录错误。
首先在从上slave stop;然后slave start;问题依旧
最后按照笨方法重新做了下;最终还是解决问题了。
操作步骤如下:
1、从停止复制,主锁表
slave stop;
flush tables with read lock;
记录主的Position
2、rsync库文件到从
3、从手动执行同步
change master to master_host='221.122.127.60',master_user='emuser',master_password='emaradmin', master_log_file='mysql-bin.000056', master_log_pos=323979991;
4、启动从复制
slave start
5、主解锁
unlock tables;
6、主插入记录;查看从是否有新记录。
mysql主从同步故障
原创
©著作权归作者所有:来自51CTO博客作者5iqiong的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:awk案例更新
下一篇:<一>awk变量和运算符
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
MySQL主从同步延迟解决
mysql主从同步延迟解决
MySQL 主从同步 mysql主从同步 -
mysql主从同步搭建和故障排除
mysql主从同步搭建和故障排除
mysql 主从 同步搭建 作用 -
故障案例:主从同步报错MySQL server UUIDs
故障案例:主从同步报错MySQL server UUIDs
故障案例:主从同步报错MySQL ser