[ 
https://issues.apache.org/jira/browse/AIRFLOW-376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16661971#comment-16661971
 ] 

jack commented on AIRFLOW-376:
------------------------------

[~xuanji] is this still an issue?

> 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: Li Xuanji
>            Assignee: Li Xuanji
>            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': ['[email protected]'],
>     '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
(v7.6.3#76005)

Reply via email to