Hey all! I have recently this weird error that do...
# ask-community
m
Hey all! I have recently this weird error that doesn't make me able to start the prefect server. I get this error with prefect 2.19 and 2.20 and have no idea what went wrong
Copy code
Traceback (most recent call last):
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\_vendor\starlette\routing.py", line 736, in lifespan
    async with self.lifespan_context(app) as maybe_state:
  File "C:\Users\michi\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 210, in __aenter__
    return await anext(self.gen)
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\api\server.py", line 645, in lifespan
    await run_migrations()
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\api\server.py", line 529, in run_migrations
    await db.create_db()
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\interface.py", line 56, in create_db
    await self.run_migrations_upgrade()
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\interface.py", line 64, in run_migrations_upgrade    
    await run_sync_in_worker_thread(alembic_upgrade)
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\utilities\asyncutils.py", line 136, in run_sync_in_worker_thread     
    return await anyio.to_thread.run_sync(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\anyio\to_thread.py", line 33, in run_sync
    return await get_asynclib().run_sync_in_worker_thread(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\anyio\_backends\_asyncio.py", line 877, in run_sync_in_worker_thread
    return await future
           ^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\anyio\_backends\_asyncio.py", line 807, in run
    result = context.run(func, *args)
             ^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\alembic_commands.py", line 24, in wrapper
    return fn(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\alembic_commands.py", line 53, in alembic_upgrade    
    alembic.command.upgrade(alembic_config(), revision, sql=dry_run)
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\command.py", line 406, in upgrade
    script.run_env()
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\script\base.py", line 582, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
    module = load_module_py(module_id, path)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\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 940, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\migrations\env.py", line 175, in <module>
    apply_migrations()
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\utilities\asyncutils.py", line 297, in coroutine_wrapper
    return run_async_from_worker_thread(async_fn, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\utilities\asyncutils.py", line 222, in run_async_from_worker_thread  
    return anyio.from_thread.run(call)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\anyio\from_thread.py", line 47, in run
    return asynclib.run_async_from_thread(func, *args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\anyio\_backends\_asyncio.py", line 906, in run_async_from_thread
    return f.result()
           ^^^^^^^^^^
  File "C:\Users\michi\AppData\Local\Programs\Python\Python311\Lib\concurrent\futures\_base.py", line 456, in result
    return self.__get_result()
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\AppData\Local\Programs\Python\Python311\Lib\concurrent\futures\_base.py", line 401, in __get_result
    raise self._exception
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\migrations\env.py", line 169, in apply_migrations    
    await connection.run_sync(do_run_migrations)
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\sqlalchemy\ext\asyncio\engine.py", line 886, in run_sync
    return await greenlet_spawn(
           ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 203, in greenlet_spawn
    result = context.switch(value)
             ^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\prefect\server\database\migrations\env.py", line 137, in do_run_migrations   
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\runtime\environment.py", line 946, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\runtime\migration.py", line 616, in run_migrations
    for step in self._migrations_fn(heads, self):
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\command.py", line 395, in upgrade
    return script._upgrade_revs(revision, rev)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\script\base.py", line 446, in _upgrade_revs
    with self._catch_revision_errors(
  File "C:\Users\michi\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 158, in __exit__
    self.gen.throw(typ, value, traceback)
  File "C:\Users\michi\Code\Capture.Data.Exporter\capture.prefect.data-exporter\venv\Lib\site-packages\alembic\script\base.py", line 282, in _catch_revision_errors
    raise util.CommandError(resolution) from re
alembic.util.exc.CommandError: Can't locate revision identified by 'f93e1439f022'

Application startup failed. Exiting.
Server stopped!
1
c
Hey @Michiel! This is unfortunately caused by using 3.0 and then switching back to 2.0, see my comment here: https://github.com/PrefectHQ/prefect/issues/15101#issuecomment-2322624883
m
yes i tried 3.0 for a while but i wanted to switch to 2.0 for stability
c
makes sense, apologies that you ran into this, i know the error is cryptic
😀 1
m
thanks for your reply!i
🫡 1