Hey Community! I am running into this issue when I am trying to start prefect server:

Traceback (most recent call last):
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\base.py", line 233, in _catch_revision_errors
    yield
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\base.py", line 443, in _upgrade_revs
    for script in reversed(list(revs))
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 799, in iterate_revisions
    revisions, heads = fn(
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 1454, in _collect_upgrade_revisions
    current_revisions = self.get_revisions(lower)
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 527, in get_revisions
    return sum([self.get_revisions(id_elem) for id_elem in id_], ())
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 527, in <listcomp>
    return sum([self.get_revisions(id_elem) for id_elem in id_], ())
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 552, in get_revisions
    return tuple(
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 553, in <genexpr>
    self._revision_for_ident(rev_id, branch_label)
  File "C:\Users\92316\miniconda3\envs\prefect\lib\site-packages\alembic\script\revision.py", line 624, in _revision_for_ident
    raise ResolutionError(
alembic.script.revision.ResolutionError: No such revision or branch '22ef3915ccd8'

I tried everything but I am unable to restart the server, any idea?

hi @Tony Alfonse - do you have existing data that you need to hold on to in your db?

@Nate Nope

• first i would try

alembic upgrade head

• but if thats not working, and you dont have data to preserve, then clean slate option would be:

rm ~/.prefect/prefect.db && prefect server database reset

or i guess on windows itd be something like

del %USERPROFILE%\.prefect\prefect.db
prefect server database reset

Thank you very much @Nate 🙂