Detailed map traversal, teach you to master the complex gremlin query debugging method>>>

I don’t like to say goodbye, because sometimes I know that the next goodbye is far away or no goodbye

The error is as follows:

ERROR 1615 (HY000) at line 406 in file: 'update-mysql.sql': Prepared statement needs to be re-prepared

This is where a stored procedure is called. The solution is to reset the values of the two cache size variables of MySQL, as follows:

table_ open_ Cache: the size of the table cache

table_ definition_ Cache: table definition information cache

View the values of the two configuration variables:

SHOW VARIABLES LIKE '%table_open_cache%';

SHOW VARIABLES LIKE '%table_definition_cache%';

Reset the size of the current value:

mysql> set global table_open_cache=16384;
mysql> set global table_definition_cache=16384;

After setting, you can check the variable value again

Then re execute the script file that called the stored procedure