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

["Adir Katz (JIRA)" <ji...@apache.org>]

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

Adir Katz commented on AIRFLOW-210:
-----------------------------------

The fix should be:
{code}
task_instances = []
        if len(active_runs) > 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)