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