https://prefect.io logo
Title
k

komal azram

11/19/2022, 6:57 AM
I have just started using prefect 2 and nothing seems working for me. I can't start prefect server using prefect orion start. it says background error at: https://sqlalche.me/e/14/e3q8. When I ran the code I get this sqlite3.OperationalError: table flow already exists. I have tried resetting database but it gives this error sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table flow already exists [SQL: CREATE TABLE flow ( id CHAR(36) DEFAULT ( ( lower(hex(randomblob(4))) || '-' || lower(hex(randomblob(2))) || '-4' || substr(lower(hex(randomblob(2))),2) || '-' || substr('89ab',abs(random()) % 4 + 1, 1) || substr(lower(hex(randomblob(2))),2) || '-' || lower(hex(randomblob(6))) ) ) NOT NULL, created DATETIME DEFAULT (strftime('%Y-%m-%d %H:%M:%f000', 'now')) NOT NULL, updated DATETIME DEFAULT (strftime('%Y-%m-%d %H:%M:%f000', 'now')) NOT NULL, name VARCHAR NOT NULL, tags JSON DEFAULT '[]' NOT NULL, CONSTRAINT pk_flow PRIMARY KEY (id), CONSTRAINT uq_flow__name UNIQUE (name) ) ] (Background on this error at: https://sqlalche.me/e/14/e3q8) An exception occurred. can someone help me with this? I am using ubutu 20.04
1
k

komal azram

