potiuk commented on PR #33172:
URL: https://github.com/apache/airflow/pull/33172#issuecomment-1668354508

   Just to add some context: Scheduler only operates on task instances tha 
belong to DAGRuns that it managed to get "For Update" lock on. This means that 
any query that modifies a bulk of task instances is bound to hit the deadlock, 
because it might get a lock on one task instance to update, and then wait for 
dagrun, while scheduler will do that in reverse direction and will attempt to 
update the two instance in reverse order. 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to