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

Gregory Petrosyan updated AIRFLOW-581:
--------------------------------------
    Description: 
I am following the quick start (https://airflow.incubator.apache.org/start.html)

After successfully running backfill for `example_bash_operator` from CLI, 
"Recent statuses" widget is empty. However, various DAG views for this DAG show 
valid data; so the database is not empty.

Additionally, default «Airflow task instance by type» chart, which does
```
SELECT state, COUNT(1) as number FROM task_instance WHERE dag_id LIKE 
'example%' GROUP BY state
```

shows an error «SQL execution failed. Details: 'NoneType' object has no 
attribute 'get_pandas_df'». This looks related to not working "recent statuses" 
widget.

This issue was reported externally before:
- https://stackoverflow.com/questions/37989624/airflow-chart-query-failing
- 
https://mail-archives.apache.org/mod_mbox/incubator-airflow-dev/201607.mbox/%3ccaamf+vclbadxcykfsrsmvp3t5aqfp8wuvaxbaf4kyfe9+nm...@mail.gmail.com%3E

  was:
I am following the quick start (https://airflow.incubator.apache.org/start.html)

After successfully running backfill for `example_bash_operator` from CLI, 
"Recent statuses" widget is empty. However, various DAG views for this DAG show 
valid data; so the database is not empty.

Additionally, default «Airflow task instance by type» chart, which does
```SQL
SELECT state, COUNT(1) as number FROM task_instance WHERE dag_id LIKE 
'example%' GROUP BY state
```

shows an error «SQL execution failed. Details: 'NoneType' object has no 
attribute 'get_pandas_df'». This looks related to not working "recent statuses" 
widget.

This issue was reported externally before:
- https://stackoverflow.com/questions/37989624/airflow-chart-query-failing
- 
https://mail-archives.apache.org/mod_mbox/incubator-airflow-dev/201607.mbox/%3ccaamf+vclbadxcykfsrsmvp3t5aqfp8wuvaxbaf4kyfe9+nm...@mail.gmail.com%3E


> "Recent statuses" widget not working; related SQL exception on "Chart" page
> ---------------------------------------------------------------------------
>
>                 Key: AIRFLOW-581
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-581
>             Project: Apache Airflow
>          Issue Type: Bug
>    Affects Versions: Airflow 1.7.1.3
>            Reporter: Gregory Petrosyan
>
> I am following the quick start 
> (https://airflow.incubator.apache.org/start.html)
> After successfully running backfill for `example_bash_operator` from CLI, 
> "Recent statuses" widget is empty. However, various DAG views for this DAG 
> show valid data; so the database is not empty.
> Additionally, default «Airflow task instance by type» chart, which does
> ```
> SELECT state, COUNT(1) as number FROM task_instance WHERE dag_id LIKE 
> 'example%' GROUP BY state
> ```
> shows an error «SQL execution failed. Details: 'NoneType' object has no 
> attribute 'get_pandas_df'». This looks related to not working "recent 
> statuses" widget.
> This issue was reported externally before:
> - https://stackoverflow.com/questions/37989624/airflow-chart-query-failing
> - 
> https://mail-archives.apache.org/mod_mbox/incubator-airflow-dev/201607.mbox/%3ccaamf+vclbadxcykfsrsmvp3t5aqfp8wuvaxbaf4kyfe9+nm...@mail.gmail.com%3E



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to