Bug #19589 show procedure status crashes mysqld

• Submitted: 7 May 2006 0:03
• Modified: 8 Jun 2006 23:00
• Reporter: Max Matson
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.21
• OS: MacOS (Mac OS X 10.4.6)
• CPU Architecture: Any

[7 May 2006 0:03] Max Matson

Description:
show procedure status crashes mysqld. The log entry in the host.err file states mysqld got signal 10 and prints memory allocation parameters. All parameters are completely reasonable and total memory allocated is not a problem.

Found this problem while using mysqldump to backup databases with the -R option. I've tested for the problem against 5.0.18 and 5.0.21. I'm not sure if the databases actually have any stored procedures or not, but even if they don't, it shouldn't crash mysqld

How to repeat:
show procedure status; 
-or-
show procedure status where Db = 'any db';

[8 May 2006 16:34] Hartmut Holzgraefe

not reproduceable with 5.0.21 on linux ...

[8 May 2006 16:45] Max Matson

Just tried on a different box with a fresh install of 5.0.18 (should have done that before posting) and no crash result. Must be related to configuration and / or data. I'll investigate more and update with more precise reproducable steps.

Thanks!

[8 May 2006 23:00] MySQL Verification Team

Thank you for the last information. Could you please open this bug
again if you find a repeatable test case.
Thanks in advance.

[9 Jun 2006 23: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".