Bug #60121 | MySQL server crashes when updating a VARCHAR field to contain the string "%s" | ||
---|---|---|---|
Submitted: | 14 Feb 2011 15:34 | Modified: | 15 Feb 2011 15:32 |
Reporter: | Aaron Kennedy | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.31 | OS: | Linux (Ubuntu 9.04) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash, trigger, UPDATE |
[14 Feb 2011 15:34]
Aaron Kennedy
[14 Feb 2011 15:40]
MySQL Verification Team
Could you please try latest released version. I couldn't repeat with today source tree.
[14 Feb 2011 16:06]
Aaron Kennedy
Miguel, Did you try this in 5.5.x or 5.1.x?
[14 Feb 2011 16:10]
MySQL Verification Team
I tried with 5.1.56.
[14 Feb 2011 18:00]
Aaron Kennedy
I installed 5.1.55 from the TAR package and tried this again. This time the server does not crash but produces an error: ERROR 1436 (HY000): Thread stack overrun: 6464 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.
[14 Feb 2011 19:13]
Aaron Kennedy
I increased the thread stack to 256K and re-tested, and the bug is no longer present.
[15 Feb 2011 4:27]
Valeriy Kravchuk
So, can we assume there is no bug (just a need to increase stack size, as requested by server) with 5.1.55?
[15 Feb 2011 15:12]
Aaron Kennedy
Correct, as of 5.1.55 the "%s" crash no longer happens.
[15 Feb 2011 15:32]
Valeriy Kravchuk
Not repeatable with recent version, 5.1.55.