You are viewing limited content. For full access, please sign in.

Question

Question

Does Workflow automatically retry query activity deadlocks?

asked on January 10, 2023

When a query activity in Workflow becomes a deadlock victim, does Workflow automatically retry those activities? I didn't see anything for message 1205 in the Task Error Handlers and I read another post that mentioned Workflow automatically retries deadlocks, but I feel that it was referring to when Workflow itself encounters a deadlock, not an activity in a workflow, so I just wanted to verify.

0 0

Answer

SELECTED ANSWER
replied on January 10, 2023

Workflow does retry on deadlocks for its own internal interactions with SQL. It will not retry queries in the data activities.

0 0

Replies

replied on January 10, 2023

I don't think so, I have quite a few high-volume query activities placed into try-catch blocks specifically because of occasional deadlocks that cause them to error out.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.