<h3 dir="auto">Apache Airflow version</h3>
<p dir="auto">2.3.3 (latest released)</p>
<h3 dir="auto">What happened</h3>
<p dir="auto">check pod airflow-db-migrations and get the following error:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="/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 &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 1802, in _execute_context
    self.dialect.do_execute(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py&quot;, line 719, in do_execute
    cursor.execute(statement, parameters)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py&quot;, line 206, in execute
    res = self._query(query)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py&quot;, line 319, in _query
    db.query(q)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/connections.py&quot;, line 254, in query
    _mysql.connection.query(self, query)
MySQLdb.OperationalError: (1067, &quot;Invalid default value for 'execution_date'&quot;)

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

Traceback (most recent call last):
  File &quot;/mnt/scripts/db_migrations.py&quot;, line 78, in &lt;module&gt;
    main(sync_forever=True)
  File &quot;/mnt/scripts/db_migrations.py&quot;, line 54, in main
    apply_db_migrations()
  File &quot;/mnt/scripts/db_migrations.py&quot;, line 46, in apply_db_migrations
    upgradedb()
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/session.py&quot;, line 71, in wrapper
    return func(*args, session=session, **kwargs)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py&quot;, line 1452, in upgradedb
    for err in _check_migration_errors(session=session):
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py&quot;, line 1337, in _check_migration_errors
    yield from check_fn(session=session)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py&quot;, line 1309, in check_bad_references
    _move_dangling_data_to_new_table(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py&quot;, line 1077, in _move_dangling_data_to_new_table
    _create_table_as(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/db.py&quot;, line 1057, in _create_table_as
    session.execute(f&quot;CREATE TABLE {target_table_name} LIKE {source_table_name}&quot;)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py&quot;, line 1689, in execute
    result = conn._execute_20(statement, params or {}, execution_options)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 1614, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py&quot;, line 325, in _execute_on_connection
    return connection._execute_clauseelement(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 1481, in _execute_clauseelement
    ret = self._execute_context(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 1845, in _execute_context
    self._handle_dbapi_exception(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 2026, in _handle_dbapi_exception
    util.raise_(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py&quot;, line 207, in raise_
    raise exception
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py&quot;, line 1802, in _execute_context
    self.dialect.do_execute(
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py&quot;, line 719, in do_execute
    cursor.execute(statement, parameters)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py&quot;, line 206, in execute
    res = self._query(query)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/cursors.py&quot;, line 319, in _query
    db.query(q)
  File &quot;/home/airflow/.local/lib/python3.9/site-packages/MySQLdb/connections.py&quot;, line 254, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1067, &quot;Invalid default value for 'execution_date'&quot;)
[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)
"><pre class="notranslate"><code class="notranslate">/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 &lt;module&gt;
    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)

</code></pre></div>
<h3 dir="auto">What you think should happen instead</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">How to reproduce</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Operating System</h3>
<p dir="auto">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="<a href="https://www.centos.org/" rel="nofollow">https://www.centos.org/</a>" BUG_REPORT_URL="<a href="https://bugs.centos.org/" rel="nofollow">https://bugs.centos.org/</a>"  CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"</p>
<h3 dir="auto">Versions of Apache Airflow Providers</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Deployment</h3>
<p dir="auto">Official Apache Airflow Helm Chart</p>
<h3 dir="auto">Deployment details</h3>
<p dir="auto">upgrade airflow from 2.5.5 to 2.3.3</p>
<h3 dir="auto">Anything else</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>
<h3 dir="auto">Description</h3>
<p dir="auto">We need async support for S3 facilities for use in our Triggers.<br>
We see AwsBaseAsyncHook was introduced  in <a href="https://github.com/apache/airflow/commit/cf77c3b96609aa8c260566274d54b06eb38c8100">this commit</a>  (<a href="https://github.com/apache/airflow/pull/28850" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/28850/hovercard">PR 28850</a>) merged on <a href="https://github.com/apache/airflow/pull/28850" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/28850/hovercard">2023-03-14</a>.</p>
<p dir="auto">However in <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1732066036" data-permission-text="Title is private" data-url="https://github.com/apache/airflow/issues/31610" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/31610/hovercard" href="https://github.com/apache/airflow/pull/31610">#31610</a> , AwsBaseAsyncHook was marked Deprecated by <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/pankajastro/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/pankajastro">@pankajastro</a> and subsequently approved by <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/vincbeck/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/vincbeck">@vincbeck</a> .</p>
<p dir="auto">I would like to know:</p>
<ul dir="auto">
<li>on what basis do you determine this class is not used? There has been no discussions in the PR.</li>
<li>from a user stance, providing a new functionality then removing it a few months later is not very good practice.</li>
<li>is async S3 operations going to be supported ? We have code based on this and deprecating this will break our code.</li>
</ul>
<p dir="auto">Many thanks, particularly to the two gentlemen I named above.</p>
<h3 dir="auto">Use case/motivation</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Related issues</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit a PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>