ITPub博客

首页 > 应用开发 > IT综合 > replication 1064 error on slave side

replication 1064 error on slave side

原创 IT综合 作者:Steven1981 时间:2010-12-06 16:49:03 0 删除 编辑

Last_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ver
sion for the right syntax to use near

### MYSQL 5.0.68 @ RHEL 5u3

[@more@]


今天收到SLAVE SQL报警 :
show slave status G
=====================================
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 172.18.119.2
Master_User: replicator
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.004056
Read_Master_Log_Pos: 538231309
Relay_Log_File: slave-relay.010100
Relay_Log_Pos: 4966774
Relay_Master_Log_File: mysql-bin.004056
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1064
Last_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ver
sion for the right syntax to use near ''cntaobao喵了个咪的蓝灊─? at line 1' on query. Default database: 'offmsg'. Query: 'update im_o
ffline_msg set gmt_modified='2010-12-06 00:37:44',count=1975,data='讇V猈x滌缴庪J???﹣Q@倮澦嗀HじQ戈R叼劋
Rr粘螿/`?糗C懵僙??CM<珌5?Au?珍賧N??xv?n#V瑘X?啁'?躏

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/703656/viewspace-1042674/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    127
  • 访问量
    837865