Chinaunix

标题: mysql错误日志,请达人帮忙解决 [打印本页]

作者: hwxo    时间: 2009-06-23 18:45
标题: mysql错误日志,请达人帮忙解决
最近服务器出现如下错误,不知道为什么
/usr/local/mysql/bin/mysql -V
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.1.34, for pc-linux-gnu (i686) using readline 5.1

090622 18:40:08 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315368,idforeign=1187361,pt=0,dt=1245667236,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090622 20:08:37 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315370,idforeign=1169465,pt=0,dt=1245672543,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090622 22:12:41 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315371,idforeign=1185003,pt=0,dt=1245679990,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090622 22:26:11 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315372,idforeign=1169002,pt=0,dt=1245680800,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090622 22:49:09 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315373,idforeign=1169003,pt=0,dt=1245682178,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090623  9:21:50 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315374,idforeign=1168812,pt=0,dt=1245720144,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090623 11:07:12 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=315376,idforeign=1184954,pt=0,dt=1245726466,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090623 15:35:59 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=1,idforeign=1184708,pt=0,dt=1245742559,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090623 15:56:06 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=3,idforeign=1187601,pt=0,dt=1245743766,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
090623 16:09:51 [Warning] Statement is not safe to log in statement format. Statement: INSERT INTO chargelog SET id=2,idforeign=1187602,pt=0,dt=1245744591,score=3000,source=2,ex0=0,ex1=0,ex2=0,serialno=md5(uuid())
作者: smallfish_xy    时间: 2009-06-24 08:36
Statement is not safe

貌似没啥影响,只是警告而已
作者: agen0502    时间: 2009-06-24 08:53
别被警告吓倒了!  
作者: ruochen    时间: 2009-06-24 10:31
[Warning]
作者: phphp    时间: 2009-06-24 19:37
serialno=md5(uuid())值是不确定的, 用row replication就不报了
作者: hwxo    时间: 2009-06-25 11:12
好的,谢谢各位兄弟
作者: smallfish_xy    时间: 2009-06-25 11:17
原帖由 phphp 于 2009-6-24 19:37 发表
serialno=md5(uuid())值是不确定的, 用row replication就不报了

学习了




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2