Greetlist commented on issue #20308:
URL: https://github.com/apache/airflow/issues/20308#issuecomment-1054980898


   The DataBase is in K8S, and Image is: ```Percona Server 8.0.17```
   
![image](https://user-images.githubusercontent.com/18439743/156089137-9cbb7dff-ccdd-498a-a115-6e64a3ee3563.png)
   
   I make a test on test DataBase whose version is ```(MySQL Community Server - 
GPL 8.0.26)```.
   
![image](https://user-images.githubusercontent.com/18439743/156101859-cb010683-93f6-4c7a-96d4-ce3b45ee5324.png)
   
   ``` for update ``` do lock these rows when I try to modify one of these rows 
at another session. 
   As I comment before, I fix it with a tricky way.Prevent the deferrable task 
is executed twice, this problem is never show again.
   
   It seem that the trigger process do modify task_instance record even the 
record locked by ``` begin; for update; commit ```


-- 
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