replication 1064 error on slave side

Steven1981發表於2010-12-06
ErrorIDE

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/703656/viewspace-1042674/，如需轉載，請註明出處，否則將追究法律責任。

相關文章