Home Database Mysql Tutorial Mysql Error Code : 1436 Thread stack overrun

Mysql Error Code : 1436 Thread stack overrun

Jun 07, 2016 pm 06:03 PM
stack thread

I meet with the error while calling stored procedures from the MySql in my Mac system server. It similar as the description below


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.

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

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

An in-depth exploration of the structural aspects and functions of OP Stack An in-depth exploration of the structural aspects and functions of OP Stack Jan 18, 2024 pm 05:45 PM

OPStack is an open source blockchain framework released by Optimism Collective, the development group behind the Optimism Network. It is an important tool for both the Ethereum and Optimism communities. The main goal of OPStack is to strengthen the Optimism Network, providing key software tools to the Optimism Mainnet, as well as the upcoming Optimism Superchain and its governance model. By providing a developer-oriented environment, the core idea of ​​OPStack is to promote growth and innovation in the Ethereum space. It paves the way for cutting-edge developments and makes blockchain creation simpler. OPStac

What are the differences between Runnable and Thread in Java? What are the differences between Runnable and Thread in Java? May 07, 2023 pm 05:19 PM

There are two ways to implement multi-threading in Java, one is to inherit the Thread class, and the other is to implement the Runnable interface; the Thread class is defined in the java.lang package. As long as a class inherits the Thread class and overrides the run() method in this class, it can implement multi-threaded operations. However, a class can only inherit one parent class, which is a limitation of this method. Let’s look at an example: packageorg.thread.demo;classMyThreadextendsThread{privateStringname;publicMyThread(Stringname){super();this

Java uses the empty() function of the Stack class to determine whether the stack is empty Java uses the empty() function of the Stack class to determine whether the stack is empty Jul 25, 2023 pm 10:25 PM

Java uses the empty() function of the Stack class to determine whether the stack is empty. The stack (Stack) is a common data structure that follows the first-in, last-out (FILO) principle. In Java, we can use the Stack class to implement the functionality of the stack. The Stack class provides a series of methods to operate the stack. One of the commonly used methods is the empty() function, which is used to determine whether the stack is empty. In Java, the Stack class is located in the java.util package. To use this class, you need

Start a new thread using java's Thread.start() function Start a new thread using java's Thread.start() function Jul 24, 2023 pm 11:01 PM

Use Java's Thread.start() function to start a new thread. In Java, we can use multi-threading to execute multiple tasks concurrently. Java provides the Thread class to create and manage threads. The start() function in the Thread class is used to start a new thread and execute the code in the run() method of the thread. Code example: publicclassMyThreadextendsThread{@Overr

How does Thread generate an interface in java? How does Thread generate an interface in java? May 17, 2023 pm 12:49 PM

In java, when it comes to threads, Thread is essential. A thread is a lighter scheduled executor than a process. Why use threads? By using threads, you can separate resource allocation and execution scheduling in operating system processes. Each thread can not only share process resources (memory address, file I/O, etc.), but can also be scheduled independently (thread is the basic unit of CPU scheduling). Note 1. Thread is the most important class for making threads, and the word itself also represents thread. 2. The Thread class implements the Runnable interface. Instance publicclassThreadDemoextendsThread{publicvoidrun(){for(inti=0

How to use the Stack function for stack operations in Java How to use the Stack function for stack operations in Java Jun 26, 2023 pm 04:00 PM

Introduces how to use the Stack function to perform basic stack operations in Java and related precautions. The stack is a commonly used data structure. In Java, you can use the Stack function to perform basic stack operations. Stack is a defined class located under the java.util package, so you need to introduce this package before using it. The following are the basic operations commonly used by the Stack class: 1. Create a stack Stack<Integer>stack=newStack

Five ways to fix Thread Stuck in Device Driver blue screen Five ways to fix Thread Stuck in Device Driver blue screen Mar 25, 2024 pm 09:40 PM

Some users reported that after installing Microsoft's March Win11 update patch KB5035853, a blue screen of death error occurred, with "ThreadStuckinDeviceDriver" displayed on the system page. It is understood that this error may be caused by hardware or driver issues. Here are five fixes that will hopefully resolve your computer blue screen problem quickly. Method 1: Run system file check. Run the [sfc/scannow] command in the command prompt, which can be used to detect and repair system file integrity issues. The purpose of this command is to scan and repair any missing or damaged system files, helping to ensure system stability and normal operation. Method 2: 1. Download and open the "Blue Screen Repair Tool"

ChatGPT steals: Stack Overflow is being abandoned by programmers, and the number of visits plummets by 32 million in a month ChatGPT steals: Stack Overflow is being abandoned by programmers, and the number of visits plummets by 32 million in a month May 01, 2023 pm 04:43 PM

This article is reprinted with the authorization of AI New Media Qubits (public account ID: QbitAI). Please contact the source for reprinting. StackOverflow is being abandoned by programmers. You heard that right. This world-renowned developer Q&A website has seen a sudden drop of 32 million visits in just one month! Even the search volume now is only one-third of its peak... Why is this suddenly happening? A netizen explained the mystery: I haven’t used StackOverflow since ChatGPT came out. And judging from the StackOverflow traffic statistics in the past three months, the traffic decline occurred between November and December 2022. Coincidentally, OpenAI released ChatGPT, which is

See all articles