airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremiah Lowin (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (AIRFLOW-842) scheduler.clean_dirty raises warning: SAWarning: The IN-predicate on "dag_run.dag_id" was invoked with an empty sequence.
Date Mon, 13 Feb 2017 19:33:41 GMT

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

Mime
View raw message