[jira] [Created] (AIRFLOW-842) scheduler.clean_dirty raises warning: SAWarning: The IN-predicate on "dag_run.dag_id" was invoked with an empty sequence.

["Marek Baczyński (JIRA)" <ji...@apache.org>]

Marek Baczyński created AIRFLOW-842:
---------------------------------------

             Summary: 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


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)