You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "raphaelauv (via GitHub)" <gi...@apache.org> on 2023/08/04 07:17:09 UTC
[GitHub] [airflow] raphaelauv opened a new issue, #33100: UI - xcom - order by Execution Date
raphaelauv opened a new issue, #33100:
URL: https://github.com/apache/airflow/issues/33100
### Apache Airflow version
2.6.3
### What happened
when you click on `Execution Date` on the ui `http://XXXX:XXX/xcom/list/`
the webserver fail
```log
{app.py:1744} ERROR - Exception on /xcom/list/ [GET]
Traceback (most recent call last):
File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 2529, in wsgi_app
response = self.full_dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 1825, in full_dispatch_request
rv = self.handle_user_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 1823, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask/app.py", line 1799, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/security/decorators.py", line 139, in wraps
return f(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/views.py", line 554, in list
widgets = self._list()
^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/baseviews.py", line 1177, in _list
widgets = self._get_list_widget(
^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/baseviews.py", line 1076, in _get_list_widget
count, lst = self.datamodel.query(
^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/models/sqla/interface.py", line 491, in query
query = self.apply_all(
^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/models/sqla/interface.py", line 437, in apply_all
inner_query = self._apply_inner_all(
^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/models/sqla/interface.py", line 385, in _apply_inner_all
query = self.apply_order_by(
^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/flask_appbuilder/models/sqla/interface.py", line 206, in apply_order_by
query = query.order_by(asc(_order_column))
^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in asc
File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 3599, in _create_asc
coercions.expect(roles.ByOfRole, column),
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/sql/coercions.py", line 177, in expect
element = element.__clause_element__()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/ext/associationproxy.py", line 441, in __clause_element__
raise NotImplementedError(
NotImplementedError: The association proxy can't be used as a plain column expression; it only works inside of a comparison expression
```
### What you think should happen instead
_No response_
### How to reproduce
click on `Admin` then `Xcom` then on `Execution Date`
### Operating System
--
### Versions of Apache Airflow Providers
_No response_
### Deployment
Docker-Compose
### Deployment details
_No response_
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] UI - xcom - order by Execution Date [airflow]
Posted by "lurcio (via GitHub)" <gi...@apache.org>.
lurcio commented on issue #33100:
URL: https://github.com/apache/airflow/issues/33100#issuecomment-1951385227
I'd like to look into this one as my first issue please
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] UI - xcom - order by Execution Date [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #33100:
URL: https://github.com/apache/airflow/issues/33100#issuecomment-1955096070
Sure
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] RNHTTR commented on issue #33100: UI - xcom - order by Execution Date
Posted by "RNHTTR (via GitHub)" <gi...@apache.org>.
RNHTTR commented on issue #33100:
URL: https://github.com/apache/airflow/issues/33100#issuecomment-1665568969
As a workaround in the meantime, sorting by the Run Id or Timestamp columns can probably be used as reasonable proxies.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org