Posted by: prajapatinilesh | July 9, 2012

mysql store procedure is not working with new version of mysql 5.1.42-community-log

When we run stored procedure ” getTestspr ” or ” insTestspr ” in mysql query browser we  got the error  –
” Thread stack overrun:  5904 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use ‘mysqld -O thread_stack=#’ to specify a bigger stack. ”

solution :  open the mysql config file.  my.cnf

change the setting of thread_stack=128K  to 256K.

restart the mysql server. and now run the mysql spr.

Thanks,  Nilesh Prajapati.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: