免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2472 | 回复: 2

mysql IDC之间网络不稳定导致出错分析,大家有遇到过没 [复制链接]

论坛徽章:
0
发表于 2007-12-21 13:13 |显示全部楼层
因为数据库主库的IDC和几个relay从库的IDC之间网络不稳定或是网络严重丢包情况时有发生。然后就会出现sql语句拼装出错,其他在和主库同IDC的从库就没问题,很莫名,我的数据库版本是Server version: 5.0.41 MySQL Community Server (GPL),不知道有其他人遇到过没?


071218  5:52:09 [ERROR] Slave: Error 'You have an error in your SQL syntax; check the manua
l that corresponds to your MySQL server version for the right syntax to use near 'UPDATeek_
count=read_week_count+2, read_month_count=read_month_count+2 WHERE book' at line 1' on quer
y. Default database: 'vipbook'. Query: 'UPDATeek_count=read_week_count+2, read_month_count=
read_month_count+2 WHERE book_id=43113�', Error_code: 1064

论坛徽章:
0
发表于 2007-12-21 13:14 |显示全部楼层
环境是centos4.4,发生sql拼装是大概网络不稳定时候,会有1,2次出现,不是频繁。

[ 本帖最后由 helbreathszw 于 2007-12-21 13:16 编辑 ]

论坛徽章:
0
发表于 2007-12-21 14:27 |显示全部楼层
找到问题所在了http://bugs.mysql.com/bug.php?id=26489
For the general issue of corruption of data in transit see bug #25737. We know that TCP's
CRC checks aren't good enough to protect the integrity of the data being transferred over
replication links and that corruption can happen and produce changed characters even with
a valid CRC.

This specific problem may not be due to that, unless the ending of the logs coincides with
a broken connection, which may have a period of bad connectivity and errors preceding it.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP