Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.22
-
None
-
None
Description
Stored procedures contain statement like:
SET @vartmp = ...;
PREPARE _stmt FROM @vartmp;
EXECUTE _stmt;
Sometimes the execution fails with error: mysql_errno:1615, mysql_warning_count:0, mysql_sqlstate:'HY000', mysql_error:'Prepared statement needs to be re-prepared'
No idea how to reproduce stably this issue. It happens randomly on various objects from time to time. No DDL operations during the execution.
MariaDB configuration:
table_open_cache = 60000
table_definition_cache = 60000
I'm happy to provide any information required to solve the problem.
Attachments
Issue Links
- relates to
-
MDEV-17124 mariadb 10.1.34, views and prepared statements: ERROR 1615 (HY000): Prepared statement needs to be re-prepared
- Closed