Bug #40350 | Mysql Master-Slave Replication. Last_Errno: 1064 on Slave. | ||
---|---|---|---|
Submitted: | 27 Oct 2008 15:29 | Modified: | 24 Dec 2008 8:47 |
Reporter: | Suresh Shanmughom | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
Version: | 5.0.45 | OS: | Linux |
Assigned to: | CPU Architecture: | Any | |
Tags: | Replication fails with Errno 1064: You have an error in your SQL syntax |
[27 Oct 2008 15:29]
Suresh Shanmughom
[27 Oct 2008 15:41]
Sveta Smirnova
Thank you for the report. But version 5.0.45 is old and at least 1 important bug which caused error 1064 was fixed since. Please upgrade both master and slave to current version 5.0.67, try with it and if problem still exists provide configuration files for both master and slave and corresponding binary log.
[8 Nov 2008 10:19]
Drew Bertola
I had the same problem on CentOS 5.2 w/ 5.045-log. I pulled a source rpm out of the upcoming fedora 10, did a rebuild, and the bug did not show up again. I have no strong validation that all is well, but this particular use case does not show the same error anymore. BTW, there are several other bug reports that suggest a similar problem (no two the same, but similar nonetheless).
[28 Nov 2008 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[11 Dec 2008 17:33]
Suresh Shanmughom
Upgraded to 5.0.67. Re-initialized replication and it works !!! Thank you.
[24 Dec 2008 8:47]
Valeriy Kravchuk
Closed as not repeatable with 5.0.67.