Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Thread stack in MySQL

I am obtaining the following error in a MySQL instance:

[ERROR] Failed to write to mysql.slow_log: Thread stack overrun: 5375640560 bytes used of a 262144 byte stack, and 81920 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

My questions are:
1) What does it mean by stack overrun?
2) Why am I getting a stack overrun?
3) If 81920 bytes are only needed, why is there a stack overrun of 5375640560 bytes??

like image 209
Sathyasarathi Gunasekaran Avatar asked Nov 08 '22 17:11

Sathyasarathi Gunasekaran


1 Answers

Thread stack overrun is an inherent and a known issue in multiple versions of aurora (tested in 1.14). From the forums, it has been stated that the issue has been fixed in the new version of Aurora (Haven't tested this yet).

However, for the existing versions; this issue can be resolved by editing option log-output in the parameter groups as: log-output: File

Now, even the slow queries are visible, even in the logs option under monitoring.

like image 102
Sathyasarathi Gunasekaran Avatar answered Dec 07 '22 06:12

Sathyasarathi Gunasekaran