[MySQL] Invalid query: 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.

If you happened to get error as following while you are calling the Stored Procedure

ERROR SHOWN:

Query: 
CALL detailReport2("admin777f5a4d5b4e1415af6b2761d75d212c", "01/01/2013", "31/01/2013", "ahmad.alias", "");

Invalid query: 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. 

Solution:

1. Stop your MySQL server

2. edit your my.cnf file, to add a new line or modify the existing line as following:

file my.cnf

thread_stack = 256K

3. Resume your MySQL server, you shall solve the issue/ error now