Mysql Error Code : 1436 Thread stack overrun

作者:mdxy-dxy 时间:2024-01-23 14:04:04 

ERRNO: 256 
TEXT: SQLSTATE[HY000]: General error: 1436 Thread stack overrun: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. 

According to the MySQL manual “The default (192KB) is large enough for normal operation. If the thread stack size is too small, it limits the complexity of the SQL statements that the server can handle, the recursion depth of stored procedures, and other memory-consuming actions” .

To resolve this issue you need to change the default value of parameter 'thread_stack' in /etc/my.cnf  in your MySQL configuration file. I use the XAMPP for php/mysql development. 

Mysql Error Code : 1436 Thread stack overrun

Once you set this value you need to restart MySQL as this value cannot be set dynamically.

you maybe also encounter with the message when you try to modify the my.cnf

"Cannot open file for writing: Permission denied"

We will try to use the 'chmod' instruction to change permission as usually. I seldom take the concrete permission into consideration, so I use always use the 'chmod 777'. but it resulted in another errors when I use the phpmyadmin, another tools included in XAMPP, after running 'chmod 777'.

Mysql Error Code : 1436 Thread stack overrun

After googling it, I get this file (my.cnf) permissions has to be 600. I change its permission and it works well now.

标签:Thread,stack,overrun
0
投稿

猜你喜欢

  • python 在某.py文件中调用其他.py内的函数的方法

    2021-02-25 23:56:09
  • 最新Linux系统下安装MySql 5.7.17全过程及注意事项

    2024-01-17 07:40:56
  • 使用python+Flask实现日志在web网页实时更新显示

    2021-03-15 10:16:30
  • python如何去除字符串中不想要的字符

    2022-01-05 20:37:46
  • python 请求服务器的实现代码(http请求和https请求)

    2023-07-10 08:23:58
  • mysql中获取一天、一周、一月时间数据的各种sql语句写法

    2024-01-22 04:21:06
  • python解释器pycharm安装及环境变量配置教程图文详解

    2021-10-13 22:50:44
  • Python学习之Anaconda的使用与配置方法

    2023-03-26 00:28:21
  • 理解生产者消费者模型及在Python编程中的运用实例

    2021-04-07 01:01:59
  • 谈一谈基于python的面向对象编程基础

    2021-09-09 11:04:39
  • sql语言中delete删除命令语句详解

    2024-01-28 02:20:02
  • Java API学习教程之正则表达式详解

    2023-10-23 05:28:21
  • VUE+Element实现增删改查的示例源码

    2024-05-09 09:32:47
  • 使用 Python 读取电子表格中的数据实例详解

    2023-10-15 02:40:57
  • 检测tensorflow是否使用gpu进行计算的方式

    2021-11-19 11:24:33
  • vue模仿网易云音乐的单页面应用

    2024-04-10 13:48:23
  • Python 如何求矩阵的逆

    2021-07-22 23:28:43
  • Sharding-JDBC自动实现MySQL读写分离的示例代码

    2024-01-18 00:02:35
  • python求解三角形第三边长实例

    2021-08-24 06:16:28
  • ORM Django 终端打印 SQL 语句实现解析

    2023-08-30 04:56:39
  • asp之家 网络编程 m.aspxhome.com