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

5 comments:

  1. افضل شركات منطقة مكة المكرمة ومنطقة المدينة المنورة التي تعمل في مجال نقل العفش مع الفك والتركيب والنقل والتغليف تلك الشركات التي تستخدم سيارات مجهزة ومبطنة من الداخل لكي يتم نقل العفش في امان تام بدون خدوش او تكسير مثل الشركات التالية
    - افضل شركات نقل العفش بجده
    - افضل شركة نقل عفش بمكة
    - شركة نقل عفش بالطائف

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. If you are seeking for JAC Previous Question Paper 2023, you have come to the correct place. Here is the most recent information on the predicted date for the Jharkhand Board 10th Important Question Paper as well as how to check it. Sharma, JAC This article contains the Guess 10th Question Paper 2023. JAC 10th Model Paper 2023 Candidates may acquire further information from the board's official website, which includes age board Latest Question Papers, board Important Question Papers, board paper pattern, syllabus, 10th class and Xth class Important Question Papers, and more. As we all know, the Board releases the Important Question Paper two to three months after the test. As a result, we may expect the Important Question Paper to be released around May or June 2023.

    ReplyDelete