MySQL Forums
Forum List  »  MySQL Administrator

mysql replication 1064 error
Posted by: laalesh G
Date: September 20, 2011 12:48AM

Hi,

Am facing the below error at a regular interval that my slave IO_THREAD is unable to read my binary log correctly.
In the slave status it shows the below error

Exec_Master_Log_Pos: 77340932
Last_SQL_Errno: 1064
Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 1' on query. Default database: 'player'. Query: 'delete from messaging.inbox where promoid = 214 a'

By this error it seems there is some data in encrypted form.
If I extract the binary log in master ans see the particular position query, nothing is wrong in the query.

then why my IO_THREAD is unable to read some data in master?
And what method IO_THREAD follow in transferring the data?

Note: MySQL Version is same in both master and slave.


Thanks,
Laalesh

Options: ReplyQuote


Subject
Written By
Posted
mysql replication 1064 error
September 20, 2011 12:48AM
September 20, 2011 03:27AM
September 20, 2011 03:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.