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