Monday, December 11, 2017

MySQL thread_stack overrun error

When user working with trigger code in MySQL he receives below error.

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


I see that MYSQL have stack value of 128K, which seems to be less and receiving the error

mysql> show variables where `Variable_name` = 'thread_stack';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| thread_stack | 131072 |
+---------------+--------+

We have updated 'thread_stack' in my.cnf to 256k and restart the MySQL and everything working started working fine.

Thanks
Satishbabu Gunukula, Oracle ACE

1 comment: