MySQL Forums
Forum List  »  Stored Procedures

Thread stack size not changing
Posted by: Michael Peremsky
Date: March 18, 2014 10:10AM

I am calling a stored procedure that has 2 parameters that are TEXT fields. When I try to execute the SP from my code I get the error message

 Thread stack overrun:  7984 bytes used of a 131072 byte stack, and 128000 bytes needed.


If I run the query "SHOW GLOBAL VARIABLES LIKE '%stack%'" I get the following (128K)

thread_stack 131072

If I add a thread_stack entry to the /etc/my.cnf file (I ran strace mysql and saw no other cnf files being used) and restart mysql (service mysqld restart) and rerun the query above, it returns the same value.


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
thread_stack=500K

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


At this point I have spent at least an hour trying different ways to get the thread_stack size to change but with no luck. What am I missing?

TIA

Options: ReplyQuote


Subject
Views
Written By
Posted
Thread stack size not changing
11101
March 18, 2014 10: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.