[jira] [Closed] (AIRFLOW-376) TypeError("Boolean value of this clause is not defined")

["Daniel Imberman (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AIRFLOW-376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Imberman closed AIRFLOW-376.
-----------------------------------
    Resolution: Auto Closed

> TypeError("Boolean value of this clause is not defined")
> --------------------------------------------------------
>
>                 Key: AIRFLOW-376
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-376
>             Project: Apache Airflow
>          Issue Type: Bug
>            Reporter: Xuan Ji Li
>            Assignee: Xuan Ji Li
>            Priority: Minor
>
> With this dag,
> ```
> from airflow import DAG
> from airflow.operators.bash_operator import BashOperator
> from datetime import datetime, timedelta
> default_args = {
>     'owner': 'airflow',
>     'depends_on_past': False,
>     'start_date': datetime(2016, 1, 1, 1, 0),
>     'email': ['xuanji@gmail.com'],
>     'email_on_failure': True,
>     'email_on_retry': False,
>     'retries': 3,
>     'retry_delay': timedelta(minutes=1),
> }
> dag = DAG('bash_bash_bash', default_args=default_args)
> # t1, t2 and t3 are examples of tasks created by instatiating operators
> t1 = BashOperator(
>     task_id='print_date',
>     bash_command='date',
>     dag=dag)
> t2 = BashOperator(
>     task_id='sleep',
>     bash_command='sleep 5',
>     retries=3,
>     dag=dag)
> templated_command = """
>     {% for i in range(5) %}
>         echo "{{ ds }}"
>         echo "{{ macros.ds_add(ds, 7)}}"
>         echo "{{ params.my_param }}"
>     {% endfor %}
> """
> t3 = BashOperator(
>     task_id='templated',
>     bash_command=templated_command,
>     params={'my_param': 'Parameter I passed in'},
>     dag=dag)
> t2.set_upstream(t1)
> t3.set_upstream(t1)
> ```
> I get an error while running the scheduler
> ```
> [2016-07-27 21:40:57,468] {jobs.py:669} ERROR - Boolean value of this clause is not defined
> Traceback (most recent call last):
>   File "/Users/xuanji_li/tools/zodiac-airflow/airflow/jobs.py", line 667, in _do_dags
>     self.manage_slas(dag)
>   File "/Users/xuanji_li/tools/zodiac-airflow/airflow/utils/db.py", line 53, in wrapper
>     result = func(*args, **kwargs)
>   File "/Users/xuanji_li/tools/zodiac-airflow/airflow/jobs.py", line 299, in manage_slas
>     .filter(SlaMiss.email_sent.is_(False) or SlaMiss.notification_sent.is_(False))
>   File "/Library/Python/2.7/site-packages/sqlalchemy/sql/elements.py", line 2760, in __bool__
>     raise TypeError("Boolean value of this clause is not defined")
> TypeError: Boolean value of this clause is not defined
> ```
> Mainly opening this to remind myself to take a look at it



--
This message was sent by Atlassian Jira
(v8.3.4#803005)