Issue 1:
Apache Airflow version

2.3.3 (latest released)

What happened

check pod airflow-db-migrations and get the following error:

/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py:528: DeprecationWarning: The auth_backend option in [api] has been renamed to auth_backends - the old setting has been used, but please update your config.
option = self._get_environment_variables(deprecated_key, deprecated_section, key, section)
/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py:356: FutureWarning: The auth_backends setting in [api] has had airflow.api.auth.backend.session added in the running config, which is needed by the UI. Please update your config before Apache Airflow 3.0.
warnings.warn(
/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/log/file_task_handler.py:52 DeprecationWarning: Passing filename_template to FileTaskHandler is deprecated and has no effect
[2022-07-15 12:54:20,686] {settings.py:260} DEBUG - Setting up DB connection pool (PID 7)
[2022-07-15 12:54:20,686] {settings.py:362} DEBUG - settings.prepare_engine_args(): Using pool settings. pool_size=5, max_overflow=10, pool_recycle=1800, pid=7
[2022-07-15 12:54:29,461] {db.py:707} INFO - Waiting for migrations... 0 second(s)
[2022-07-15 12:54:29,468] {db_migrations.py:53} WARNING - there are unapplied db migrations, triggering apply...
[2022-07-15 12:54:29,468] {db_migrations.py:45} INFO - -------- START - APPLY DB MIGRATIONS --------
[2022-07-15 12:54:29,470] {db.py:1336} DEBUG - running check function check_task_fail_for_duplicates
[2022-07-15 12:54:29,519] {db.py:935} WARNING - Found 835 duplicates in table task_fail. Will attempt to move them.
[2022-07-15 12:54:29,563] {db.py:1336} DEBUG - running check function check_conn_id_duplicates
[2022-07-15 12:54:29,572] {db.py:1336} DEBUG - running check function check_conn_type_null
[2022-07-15 12:54:29,586] {db.py:1336} DEBUG - running check function check_run_id_null
[2022-07-15 12:54:29,611] {db.py:1336} DEBUG - running check function check_bad_references
[2022-07-15 12:54:29,712] {db.py:1279} DEBUG - checking model task_instance
[2022-07-15 12:54:29,713] {db.py:1279} DEBUG - checking model task_reschedule
[2022-07-15 12:54:29,713] {db.py:1279} DEBUG - checking model rendered_task_instance_fields
[2022-07-15 12:54:29,713] {db.py:1308} DEBUG - moving data for table rendered_task_instance_fields
[2022-07-15 12:54:29,714] {db.py:1076} DEBUG - running CTAS for table _airflow_moved__2_3__dangling__rendered_task_instance_fields
Traceback (most recent call last):
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute
cursor.execute(statement, parameters)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (1067, "Invalid default value for 'execution_date'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/mnt/scripts/db_migrations.py", line 78, in <module>
main(sync_forever=True)
File "/mnt/scripts/db_migrations.py", line 54, in main
apply_db_migrations()
File "/mnt/scripts/db_migrations.py", line 46, in apply_db_migrations
upgradedb()
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/session.py", line 71, in wrapper
return func(*args, session=session, **kwargs)
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py", line 1452, in upgradedb
for err in _check_migration_errors(session=session):
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py", line 1337, in _check_migration_errors
yield from check_fn(session=session)
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py", line 1309, in check_bad_references
_move_dangling_data_to_new_table(
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py", line 1077, in _move_dangling_data_to_new_table
_create_table_as(
File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py", line 1057, in _create_table_as
session.execute(f"CREATE TABLE {target_table_name} LIKE {source_table_name}")
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1614, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1481, in _execute_clauseelement
ret = self._execute_context(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context
self._handle_dbapi_exception(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception
util.raise_(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
self.dialect.do_execute(
File "/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute
cursor.execute(statement, parameters)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1067, "Invalid default value for 'execution_date'")
[SQL: CREATE TABLE _airflow_moved__2_3__dangling__rendered_task_instance_fields LIKE rendered_task_instance_fields]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
[2022-07-15 12:54:29,726] {settings.py:398} DEBUG - Disposing DB connection pool (PID 7)

What you think should happen instead

No response

How to reproduce

No response

Operating System

NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"

Versions of Apache Airflow Providers

No response

Deployment

Official Apache Airflow Helm Chart

Deployment details

upgrade airflow from 2.5.5 to 2.3.3

Anything else

No response

Are you willing to submit PR?

Yes I am willing to submit a PR!

Code of Conduct

I agree to follow this project's Code of Conduct

Issue 2:
Description

We need async support for S3 facilities for use in our Triggers.

We see AwsBaseAsyncHook was introduced in this commit (PR 28850) merged on 2023-03-14.

However in #31610 , AwsBaseAsyncHook was marked Deprecated by @pankajastro and subsequently approved by @vincbeck .

I would like to know:

on what basis do you determine this class is not used? There has been no discussions in the PR.

from a user stance, providing a new functionality then removing it a few months later is not very good practice.

is async S3 operations going to be supported ? We have code based on this and deprecating this will break our code.

Many thanks, particularly to the two gentlemen I named above.

Use case/motivation

No response

Related issues

No response

Are you willing to submit a PR?

Yes I am willing to submit a PR!

Code of Conduct

I agree to follow this project's Code of Conduct