gil-tober opened a new issue, #33606:
URL: https://github.com/apache/airflow/issues/33606
### Apache Airflow version
2.7.0
### What happened
Running `airflow db clean -y -v --skip-archive --clean-before-timestamp
'2023-05-24 00:00:00'` fails.
Running the same command without the `--skip-archive` flag passes
successfully.
```
Traceback (most recent call last):
File "/home/airflow/.local/bin/airflow", line 8, in <module>
sys.exit(main())
^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/__main__.py", line
60, in main
args.func(args)
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/cli/cli_config.py",
line 49, in command
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/cli.py", line
113, in wrapper
return f(*args, **kwargs)
^^^^^^^^^^^^^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/providers_configuration_loader.py",
line 56, in wrapped_function
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/cli/commands/db_command.py",
line 241, in cleanup_tables
run_cleanup(
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/session.py",
line 77, in wrapper
return func(*args, session=session, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/db_cleanup.py",
line 437, in run_cleanup
_cleanup_table(
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/db_cleanup.py",
line 302, in _cleanup_table
_do_delete(query=query, orm_model=orm_model, skip_archive=skip_archive,
session=session)
File
"/home/airflow/.local/lib/python3.11/site-packages/airflow/utils/db_cleanup.py",
line 197, in _do_delete
target_table.drop()
File
"/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py",
line 978, in drop
bind = _bind_or_error(self)
^^^^^^^^^^^^^^^^^^^^
File
"/home/airflow/.local/lib/python3.11/site-packages/sqlalchemy/sql/base.py",
line 1659, in _bind_or_error
raise exc.UnboundExecutionError(msg)
sqlalchemy.exc.UnboundExecutionError: Table object
'_airflow_deleted__dag_run__20230822091212' is not bound to an Engine or
Connection. Execution can not proceed without a database to execute against.
```
### What you think should happen instead
db clean command with --skip-archive should pass
### How to reproduce
`airflow db clean -y -v --skip-archive --clean-before-timestamp '2023-05-24
00:00:00'`
### Operating System
Debian GNU/Linux 11 (bullseye)
### Versions of Apache Airflow Providers
apache-airflow-providers-amazon==8.5.1
apache-airflow-providers-celery==3.3.2
apache-airflow-providers-cncf-kubernetes==7.4.2
apache-airflow-providers-common-sql==1.7.0
apache-airflow-providers-daskexecutor==1.0.0
apache-airflow-providers-docker==3.7.3
apache-airflow-providers-elasticsearch==5.0.0
apache-airflow-providers-ftp==3.5.0
apache-airflow-providers-google==8.3.0
apache-airflow-providers-grpc==3.2.1
apache-airflow-providers-hashicorp==3.4.2
apache-airflow-providers-http==4.5.0
apache-airflow-providers-imap==3.3.0
apache-airflow-providers-jenkins==3.3.1
apache-airflow-providers-microsoft-azure==6.2.4
apache-airflow-providers-mysql==5.2.1
apache-airflow-providers-odbc==4.0.0
apache-airflow-providers-openlineage==1.0.1
apache-airflow-providers-postgres==5.6.0
apache-airflow-providers-redis==3.3.1
apache-airflow-providers-salesforce==5.4.1
apache-airflow-providers-sendgrid==3.2.1
apache-airflow-providers-sftp==4.5.0
apache-airflow-providers-slack==7.3.2
apache-airflow-providers-snowflake==4.4.2
apache-airflow-providers-sqlite==3.4.3
apache-airflow-providers-ssh==3.7.1
apache-airflow-providers-tableau==4.2.1
### Deployment
Official Apache Airflow Helm Chart
### Deployment details
Helm version 1.9.0
MetaDB is a AWS Postgres RDS connected using a PGBouncer
### 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
