[jira] [Comment Edited] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16998737#comment-16998737 ] Zhidong edited comment on AIRFLOW-2516 at 12/18/19 2:00 AM: Hi [~higrys],

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16998737#comment-16998737 ] Zhidong commented on AIRFLOW-2516: -- Hi [~higrys], the problem occurs at a very high frequency,

[jira] [Comment Edited] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17002071#comment-17002071 ] Zhidong edited comment on AIRFLOW-2516 at 12/23/19 2:52 AM: [~higrys], I

[jira] [Comment Edited] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17002071#comment-17002071 ] Zhidong edited comment on AIRFLOW-2516 at 12/23/19 3:21 AM: [~higrys], I

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17002071#comment-17002071 ] Zhidong commented on AIRFLOW-2516: -- [~higrys], I think it's a good idea to perform QUERY ONE in two

[jira] [Comment Edited] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17000558#comment-17000558 ] Zhidong edited comment on AIRFLOW-2516 at 12/20/19 2:26 AM: I'm using

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17000558#comment-17000558 ] Zhidong commented on AIRFLOW-2516: -- I'm using Airflow 1.9.0 now. There are only two queries that

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17003322#comment-17003322 ] Zhidong commented on AIRFLOW-2516: -- [~higrys] Sure, I could do that manually. Will this patch be

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019874#comment-17019874 ] Zhidong commented on AIRFLOW-2516: -- Hi [~potiuk], bad news.   LATEST DETECTED

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17013946#comment-17013946 ] Zhidong commented on AIRFLOW-2516: -- No deadlock for 9 days, I will apply the patch to more instances.

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17020724#comment-17020724 ] Zhidong commented on AIRFLOW-2516: -- Mysql general log                   438485088 Connect      

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17005871#comment-17005871 ] Zhidong commented on AIRFLOW-2516: -- Thanks a lot [~higrys]! Those excerpts are from [Locks Set by

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17006528#comment-17006528 ] Zhidong commented on AIRFLOW-2516: -- Great work [~potiuk], I'll be testing it out, and get back to you

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17005196#comment-17005196 ] Zhidong commented on AIRFLOW-2516: -- Hi [~higrys],   The problem still exists after changing

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17005465#comment-17005465 ] Zhidong commented on AIRFLOW-2516: -- The execution plan is different on mariadb-5.5.60 from yours,

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009281#comment-17009281 ] Zhidong commented on AIRFLOW-2516: -- Hi [~potiuk], no new deadlock observed since last update (4days

[jira] [Assigned] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhidong reassigned AIRFLOW-2516: Assignee: Zhidong > Deadlock found when trying to update task_instance table >

[jira] [Assigned] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhidong reassigned AIRFLOW-2516: Assignee: Jarek Potiuk (was: Zhidong) > Deadlock found when trying to update task_instance

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009588#comment-17009588 ] Zhidong commented on AIRFLOW-2516: -- It says *SELECT ... FOR UPDATE* locks rows and associated index

[jira] [Commented] (AIRFLOW-2516) Deadlock found when trying to update task_instance table

[ https://issues.apache.org/jira/browse/AIRFLOW-2516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010233#comment-17010233 ] Zhidong commented on AIRFLOW-2516: -- The execution plans for *SELECT ... WHERE FOR UPDATE* and *UPDATE