Amruth VVKP
12/23/2022, 12:52 PMJeff Hale
12/23/2022, 3:18 PMJeff Hale
12/23/2022, 3:21 PMprefecthq/prefect:2.7.4-python3.10
- and was able to run a flow fine using DockerContainer
- with Prefect Cloud. I see you’re trying to use Orion. I’m not familiar with that error.Zanie
Zanie
Zanie
No such revision or branch ‘f7587d6c5776’That database migration cannot be found. Are you connecting to an existing database?
Amruth VVKP
12/23/2022, 5:09 PMZanie
Zanie
Amruth VVKP
12/23/2022, 6:32 PMAmruth VVKP
12/23/2022, 6:38 PM2022-12-23 12:47:33
2022-12-23 12:47:33 ___ ___ ___ ___ ___ ___ _____ ___ ___ ___ ___ _ _
2022-12-23 12:47:33 | _ \ _ \ __| __| __/ __|_ _| / _ \| _ \_ _/ _ \| \| |
2022-12-23 12:47:33 | _/ / _|| _|| _| (__ | | | (_) | /| | (_) | .` |
2022-12-23 12:47:33 |_| |_|_\___|_| |___\___| |_| \___/|_|_\___\___/|_|\_|
2022-12-23 12:47:33
2022-12-23 12:47:33 Configure Prefect to communicate with the server with:
2022-12-23 12:47:33
2022-12-23 12:47:33 prefect config set PREFECT_API_URL=<http://0.0.0.0:4200/api>
2022-12-23 12:47:33
2022-12-23 12:47:33 View the API reference documentation at <http://0.0.0.0:4200/docs>
2022-12-23 12:47:33
2022-12-23 12:47:33 Check out the dashboard at <http://0.0.0.0:4200>
2022-12-23 12:47:33
2022-12-23 12:47:33
2022-12-23 12:47:33
2022-12-23 12:47:35 Traceback (most recent call last):
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 233, in _catch_revision_errors
2022-12-23 12:47:35 yield
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 443, in _upgrade_revs
2022-12-23 12:47:35 for script in reversed(list(revs))
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 799, in iterate_revisions
2022-12-23 12:47:35 revisions, heads = fn(
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 1454, in _collect_upgrade_revisions
2022-12-23 12:47:35 current_revisions = self.get_revisions(lower)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 527, in get_revisions
2022-12-23 12:47:35 return sum([self.get_revisions(id_elem) for id_elem in id_], ())
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 527, in <listcomp>
2022-12-23 12:47:35 return sum([self.get_revisions(id_elem) for id_elem in id_], ())
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 552, in get_revisions
2022-12-23 12:47:35 return tuple(
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 553, in <genexpr>
2022-12-23 12:47:35 self._revision_for_ident(rev_id, branch_label)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/revision.py", line 624, in _revision_for_ident
2022-12-23 12:47:35 raise ResolutionError(
2022-12-23 12:47:35 alembic.script.revision.ResolutionError: No such revision or branch 'f7587d6c5776'
2022-12-23 12:47:35
2022-12-23 12:47:35 The above exception was the direct cause of the following exception:
2022-12-23 12:47:35
2022-12-23 12:47:35 Traceback (most recent call last):
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 671, in lifespan
2022-12-23 12:47:35 async with self.lifespan_context(app):
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 566, in __aenter__
2022-12-23 12:47:35 await self._router.startup()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 648, in startup
2022-12-23 12:47:35 await handler()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/api/server.py", line 345, in run_migrations
2022-12-23 12:47:35 await db.create_db()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/interface.py", line 55, in create_db
2022-12-23 12:47:35 await self.run_migrations_upgrade()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/interface.py", line 63, in run_migrations_upgrade
2022-12-23 12:47:35 await run_sync_in_worker_thread(alembic_upgrade)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/utilities/asyncutils.py", line 69, in run_sync_in_worker_thread
2022-12-23 12:47:35 return await anyio.to_thread.run_sync(call, cancellable=True)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/anyio/to_thread.py", line 31, in run_sync
2022-12-23 12:47:35 return await get_asynclib().run_sync_in_worker_thread(
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/anyio/_backends/_asyncio.py", line 937, in run_sync_in_worker_thread
2022-12-23 12:47:35 return await future
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/anyio/_backends/_asyncio.py", line 867, in run
2022-12-23 12:47:35 result = context.run(func, *args)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/alembic_commands.py", line 24, in wrapper
2022-12-23 12:47:35 return fn(*args, **kwargs)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/alembic_commands.py", line 53, in alembic_upgrade
2022-12-23 12:47:35 alembic.command.upgrade(alembic_config(), revision, sql=dry_run)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 322, in upgrade
2022-12-23 12:47:35 script.run_env()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 569, in run_env
2022-12-23 12:47:35 util.load_python_file(self.dir, "env.py")
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
2022-12-23 12:47:35 module = load_module_py(module_id, path)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
2022-12-23 12:47:35 spec.loader.exec_module(module) # type: ignore
2022-12-23 12:47:35 File "<frozen importlib._bootstrap_external>", line 883, in exec_module
2022-12-23 12:47:35 File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/migrations/env.py", line 147, in <module>
2022-12-23 12:47:35 apply_migrations()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/utilities/asyncutils.py", line 201, in coroutine_wrapper
2022-12-23 12:47:35 return run_async_from_worker_thread(async_fn, *args, **kwargs)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/utilities/asyncutils.py", line 152, in run_async_from_worker_thread
2022-12-23 12:47:35 return anyio.from_thread.run(call)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/anyio/from_thread.py", line 49, in run
2022-12-23 12:47:35 return asynclib.run_async_from_thread(func, *args)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/anyio/_backends/_asyncio.py", line 970, in run_async_from_thread
2022-12-23 12:47:35 return f.result()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/concurrent/futures/_base.py", line 458, in result
2022-12-23 12:47:35 return self.__get_result()
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/concurrent/futures/_base.py", line 403, in __get_result
2022-12-23 12:47:35 raise self._exception
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/migrations/env.py", line 141, in apply_migrations
2022-12-23 12:47:35 await connection.run_sync(do_run_migrations)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/engine.py", line 548, in run_sync
2022-12-23 12:47:35 return await greenlet_spawn(fn, conn, *arg, **kw)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 128, in greenlet_spawn
2022-12-23 12:47:35 result = context.switch(value)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/prefect/orion/database/migrations/env.py", line 129, in do_run_migrations
2022-12-23 12:47:35 context.run_migrations()
2022-12-23 12:47:35 File "<string>", line 8, in run_migrations
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/runtime/environment.py", line 853, in run_migrations
2022-12-23 12:47:35 self.get_context().run_migrations(**kw)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/runtime/migration.py", line 611, in run_migrations
2022-12-23 12:47:35 for step in self._migrations_fn(heads, self):
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 311, in upgrade
2022-12-23 12:47:35 return script._upgrade_revs(revision, rev)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 431, in _upgrade_revs
2022-12-23 12:47:35 with self._catch_revision_errors(
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/contextlib.py", line 153, in __exit__
2022-12-23 12:47:35 self.gen.throw(typ, value, traceback)
2022-12-23 12:47:35 File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 265, in _catch_revision_errors
2022-12-23 12:47:35 raise util.CommandError(resolution) from re
2022-12-23 12:47:35 alembic.util.exc.CommandError: Can't locate revision identified by 'f7587d6c5776'
2022-12-23 12:47:35
2022-12-23 12:47:35 Application startup failed. Exiting.
2022-12-23 12:47:36 Orion stopped!
Logs while trying to launch Prefect Orion on local Ubuntu terminal with 2.7.4 -
___ ___ ___ ___ ___ ___ _____ ___ ___ ___ ___ _ _
| _ \ _ \ __| __| __/ __|_ _| / _ \| _ \_ _/ _ \| \| |
| _/ / _|| _|| _| (__ | | | (_) | /| | (_) | .` |
|_| |_|_\___|_| |___\___| |_| \___/|_|_\___\___/|_|\_|
Configure Prefect to communicate with the server with:
prefect config set PREFECT_API_URL=<http://127.0.0.1:4200/api>
View the API reference documentation at <http://127.0.0.1:4200/docs>
Check out the dashboard at <http://127.0.0.1:4200>
/usr/lib/python3.10/contextlib.py:142: SAWarning: Skipped unsupported reflection of expression-based index ix_flow_run__coalesce_start_time_expected_start_time_desc
next(self.gen)
/usr/lib/python3.10/contextlib.py:142: SAWarning: Skipped unsupported reflection of expression-based index ix_flow_run__coalesce_start_time_expected_start_time_asc
next(self.gen)