Bug #25531 | MySQL crashes very soon after starting slave | ||
---|---|---|---|
Submitted: | 10 Jan 2007 18:53 | Modified: | 3 Apr 2008 0:18 |
Reporter: | Baron Schwartz (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.26-standard-log | OS: | Linux (Gentoo) |
Assigned to: | CPU Architecture: | Any | |
Tags: | qc |
[10 Jan 2007 18:53]
Baron Schwartz
[10 Jan 2007 18:59]
Baron Schwartz
Contents of MySQL Error Log
Attachment: mysqld-err.txt (text/plain), 3.21 KiB.
[10 Jan 2007 19:00]
Baron Schwartz
Resolved stack trace of the crash.
Attachment: resolved-stack-trace.txt (text/plain), 1.09 KiB.
[11 Jan 2007 9:55]
Sveta Smirnova
Thank you for the report. Please verify if your case is same as bug #22504 (check sql_mode) and inform us about results
[11 Jan 2007 14:16]
John Miller
(John on behalf of Baron) That does not appear to be the same bug. There is space between the INTO and TABLE in our log. Also ours resulted in a hard crash of the slave rather than simply a syntax error causing the slave thread to stop. Thanks.
[15 Jan 2007 11:33]
Sveta Smirnova
Please try using current 5.0.33 server accessible from http://dev.mysql.com/downloads/mysql/5.0.html (if you want to use binary packages, wait when binaries for your platform will be accessible from the mirror sites)
[19 Jan 2007 21:15]
Baron Schwartz
There are no official MySQL-supplied binaries available for 5.0.33 (and we have also heard about some InnoDB bugs that would cause us problems). We switched to the officially supplied binaries specifically so we could eliminate our compiler as the source of the problem, because submitting a bug report against something we built ourself makes it harder for you to find the problem. This problem has been happening since 5.0.0x, it is not new, but we only recently switched to official binaries. Should we return to compiling the server ourself (Gentoo) or wait until there is an official binary for the community edition?
[25 Jan 2007 14:39]
Sveta Smirnova
Sorry for delay: I was out of computer. Please, compile from sources.
[26 Feb 2007 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".
[3 Apr 2007 16:40]
Baron Schwartz
I can't duplicate this bug reliably. In fact I have recently gotten replication running more smoothly, and so I rarely stop/start slaves anymore.
[4 Apr 2007 8:21]
Sveta Smirnova
Thank you for the feedback. You can't duplicate problem with new version?
[4 Apr 2007 12:51]
Baron Schwartz
By "I can't duplicate" I mean I haven't seen it happen. This is with Gentoo's latest source, but I can't duplicate it reliably with the old MySQL binary version either. It only happened occasionally, but when it did happen, it seemed to be caused by issuing STOP SLAVE and then START SLAVE again. I don't have a machine I want to repeatedly do that to, just to try to make it crash :-)
[2 Apr 2008 21:21]
MySQL Verification Team
Did you have experienced the behavior reported since your last comment?. Thanks in advance.
[2 Apr 2008 21:39]
Baron Schwartz
No, I was not able to repeat this anymore.
[3 Apr 2008 0:18]
MySQL Verification Team
Thank you for the feedback. I am closing this bug according your last comment.