NK74 opened a new issue #22647:
URL: https://github.com/apache/airflow/issues/22647
### Apache Airflow version
2.2.4 (latest released)
### What happened
Error
[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING -
/home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/xcom.py:437:
SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache
key because the ``cache_ok`` attribute is not set to True. This can have
significant performance implications including some performance degradations in
comparison to prior SQLAlchemy versions. Set this attribute to True if this
type object's state is safe to use in a cache key, or False to disable this
warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
return query.delete()
[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING -
/home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/taskinstance.py:2214:
SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache
key because the ``cache_ok`` attribute is not set to True. This can have
significant performance implications including some performance degradations in
comparison to prior SQLAlchemy versions. Set this attribute to True if this
type object's state is safe to use in a cache key, or False to disable this
warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
for result in query.with_entities(XCom.task_id, XCom.value)
[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING -
/home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/renderedtifields.py:126:
SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache
key because the ``cache_ok`` attribute is not set to True. This can have
significant performance implications including some performance degradations in
comparison to prior SQLAlchemy versions. Set this attribute to True if this
type object's state is safe to use in a cache key, or False to disable this
warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
session.merge(self)
[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING -
/home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/renderedtifields.py:162:
SAWarning: Coercing Subquery object into a select() for use in IN(); please
pass a select() construct explicitly
tuple_(cls.dag_id, cls.task_id, cls.execution_date).notin_(subq1),
[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING -
/home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/renderedtifields.py:163:
SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache
key because the ``cache_ok`` attribute is not set to True. This can have
significant performance implications including some performance degradations in
comparison to prior SQLAlchemy versions. Set this attribute to True if this
type object's state is safe to use in a cache key, or False to disable this
warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
).delete(synchronize_session=False)
### What you think should happen instead
_No response_
### How to reproduce
_No response_
### Operating System
NAME="Amazon Linux" VERSION="2" ID="amzn" ID_LIKE="centos rhel fedora"
VERSION_ID="2" PRETTY_NAME="Amazon Linux 2" ANSI_COLOR="0;33"
CPE_NAME="cpe:2.3:o:amazon:amazon_linux:2" HOME_URL="https://amazonlinux.com/";
### Versions of Apache Airflow Providers
apache-airflow-providers-amazon==3.0.0
apache-airflow-providers-celery==2.1.0
apache-airflow-providers-ftp==2.0.1
apache-airflow-providers-http==2.0.3
apache-airflow-providers-imap==2.2.0
apache-airflow-providers-postgres==3.0.0
apache-airflow-providers-redis==2.0.1
apache-airflow-providers-sqlite==2.1.0
### Deployment
Other
### Deployment details
Pip package
### Anything else
_No response_
### Are you willing to submit PR?
- [X] 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
