Mysql-error 1406

1.1.1 phenomena

Executes a stored procedure with the following error:

Please correct the following input error :

Cdbcommand cannot execute SQL Statement : sqlstate[hy000]: General error:1456 Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded For routine Sp_rebuild_booktype. The SQL statement executed Was:call sp_rebuild_booktype (:p arentid)

1.1.2 cause

This error occurs because the stored procedure is recursively called, but no recursive hierarchy is set.

1.1.3 Solve

Add the following code to the stored procedure:

set @ @max_sp_recursion_depth = ten;

or in MYSQL set the global variable by executing the following command:

set global max_sp_recursion_depth = ten;

or in MY. INI , add the following parameters:

Max_sp_recursion_depth = 10

Mysql-error 1406