mysql不断报错

wangc0727

mysql错误日志不断的报错
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2030596'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1221957'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2340202'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2113223'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1465090'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2375480'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='913938'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1190391'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1115575'  limit 1
100810 15:06:17 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2377993'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2118499'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1353972'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='1494045'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='2113775'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='681937'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='91568'  limit 1
100810 15:06:18 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='908609'  limit 1
100810 15:06:19 [Warning] Statement may not be safe to log in statement format. Statement: update cdb_roup set isclose=1 where tid='


请教如何解决

dongfengshemaer

如果不违反业务逻辑，把语句里面的 limit 1去掉看看。

dongfengshemaer

如果不违反业务逻辑，把语句里面的 limit 1去掉看看。

chylli

回复 1# wangc0727


    这个是binlog的格式是statement引起的. statement对某些sql是不安全的,比如有自动生成uuid的语句,再比如lz这个语句可能是limit 1可能会由于 master slave的某些原因导致更新的不是同一个语句 (比如mysql的版本不一致而造成第一条语句不同). 将binlog格式改成 row或者 mixed:

http://dev.mysql.com/doc/refman/5.1/en/binary-log-setting.html

dongfengshemaer

回复 4# chylli


    楼上的回答是正确的。