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??
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With