Hi Everyone,
I'm faced this error
Query execution was interrupted (max_statement_time exceeded)
two days in the model. Process model calls a SP which truncates the table an reset the autoincrement value of the primary key. This models runs twice in a day and this node failed in first run of the day for two days by throwing this error.
I'm aware why this error comes but nothing much to fix in the SP and also table didn't had much rows as well its around 800 rows. It might be DB usage might be high at that time but how i can confirm that from logs please let me know for suggestions.
Thanks,
Bhargavi P.
Discussion posts and replies are publicly visible
Hi Bhargavi Prakash
Were you able to identify the root cause of the error you encountered ? I'm currently facing a similar issue where a stored procedure that processes around 500 rows is failing in the higher environment, while the same code runs perfectly fine in both Dev and QA.
I'm wondering if optimizing the stored procedure is the only viable solution here, or if there might be other factors I'm overlooking. Any insights or suggestions would be greatly appreciated.
Thanks