potiuk commented on issue #45388:
URL: https://github.com/apache/airflow/issues/45388#issuecomment-2571411707
Generally:
a) pessimistic locking
* lock update
*run query and update state
* save the state change and unlocki
b) optimistic locking
* read a state
* run query and only update if the state has not changed in a single
transaction and commit in the same operation
I am not sure what "state" we can read here and how we can verify the state
has not changed sinve we read it.
--
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]