[jira] [Commented] (AIRFLOW-210) sqlalchemy warns about task_instance.execution_date invoked with an empty sequence

["Jeff Long (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15590289#comment-15590289 ] 

Jeff Long commented on AIRFLOW-210:
-----------------------------------

A quick fix for this in 1.7.1.3 is adding the following around models.py:2633:

{code:title=models.py:2633}
        task_instances = []
        if len(execution_dates) > 0:
            task_instances = (
{code}


> sqlalchemy warns about task_instance.execution_date invoked with an empty sequence
> ----------------------------------------------------------------------------------
>
>                 Key: AIRFLOW-210
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-210
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: scheduler
>    Affects Versions: Airflow 1.7.0
>         Environment: Linux, python 2.7, and mysql 5.5.47
>            Reporter: Eric Johnson
>            Assignee: Ajay Yadava
>            Priority: Minor
>
> On a fresh installation of airflow, I'm noticing this warning while running the scheduler. I'm using mysql as the storage for airflow.
> {{/opt/packages/python/2.7.5/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:153: SAWarning: The IN-predicate on "task_instance.execution_date" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)