LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   MySql - Thread stack overrun (https://www.linuxquestions.org/questions/linux-server-73/mysql-thread-stack-overrun-670211/)

spettroelica 09-16-2008 02:54 AM

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.

TB0ne 09-16-2008 09:07 AM

Quote:

Originally Posted by spettroelica (Post 3281742)
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?

spettroelica 09-17-2008 03:23 AM

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.


All times are GMT -5. The time now is 04:48 AM.