I am running MySQL AWS RDS instance. I have a stored procedure that calls several other stored procedures. One of those intermittently fails.

I am trying to debug it but unfortunately the returned error indicates only the name of the parent stored procedure.

Is there a way to determine which of the child stored procedures caused the error?

Thank you, gen

CodePudding user response：

No, there's no way to get call stack metadata from within a MySQL stored procedure.

See also my answer to MySQL Stored Procedure logging

This is one of several reasons I avoid MySQL stored procedures altogether. They are hard to write, hard to debug, they don't support packages or compilation, and they have poor performance and scalability.