MySQL Forums
Forum List  »  Stored Procedures

Re: Stored procedure runs indefinitely, but the steps within can be run individually with no issue (5.7)
Posted by: Eric Jones
Date: February 18, 2019 11:29AM

I'm on MySQL 5.7. The procedures are being run via Workbench 8.0.

Oddly enough, when I ran the procedure this morning, it executed fine, and it completed in 4m50s. Now I'm back to thinking there really is something to the 5 minute threshold. Every day before today, the dimensions and facts procedures completed in a little over 5 minutes, and LoadAllTables() would not complete on those days. Today, they ran in 4m50s, and LoadAllTables() DID complete.

I'm not sure what you mean by adding status stubs into the procedures. Could you elaborate?

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.