標(biāo)題: mysql IDC之間網(wǎng)絡(luò)不穩(wěn)定導(dǎo)致出錯(cuò)分析，大家有遇到過(guò)沒(méi) [打印本頁(yè)] 作者: helbreathszw 時(shí)間: 2007-12-21 13:13 標(biāo)題: mysql IDC之間網(wǎng)絡(luò)不穩(wěn)定導(dǎo)致出錯(cuò)分析，大家有遇到過(guò)沒(méi) 因?yàn)閿?shù)據(jù)庫(kù)主庫(kù)的IDC和幾個(gè)relay從庫(kù)的IDC之間網(wǎng)絡(luò)不穩(wěn)定或是網(wǎng)絡(luò)嚴(yán)重丟包情況時(shí)有發(fā)生。然后就會(huì)出現(xiàn)sql語(yǔ)句拼裝出錯(cuò)，其他在和主庫(kù)同IDC的從庫(kù)就沒(méi)問(wèn)題，很莫名，我的數(shù)據(jù)庫(kù)版本是Server version: 5.0.41 MySQL Community Server (GPL)，不知道有其他人遇到過(guò)沒(méi)？
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作者: helbreathszw 時(shí)間: 2007-12-21 13:14
環(huán)境是centos4.4,發(fā)生sql拼裝是大概網(wǎng)絡(luò)不穩(wěn)定時(shí)候，會(huì)有1，2次出現(xiàn)，不是頻繁。
[ 本帖最后由 helbreathszw 于 2007-12-21 13:16 編輯 ]作者: helbreathszw 時(shí)間: 2007-12-21 14:27
找到問(wèn)題所在了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.