Bug #6022 Stored procedure shutdown problem with self-calling function
Submitted: 11 Oct 2004 12:15 Modified: 23 Oct 2004 14:37
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Bugs System CPU Architecture:Any

[11 Oct 2004 12:15] Peter Gulutzan 
Description:
If I make a function that calls itself, an invocation of the function causes an infinite loop. 
Eventually the server stops with 'Segmentation fault'. But there is still a mysqld process 
running. I can't get rid of it with mysqladmin shutdown. I have to use kill -9. 
 

How to repeat:
mysql> create function fr2 () returns int return fr2(); 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> select fr2(); 
 
... Wait till the server says "Segmentation fault". Try to start server again, which should 
fail. With Linux root, say "ps -A" to observe that there is still a mysqld job running, "kill -9" 
should stop it.
[11 Oct 2004 12:43] MySQL Verification Team 
Verified with 5.0.2-alpha-debug-log
[23 Oct 2004 11:36] Per-Erik Martin 
It now gives the expected stack overrun error when recursing too deep.
(The error was in the function cache, so it never got as far as executing the function.)
[23 Oct 2004 14:37] Per-Erik Martin 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html