Azure Data Factory “Stored Procedure Activity” causes SQL server deadlock error 1205

In Azure Data Factory, I have a “Stored Procedure Activity” that executes a stored procedure which updates a single row in a single table in Azure SQL Server database instance (simple table update without joining to other tables).

I understand that SQL Server deadlock 1205 error occurs when two processes collide because each one is trying to reach a resource while locking another resource needed for the opposing process.

But in my case, my stored procedure is targeting one resource only (without locking another), so it should not collide with any other concurrently running processes and causes a deadlock because simply it could just wait.

PS: the error appears and goes away randomly (meaning: the pipeline could run for days normally, then the error shows up again)

I only made sure that no other pipelines are accessing the same stored procedure (or the related table) at the same time. but the deadlock error still show up sometimes.

Read more here: Source link