I encountered this weird SQL error / anomaly.
I have 5 replication slaves with one master. On the master, an insert statement was issued and it was replicated to all of the slaves except to one which I will call weird_slave. The weird_slave (MyISAM) complained that there was some SQL syntax error. I checked the insert statement and it looks pretty simple.
Also, the weird_slave has already been running for more than a couple of months now and it has received some variation of the insert statement.
I was thinking that the table could be corrupt and issued a check table and everything returned okay.
So, the question is why would the weird_slave complain about an SQL syntax error while the other slaves were okay with it. Sadly, I could not reproduce the error again. Also, I've tried to re-insert the same SQL statement on the weird_slave again and again and it was accepting it without complaining.