Error 1436 - Thread Stack Overflow

I am getting the following error when trying to run any stored procedure:

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

The bytes used number varies depending on the procedure, but rest is
always the same.

But the message does not seem to make any sense. The used bytes, and the
bytes required are less than the reported stack size. Also the reported
stack size seems wrong. I am running on a 64 bit machine, so the default
size should be something in the order 264000, or so I understand.

Any guidance will be greatly appreciated.

Thanks for your time.

William.

On 14-01-2012 22:53, William Colls wrote:

I am getting the following error when trying to run any stored procedure:

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

The bytes used number varies depending on the procedure, but rest is
always the same.

But the message does not seem to make any sense. The used bytes, and the
bytes required are less than the reported stack size. Also the reported
stack size seems wrong. I am running on a 64 bit machine, so the default
size should be something in the order 264000, or so I understand.

Any guidance will be greatly appreciated.

Thanks for your time.

William.

a google for: "ERROR 1436 (HY000): Thread stack overrun" revealed:

http://bugs.mysql.com/bug.php?id=56744

Maybe you should try the thing a the bottom of that page

If that doesn't help, please provide more information, i.e. the version
of MySQL you are using. (because the bug is about version 5.5.x)

--
Luuk

On 14-01-2012 22:53, William Colls wrote:

I am getting the following error when trying to run any stored procedure:

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

The bytes used number varies depending on the procedure, but rest is
always the same.

But the message does not seem to make any sense. The used bytes, and the
bytes required are less than the reported stack size. Also the reported
stack size seems wrong. I am running on a 64 bit machine, so the default
size should be something in the order 264000, or so I understand.

Any guidance will be greatly appreciated.

Thanks for your time.

William.

or http://bugs.mysql.com/bug.php?id=31288
but that a very old one

--
Luuk

William Colls <william.colls (AT) rogers (DOT) com> wrote:

I am getting the following error when trying to run any stored procedure:

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

But the message does not seem to make any sense. The used bytes, and the
bytes required are less than the reported stack size.

Maybe I cannot add any more. Or you can't. But last time I tried,
11456 + 128000 was indeed bigger than 131072.

Also the reported
stack size seems wrong. I am running on a 64 bit machine, so the default
size should be something in the order 264000, or so I understand.

Any guidance will be greatly appreciated.

SHOW GLOBAL VARIABLES

will show you (amongst other settings) the effective thread stack size
used by your instance of the MySQL server. Maybe you run with a my.cnf
from stone age, that ties stack size to 128K?

At least we'd need to know which version you're running. 5.5.5-m3 for
which Luuk found that bug report, is not fit for production anyway.


XL

William Colls wrote:

I am getting the following error when trying to run any stored procedure:

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

The bytes used number varies depending on the procedure, but rest is
always the same.

But the message does not seem to make any sense. The used bytes, and the
bytes required are less than the reported stack size.

131'072 bytes total
− 11'456 bytes used
− 128'000 bytes needed
----------------------
= −8'384 bytes

Hence the error message.

Also the reported stack size seems wrong. I am running on a 64 bit
machine, so the default size should be something in the order 264000,
or so I understand.

AIUI, it should be 262'144 bytes (256 KiB) if you are running MySQL on a 64-
bit machine with a 64-bit kernel (and a MySQL version compiled for that
kernel).

<http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html>

Any guidance will be greatly appreciated.

Try analyzing the causes instead of the symptoms. Does your stored
procedure recurse too often? Are you declaring unnecessary parameters
or variables, or parameters or variables of unnecessary size?

--
PointedEars

Please do not Cc: me. / Bitte keine Kopien per E-Mail.