You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Gregory Petrosyan (JIRA)" <ji...@apache.org> on 2016/10/18 12:42:58 UTC

[jira] [Updated] (AIRFLOW-581) "Recent statuses" widget not working; related SQL exception on "Chart" page

     [ 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+nm07Q@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+nm07Q@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+nm07Q@mail.gmail.com%3E



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