[
https://issues.apache.org/jira/browse/AIRFLOW-842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeremiah Lowin resolved AIRFLOW-842.
------------------------------------
Resolution: Fixed
Fix Version/s: 1.8.1
Issue resolved by pull request #2072
[https://github.com/apache/incubator-airflow/pull/2072]
> scheduler.clean_dirty raises warning: SAWarning: The IN-predicate on
> "dag_run.dag_id" was invoked with an empty sequence.
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: AIRFLOW-842
> URL: https://issues.apache.org/jira/browse/AIRFLOW-842
> Project: Apache Airflow
> Issue Type: Bug
> Affects Versions: Airflow 1.8, 1.8.0b5
> Reporter: Marek Baczyński
> Priority: Minor
> Labels: easyfix
> Fix For: 1.8.1
>
>
> sqlalchemy/sql/default_comparator.py:161: SAWarning: The IN-predicate on
> "dag_run.dag_id" was invoked with an empty sequence. This results in a
> contradiction, which nonetheless can be expensive to evaluate. Consider
> alternative strategies for improved performance.
> {noformat}
> qry = (
> session.query(DagRun.dag_id, DagRun.state, func.count('*'))
> .filter(DagRun.dag_id.in_(dirty_ids))
> .group_by(DagRun.dag_id, DagRun.state)
> )
> {noformat}
> dirty_ids can be empty here, which means there's no point in running this
> part of the code at all.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
