• Process deadlocked errors when trying Parallel Control Flow execution

Process deadlocked errors when trying Parallel Control Flow execution

  • 42Views
  • Last Post 27 April 2023
0
votes
Dominic Santini posted this 18 April 2023

Hello -

I was testing using Control Flow to string our integration packages together rather than simply scheduling each package separately. The first time worked, but the most recent time failed on the first parallel component. One package executed, and the other 3 in the Parallel task failed with a result like this:

Package failed: Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Is this normal behavior when trying to run in Parallel several replication packages with QBO source and SQL Server destination? 

The Control Flow package ID is 213237.

The packages that were trying run in parallel were 212993, 213228, 213229 and 213230.

I would also be open to suggestions for how best to schedule, say, 100 QBO/SQL replication packages and then execute a stored procedure after all those packages have completed. 

Thanks.

- Dominic

control-flow parallel
Order By: Standard | Newest | Votes
0
votes
Serhii Muzyka posted this 20 April 2023

Hi,

 

Thank you for contacting Skyvia Support.

 

Please be informed that we have received your request and will get back to you with the result soon.

  

Best regards,

Serhii

0
votes
Serhii Muzyka posted this 21 April 2023

Hi Dominic,

 

We are really sorry for the inconvenience.

 

Please be informed that this issue is being investigated by the development team. Once we have the result, we will reply to you in this topic.

 

Should you have any other questions, don't hesitate to reach out.

 

Best regards,

Serhii

0
votes
Serhii Muzyka posted this 25 April 2023

Hi Dominic,

 

Thank you for the patience with this request.

 

Please clarify what changes you have made in your replication packages after the error happened. Have you changed the "Track Target Name Changes" option?

Thank you in advance and looking forward to hearing from you.   Best regards,

 

Serhii

0
votes
Dominic Santini posted this 26 April 2023

Hi Serhii -

I haven't made any changes to the replication packages other than, once a field was added to the Preferences table in QBO, clearing the metadata on the QBO connectors. 

The track target naming setting is off in all packages, like shown in the screen shot above. No changes made to this setting. 

I just ran the package again as a test, and same result as before - on the first parallel execution, 1 package succeeds and the other 3 fail with deadlocked resources error. 

It is not necessary for us to run these tasks in parallel (in my main tests I am doing only sequential replication) but I did want to see if it was an option and what the pros/cons might be. 

Thanks. 

- Dominic 

0
votes
Serhii Muzyka posted this 27 April 2023

Hi,

 

Thank you for your response.

 

We will continue our investigation and will get back to you soon.

 

Best regards,

Serhii

New Ticket
Categories
Popular Tags
Close