Issue was fixed after upgrading alembic from version 1.5.8 to 1.8.1

On Mon, Oct 31, 2022 at 9:29 AM Jarek Potiuk <ja...@potiuk.com> wrote:

> See issue. Not much help with your problem though.
>
> On Wed, Oct 26, 2022 at 7:42 AM Pankaj Singh <aa3pan...@gmail.com> wrote:
> >
> >
> > Issue: https://github.com/apache/airflow/issues/27135
> >
> > airflow db upgrade returns below error:
> >
> > Traceback (most recent call last):
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/bin/airflow",
> line 8, in <module>
> >     sys.exit(main())
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/__main__.py",
> line 38, in main
> >     args.func(args)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/cli/cli_parser.py",
> line 51, in command
> >     return func(*args, **kwargs)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/utils/cli.py",
> line 99, in wrapper
> >     return f(*args, **kwargs)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/cli/commands/db_command.py",
> line 82, in upgradedb
> >     db.upgradedb(to_revision=to_revision, from_revision=from_revision,
> show_sql_only=args.show_sql_only)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/utils/session.py",
> line 71, in wrapper
> >     return func(*args, session=session, **kwargs)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/utils/db.py",
> line 1446, in upgradedb
> >     command.upgrade(config, revision=to_revision or 'heads')
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/command.py",
> line 294, in upgrade
> >     script.run_env()
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/script/base.py",
> line 490, in run_env
> >     util.load_python_file(self.dir, "env.py")
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/util/pyfiles.py",
> line 97, in load_python_file
> >     module = load_module_py(module_id, path)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/util/compat.py",
> line 182, in load_module_py
> >     spec.loader.exec_module(module)
> >   File "<frozen importlib._bootstrap_external>", line 728, in exec_module
> >   File "<frozen importlib._bootstrap>", line 219, in
> _call_with_frames_removed
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/migrations/env.py",
> line 107, in <module>
> >     run_migrations_online()
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/airflow/migrations/env.py",
> line 101, in run_migrations_online
> >     context.run_migrations()
> >   File "<string>", line 8, in run_migrations
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/runtime/environment.py",
> line 813, in run_migrations
> >     self.get_context().run_migrations(**kw)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/runtime/migration.py",
> line 548, in run_migrations
> >     for step in self._migrations_fn(heads, self):
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/command.py",
> line 283, in upgrade
> >     return script._upgrade_revs(revision, rev)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/script/base.py",
> line 365, in _upgrade_revs
> >     revs = list(revs)
> >   File
> "/Users/panksingh/Documents/workspace/airflow-plugins/venv/lib/python3.7/site-packages/alembic/script/revision.py",
> line 1040, in _iterate_revisions
> >     total_space.remove(rev.revision)
> > KeyError: '75d5ed6c2b43'
> >
> > Can someone help here?
> >
> > --
> >
> > Thanks and Regards,
> >
> > Pankaj Singh
>


-- 

Thanks and Regards,

Pankaj Singh

Mobile: +91-8446299796

Connect on LinkedIn <https://www.linkedin.com/in/aa3pankaj/>

Reply via email to