主从数据库同步错误，谢谢！

关系户

mysql数据库版本4.1.7 ，做了个主从同步，现在总在从库的错误日志里发现这种错误，错误如下：
080630 15:50:26 [ERROR] Slave: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'update tables set Myname='lwjwgn' where NameBak='zhongguo' and  Pass='yjbgso'', Error_code: 1053

想请教大家这种错误是什么原因造成的！谢谢各位了！

yueliangdao0608

MASTER 是不是掉过一次？

关系户

对，出现这个错误的时候都会有一次尝试与主数据库连接
080630 15:49:26 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'updatelog.000265' position 58338706
080630 15:49:26 [ERROR] Slave I/O thread: error reconnecting to master 'replicate@202.10.67.9:3306': Error: 'Lost connection to MySQL server during query'  errno: 2013  retry-time: 60  retries: 86400
有没有相关配置杜绝这样的错误发生

[ 本帖最后由 关系户 于 2008-7-1 11:09 编辑 ]

yueliangdao0608

建议还是开启sync-binlog=1吧。