MySQL Forums
Forum List  »  Stored Procedures

thread stack overrun in MySQL 5.1.33
Posted by: Michael Moench
Date: April 07, 2009 05:10AM

Hi, I've just upgraded from 5.1.31 to 5.1.33 and now I can't run any stored procedures any more.

I created a dummy function "test":
CREATE PROCEDURE `test`.`test` ()
BEGIN
END$$

And each time I execute this function ("call test();") I get the following error:
Thread stack overrun: 4992 bytes used of a 131072 stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Of course I could create a bigger Thread-Stack but I was wondering if there is any info about why MySQL suddenly needs 125K to run an empty stored procedure.

PS: I just saw that the default my.cnf that was created after I installed MySQL via the official Debian package overwrote the thread_stack with 128K which was obviously fine for 5.1.31 but not for 5.1.33 where the default value is 192K.



Edited 1 time(s). Last edit at 04/07/2009 06:26AM by Michael Moench.

Options: ReplyQuote


Subject
Views
Written By
Posted
thread stack overrun in MySQL 5.1.33
29819
April 07, 2009 05:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.