11/20/2022, 8:50 AM
I tried deleting db and resetting and I get this error Downgrading database... Upgrading database... Traceback (most recent call last): File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context self.dialect.do_execute( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute cursor.execute(statement, parameters) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 229, in _handle_exception raise error File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 82, in execute self.await_(_cursor.execute(operation, parameters)) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 76, in await_only return current.driver.switch(awaitable) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 129, in greenlet_spawn value = await result File "/usr/local/lib/python3.8/dist-packages/aiosqlite/cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "/usr/local/lib/python3.8/dist-packages/aiosqlite/cursor.py", line 31, in _execute return await self._conn._execute(fn, *args, **kwargs) File "/usr/local/lib/python3.8/dist-packages/aiosqlite/core.py", line 129, in _execute return await future File "/usr/local/lib/python3.8/dist-packages/aiosqlite/core.py", line 102, in run result = function() sqlite3.OperationalError: table flow already exists The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/komal/.local/lib/python3.8/site-packages/prefect/cli/_utilities.py", line 41, in wrapper return fn(*args, **kwargs) File "/home/komal/.local/lib/python3.8/site-packages/prefect/utilities/asyncutils.py", line 212, in wrapper return run_async_in_new_loop(async_fn, *args, **kwargs) File "/home/komal/.local/lib/python3.8/site-packages/prefect/utilities/asyncutils.py", line 141, in run_async_in_new_loop return anyio.run(partial(__fn, *args, **kwargs)) File "/usr/local/lib/python3.8/dist-packages/anyio/_core/_eventloop.py", line 70, in run return asynclib.run(func, *args, **backend_options) File "/usr/local/lib/python3.8/dist-packages/anyio/_backends/_asyncio.py", line 292, in run return native_run(wrapper(), debug=debug) File "/usr/lib/python3.8/asyncio/runners.py", line 44, in run return loop.run_until_complete(main) File "/usr/lib/python3.8/asyncio/base_events.py", line 616, in run_until_complete return future.result() File "/usr/local/lib/python3.8/dist-packages/anyio/_backends/_asyncio.py", line 287, in wrapper return await func(*args) File "/home/komal/.local/lib/python3.8/site-packages/prefect/cli/orion.py", line 167, in reset await db.create_db() File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/interface.py", line 54, in create_db await self.run_migrations_upgrade() File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/interface.py", line 62, in run_migrations_upgrade await run_sync_in_worker_thread(alembic_upgrade) File "/home/komal/.local/lib/python3.8/site-packages/prefect/utilities/asyncutils.py", line 57, in run_sync_in_worker_thread return await anyio.to_thread.run_sync(call, cancellable=True) File "/usr/local/lib/python3.8/dist-packages/anyio/to_thread.py", line 31, in run_sync return await get_asynclib().run_sync_in_worker_thread( File "/usr/local/lib/python3.8/dist-packages/anyio/_backends/_asyncio.py", line 937, in run_sync_in_worker_thread return await future File "/usr/local/lib/python3.8/dist-packages/anyio/_backends/_asyncio.py", line 867, in run result = context.run(func, *args) File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/alembic_commands.py", line 29, in alembic_upgrade alembic.command.upgrade(alembic_config(), revision, sql=dry_run) File "/usr/local/lib/python3.8/dist-packages/alembic/command.py", line 320, in upgrade script.run_env() File "/usr/local/lib/python3.8/dist-packages/alembic/script/base.py", line 563, in run_env util.load_python_file(self.dir, "env.py") File "/usr/local/lib/python3.8/dist-packages/alembic/util/pyfiles.py", line 92, in load_python_file module = load_module_py(module_id, path) File "/usr/local/lib/python3.8/dist-packages/alembic/util/pyfiles.py", line 108, in load_module_py spec.loader.exec_module(module) # type: ignore File "<frozen importlib._bootstrap_external>", line 848, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/migrations/env.py", line 147, in <module> apply_migrations() File "/home/komal/.local/lib/python3.8/site-packages/prefect/utilities/asyncutils.py", line 208, in wrapper return run_async_from_worker_thread(async_fn, *args, **kwargs) File "/home/komal/.local/lib/python3.8/site-packages/prefect/utilities/asyncutils.py", line 137, in run_async_from_worker_thread return anyio.from_thread.run(call) File "/usr/local/lib/python3.8/dist-packages/anyio/from_thread.py", line 49, in run return asynclib.run_async_from_thread(func, *args) File "/usr/local/lib/python3.8/dist-packages/anyio/_backends/_asyncio.py", line 970, in run_async_from_thread return f.result() File "/usr/lib/python3.8/concurrent/futures/_base.py", line 444, in result return self.__get_result() File "/usr/lib/python3.8/concurrent/futures/_base.py", line 389, in __get_result raise self._exception File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/migrations/env.py", line 141, in apply_migrations await connection.run_sync(do_run_migrations) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/ext/asyncio/engine.py", line 536, in run_sync return await greenlet_spawn(fn, conn, *arg, **kw) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 136, in greenlet_spawn result = context.switch(value) File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/migrations/env.py", line 129, in do_run_migrations context.run_migrations() File "<string>", line 8, in run_migrations File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/environment.py", line 851, in run_migrations self.get_context().run_migrations(**kw) File "/usr/local/lib/python3.8/dist-packages/alembic/runtime/migration.py", line 620, in run_migrations step.migration_fn(**kw) File "/home/komal/.local/lib/python3.8/site-packages/prefect/orion/database/migrations/versions/sqlite/2022_01_20_115236_9725c1cbee35_initial_migration.py", line 25, in upgrade op.create_table( File "<string>", line 8, in create_table File "<string>", line 3, in create_table File "/usr/local/lib/python3.8/dist-packages/alembic/operations/ops.py", line 1254, in create_table return operations.invoke(op) File "/usr/local/lib/python3.8/dist-packages/alembic/operations/base.py", line 392, in invoke return fn(self, operation) File "/usr/local/lib/python3.8/dist-packages/alembic/operations/toimpl.py", line 114, in create_table operations.impl.create_table(table) File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 352, in create_table self._exec(schema.CreateTable(table)) File "/usr/local/lib/python3.8/dist-packages/alembic/ddl/impl.py", line 193, in _exec return conn.execute(construct, multiparams) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/future/engine.py", line 280, in execute return self._execute_20( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1614, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py", line 77, in _execute_on_connection return connection._execute_ddl( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1381, in _execute_ddl ret = self._execute_context( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context self._handle_dbapi_exception( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception util.raise_( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_ raise exception File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context self.dialect.do_execute( File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 719, in do_execute cursor.execute(statement, parameters) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 100, in execute self._adapt_connection._handle_exception(error) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 229, in _handle_exception raise error File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 82, in execute self.await_(_cursor.execute(operation, parameters)) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 76, in await_only return current.driver.switch(awaitable) File "/home/komal/.local/lib/python3.8/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 129, in greenlet_spawn value = await result File "/usr/local/lib/python3.8/dist-packages/aiosqlite/cursor.py", line 37, in execute await self._execute(self._cursor.execute, sql, parameters) File "/usr/local/lib/python3.8/dist-packages/aiosqlite/cursor.py", line 31, in _execute return await self._conn._execute(fn, *args, **kwargs) File "/usr/local/lib/python3.8/dist-packages/aiosqlite/core.py", line 129, in _execute return await future File "/usr/local/lib/python3.8/dist-packages/aiosqlite/core.py", line 102, in run result = function() sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table flow already exists [SQL: CREATE TABLE flow ( id CHAR(36) DEFAULT ( ( lower(hex(randomblob(4))) || '-' || lower(hex(randomblob(2))) || '-4' || substr(lower(hex(randomblob(2))),2) || '-' || substr('89ab',abs(random()) % 4 + 1, 1) || substr(lower(hex(randomblob(2))),2) || '-' || lower(hex(randomblob(6))) ) ) NOT NULL, created DATETIME DEFAULT (strftime('%Y-%m-%d %H:%M:%f000', 'now')) NOT NULL, updated DATETIME DEFAULT (strftime('%Y-%m-%d %H:%M:%f000', 'now')) NOT NULL, name VARCHAR NOT NULL, tags JSON DEFAULT '[]' NOT NULL, CONSTRAINT pk_flow PRIMARY KEY (id), CONSTRAINT uq_flow__name UNIQUE (name) ) ] (Background on this error at: https://sqlalche.me/e/14/e3q8) An exception occurred.
ls ~/.prefect doesn't show orion.db
a

Anna Geller

11/20/2022, 3:37 PM
Try in a new environment with fresh Prefect install or try the last option using Prefect Cloud
👍 1
k

komal azram

11/21/2022, 6:14 AM
Thankyou
🙌 1