[jira] [Closed] (AIRFLOW-977) Deadlocked DAG run with MySQL v5.7.17

["Bolke de Bruin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AIRFLOW-977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bolke de Bruin closed AIRFLOW-977.
----------------------------------
       Resolution: Fixed
         Assignee: Bolke de Bruin
    Fix Version/s: Airflow 1.8
                   1.8.0

> Deadlocked DAG run with MySQL v5.7.17
> -------------------------------------
>
>                 Key: AIRFLOW-977
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-977
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: DagRun
>    Affects Versions: Airflow 1.7.1
>         Environment: macOS Sierra 10.12.3, MySQL 5.7.17, Airflow 1.7.1.3
>            Reporter: Michael Kotliar
>            Assignee: Bolke de Bruin
>              Labels: easyfix
>             Fix For: 1.8.0, Airflow 1.8
>
>
> When using MySQL 5.7.17 all DATETIME values are saved in DB using rounding, not truncating, like it was before in MySQL 5.5. This causes failing in is_queueable check for task, when its execution date was previously saved in DB rounded towards bigger value. It makes execution date to be bigger than datetime.now(). If all of the tasks from DAG have failed this check, the DAG becomes deadlocked.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)