Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I keep getting this error whether I run my query from the terminal or from within Java.

Anyone has some instructions on how to resolve this?

Thread stack overrun: 5768 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

share|improve this question
Please don't cross post your questions to multiple stackexchange sites.… – Iain Mar 16 '12 at 7:00

You can add it to your my.cnf if it doesn't exist or replace the 128K setting if it does. Also you'll need to restart Mysql for it to take effect since the setting is not dynamic.

thread_stack = 192K

This is usually the default on most modern Linux distros

share|improve this answer
That didn't work. I am using XAMPP so I click stop on the icon then start. My computer is mac osx lion – tribal Mar 16 '12 at 20:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.