ERROR 1436 (HY000): Thread stack overrun: 7180 bytes used of a 131072 byte stack, and 128000 bytes

mysql> insert into department
    -> values
    -> (1001,'科研班','现产品研发','3号楼5层');
ERROR 1436 (HY000): Thread stack overrun:  7180 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld -O thread
_stack=#' to specify a bigger stack.

 

解决方法(主要参考网上的方法）

       将mysql的配置文件my.ini文件中的“thread_stack = 128 数值改为500 或者注释掉，然后重启Mysql服务即可

 

 

mysql> insert into department
    -> values
    -> (1001,'科研班','现产品研发','3号楼5层');
Query OK, 1 row affected (0.10 sec)    # ------------已经OK 

 

 参考文章地址:http://blog.sina.com.cn/s/blog_718ac8bf0100pijq.html