dstandish opened a new issue, #49570:
URL: https://github.com/apache/airflow/issues/49570
### Body
traceback
```
Traceback (most recent call last):
File "/Users/dstandish/code/airflow/.venv/bin/airflow", line 10, in
<module>
sys.exit(main())
File "/Users/dstandish/code/airflow/airflow-core/src/airflow/__main__.py",
line 55, in main
args.func(args)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/cli/cli_config.py",
line 48, in command
return func(*args, **kwargs)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/utils/cli.py", line
111, in wrapper
return f(*args, **kwargs)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/utils/providers_configuration_loader.py",
line 55, in wrapped_function
return func(*args, **kwargs)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/cli/commands/db_command.py",
line 206, in downgrade
run_db_downgrade_command(args, db.downgrade, _REVISION_HEADS_MAP)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/cli/commands/db_command.py",
line 181, in run_db_downgrade_command
command(to_revision=to_revision, from_revision=from_revision,
show_sql_only=args.show_sql_only)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/utils/session.py", line
101, in wrapper
return func(*args, session=session, **kwargs)
File "/Users/dstandish/code/airflow/airflow-core/src/airflow/utils/db.py",
line 1234, in downgrade
_offline_migration(command.downgrade, config=config,
revision=revision_range)
File "/Users/dstandish/code/airflow/airflow-core/src/airflow/utils/db.py",
line 1015, in _offline_migration
migration_func(config, revision, sql=True)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/command.py",
line 453, in downgrade
script.run_env()
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/script/base.py",
line 586, in run_env
util.load_python_file(self.dir, "env.py")
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/util/pyfiles.py",
line 95, in load_python_file
module = load_module_py(module_id, path)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/util/pyfiles.py",
line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "<frozen importlib._bootstrap_external>", line 850, in exec_module
File "<frozen importlib._bootstrap>", line 228, in
_call_with_frames_removed
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/migrations/env.py",
line 136, in <module>
run_migrations_offline()
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/migrations/env.py",
line 94, in run_migrations_offline
context.run_migrations()
File "<string>", line 8, in run_migrations
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/runtime/environment.py",
line 946, in run_migrations
self.get_context().run_migrations(**kw)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/alembic/runtime/migration.py",
line 623, in run_migrations
step.migration_fn(**kw)
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/migrations/versions/0028_3_0_0_drop_ab_user_id_foreign_key.py",
line 83, in downgrade
if table_exists("ab_user"):
File
"/Users/dstandish/code/airflow/airflow-core/src/airflow/migrations/versions/0028_3_0_0_drop_ab_user_id_foreign_key.py",
line 43, in table_exists
inspector = inspect(op.get_bind())
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/inspection.py",
line 64, in inspect
ret = reg(subject)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py",
line 178, in _connectable_insp
return Inspector._construct(Inspector._init_legacy, bind)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py",
line 117, in _construct
init(self, bind)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py",
line 124, in _init_legacy
self._init_engine(bind)
File
"/Users/dstandish/code/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py",
line 128, in _init_engine
engine.connect().close()
AttributeError: 'MockConnection' object has no attribute 'close'
~/code/airflow simplify-migration-re-dag-versions-etc*
.venv ❯ airflow db downgrade --to-revision 5f2621c13b39 --show-sql-only
````
### Committer
- [x] I acknowledge that I am a maintainer/committer of the Apache Airflow
project.
--
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]