LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 09-16-2008, 02:54 AM   #1
spettroelica
LQ Newbie
 
Registered: Jul 2007
Posts: 3

Rep: Reputation: 0
MySql - Thread stack overrun


Goodmornig,
I've a database with a stored procedure that insert data into a table.
This stored procedure has worked correctly until this mornig but now it returns following messages:

ERROR 1436 (HY000): Thread stack overrun: 4136 bytes used of a 131072 byte stack, and 131072 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Please, I need help.
 
Old 09-16-2008, 09:07 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,635

Rep: Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965Reputation: 7965
Quote:
Originally Posted by spettroelica View Post
Goodmornig,
I've a database with a stored procedure that insert data into a table.
This stored procedure has worked correctly until this mornig but now it returns following messages:

ERROR 1436 (HY000): Thread stack overrun: 4136 bytes used of a 131072 byte stack, and 131072 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Please, I need help.
What have you done already? What have you tried? Posting an error message without saying what you've already done, makes it more difficult to help you. Also, what version/distro of Linux are you using, and what version of MySQL?

It says the command to use, the 'mysqld -O thread_stack=#', have you done it? Have you tried to run 'repair table <whatever your table name is>' on the table in question? Have you tried to restart MySQL, to see if that helps? Have you checked the logs?
 
Old 09-17-2008, 03:23 AM   #3
spettroelica
LQ Newbie
 
Registered: Jul 2007
Posts: 3

Original Poster
Rep: Reputation: 0
OS version: RedHat Enterprise 5.2
MySql version: 5.0.45

I've stopped and started mysqld service.

I've restarted the server.

I've tried to repair table but I obtain the same error message.

Maybe it is a bug of my mysql release.

I wll try to upgrade mysql to the last stable version.

Thanks.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Command to list stack size of each thread in an application mannw72 Linux - Newbie 1 03-14-2007 06:31 PM
Cedega 5.1/Guild Wars - Thread stack size is too small. Reth Linux - General 0 05-05-2006 09:35 PM
Thread stack size failure jdhedden Programming 0 03-27-2006 08:53 AM
Thread call stack StephenG Linux - General 3 08-24-2005 10:34 PM
thread switch results in kernel stack switch superstition Linux - General 1 05-17-2005 11:48 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:21 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration