Re: [I] DagProcessor - UPDATE statement on table 'serialized_dag' expected to update 1 row(s); 0 were matched. [airflow]

["Lothnic (via GitHub)" <gi...@apache.org>]

Lothnic commented on issue #42105:
URL: https://github.com/apache/airflow/issues/42105#issuecomment-3469081387

   One potential solution can be a pessimistic lock using the database's SELECT ... FOR UPDATE feature, this would explicitly lock the relevant rows in the serialized dag table before an update is attempted this serializes access to the dag records during the critical update phase, preventing the race condition and the resulting stale data error, i am open to discussing any performance implications


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org