Bug #15629 Thread stack overrun in test case 'sp'
Submitted: 9 Dec 2005 11:12 Modified: 12 Dec 2005 17:56
Reporter: Kristian Nielsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S2 (Serious)
Version:clone-5.0.17-build OS:Various
Assigned to: Kent Boortz CPU Architecture:Any

[9 Dec 2005 11:12] Kristian Nielsen
Description:
The test case 'sp' generates thead stack overrun on many platforms:

11356: sp                             [ fail ]
11357: 
11358: Errors are (from /home/mysqldev/aix52-64bit/test/mysql-max-5.0.17-aix5.2-powerpc-64bit/mysql-test/var/log/mysqltest-time) :
11359: mysqltest: At line 1526: query 'call fib(20)' failed: 1436: Thread stack overrun:  115696 bytes used of a 196608 byte stack, and 81920 bytes needed.  Use 'mysqld -O thread_stack=#' to specify a bigger stack.
11360: (the last lines may be the most important ones)

Platforms include AIX 64 bit, solaris-sparc, hpux, OSX, linux-powerpc.

How to repeat:
Run the test case on an affected platform.

Suggested fix:
Lots of 64 bit platforms in there, could be real need for more stack space in that test case, or some other 64-bit problem
[12 Dec 2005 17:56] Kent Boortz
Changed a test in "include/my_pthread.h" to increase thread stat
on all 64 bit platforms, not just IA64.
[12 Dec 2005 23:45] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/33217
[13 Dec 2005 13:38] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/110