I have just started using prefect 2 and nothing seems workin

Question

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 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 An exception occurred can someone help me with this I am using ubutu 20 04

Anna Geller · Answer

I answered here <https discourse prefect io t when i try to start orion i get sqlite3 operationalerror table flow already exists how to troubleshoot this 1933>

komal azram · Answer

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 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 lt frozen importlib bootstrap external gt line 848 in exec module File lt frozen importlib bootstrap gt 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 lt module gt 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 lt string gt 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 lt string gt line 8 in create table File lt string gt 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 An exception occurred

komal azram · Answer

ls ~ prefect doesn t show orion db

Anna Geller · Answer

Try in a new environment with fresh Prefect install or try the last option using Prefect Cloud

komal azram · Answer

Thankyou