Seeing the following `run migrations` error using Prefect 2

Question

Seeing the following `run migrations` error using Prefect 2 7 0 full traceback in the reply Anyone familiar with this

Sean Conroy · Answer

```Traceback most recent call last File usr local lib python3 8 dist packages flask app py line 2073 in wsgi app response = self full dispatch request File usr local lib python3 8 dist packages flask app py line 1518 in full dispatch request rv = self handle user exception e File usr local lib python3 8 dist packages flask app py line 1516 in full dispatch request rv = self dispatch request File usr local lib python3 8 dist packages flask app py line 1502 in dispatch request return self ensure sync self view functions req view args File main py line 99 in default route main location state = location flow atcore event ou event location version dict account id return state=True File usr local lib python3 8 dist packages prefect flows py line 442 in call return enter flow run engine from flow call File usr local lib python3 8 dist packages prefect engine py line 157 in enter flow run engine from flow call return anyio run begin run 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 usr local lib python3 8 dist packages prefect client utilities py line 45 in with injected client async with client context as new client File usr local lib python3 8 dist packages prefect client orion py line 1868 in aenter self ephemeral lifespan = await self exit stack enter async context File usr lib python3 8 contextlib py line 568 in enter async context result = await cm type aenter cm File usr lib python3 8 contextlib py line 171 in aenter return await self gen anext File usr local lib python3 8 dist packages prefect client base py line 85 in app lifespan context await context aenter File usr local lib python3 8 dist packages asgi lifespan manager py line 92 in aenter await self exit stack aclose File usr lib python3 8 contextlib py line 621 in aclose await self aexit None None None File usr lib python3 8 contextlib py line 679 in aexit raise exc details 1 File usr lib python3 8 contextlib py line 662 in aexit cb suppress = await cb exc details File usr local lib python3 8 dist packages asgi lifespan concurrency asyncio py line 80 in aexit await self task File usr local lib python3 8 dist packages asgi lifespan manager py line 90 in aenter await self startup File usr local lib python3 8 dist packages asgi lifespan manager py line 36 in startup raise self app exception File usr local lib python3 8 dist packages asgi lifespan concurrency asyncio py line 63 in run and silence cancelled await self coroutine File usr local lib python3 8 dist packages asgi lifespan manager py line 64 in run app await scope self receive self send File usr local lib python3 8 dist packages fastapi applications py line 270 in call await super call scope receive send File usr local lib python3 8 dist packages starlette applications py line 124 in call await self middleware stack scope receive send File usr local lib python3 8 dist packages starlette middleware errors py line 149 in call await scope receive send File usr local lib python3 8 dist packages starlette middleware cors py line 76 in call await scope receive send File usr local lib python3 8 dist packages starlette middleware exceptions py line 55 in call await scope receive send File usr local lib python3 8 dist packages fastapi middleware asyncexitstack py line 21 in call raise e File usr local lib python3 8 dist packages fastapi middleware asyncexitstack py line 18 in call await scope receive send File usr local lib python3 8 dist packages starlette routing py line 695 in call await self lifespan scope receive send File usr local lib python3 8 dist packages starlette routing py line 671 in lifespan async with self lifespan context app File usr local lib python3 8 dist packages starlette routing py line 566 in aenter await self router startup File usr local lib python3 8 dist packages starlette routing py line 648 in startup await handler File usr local lib python3 8 dist packages prefect orion api server py line 345 in run migrations await db create db File usr local lib python3 8 dist packages prefect orion database interface py line 55 in create db await self run migrations upgrade File usr local lib python3 8 dist packages prefect orion database interface py line 63 in run migrations upgrade await run sync in worker thread alembic upgrade File usr local lib python3 8 dist packages prefect utilities asyncutils py line 68 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 usr local lib python3 8 dist 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 322 in upgrade script run env File usr local lib python3 8 dist packages alembic script base py line 569 in run env util load python file self dir env py File usr local lib python3 8 dist packages alembic util pyfiles py line 94 in load python file module = load module py module id path File usr local lib python3 8 dist packages alembic util pyfiles py line 110 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 usr local lib python3 8 dist packages prefect orion database migrations env py line 147 in lt module gt apply migrations File usr local lib python3 8 dist packages prefect utilities asyncutils py line 197 in coroutine wrapper return run async from worker thread async fn args kwargs File usr local lib python3 8 dist packages prefect utilities asyncutils py line 148 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 usr local lib python3 8 dist packages prefect orion database migrations env py line 141 in apply migrations await connection run sync do run migrations File usr local lib python3 8 dist packages sqlalchemy ext asyncio engine py line 548 in run sync return await greenlet spawn fn conn arg kw File usr local lib python3 8 dist packages sqlalchemy util concurrency py3k py line 128 in greenlet spawn result = context switch value File usr local lib python3 8 dist 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 853 in run migrations```

Zanie · Answer

Hmm where s the actual error I think we need more still slightly smiling face

Sean Conroy · Answer

I know Unfortunately that s where it cuts off not sure if GCP maxxed out on the traceback or something However there is this error right above it ```Traceback most recent call last File usr local lib python3 8 dist packages sqlalchemy engine base py line 1900 in execute context self dialect do execute File usr local lib python3 8 dist packages sqlalchemy engine default py line 736 in do execute cursor execute statement parameters File usr local lib python3 8 dist packages sqlalchemy dialects sqlite aiosqlite py line 108 in execute self adapt connection handle exception error File usr local lib python3 8 dist packages sqlalchemy dialects sqlite aiosqlite py line 236 in handle exception raise error File usr local lib python3 8 dist packages sqlalchemy dialects sqlite aiosqlite py line 90 in execute self await cursor execute operation parameters File usr local lib python3 8 dist packages sqlalchemy util concurrency py3k py line 68 in await only return current driver switch awaitable File usr local lib python3 8 dist packages sqlalchemy util concurrency py3k py line 121 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 block type already exists```

Zanie · Answer

This might be related to <https github com PrefectHQ prefect pull 7789>

Sean Conroy · Answer

Yes I was hoping this would be resolved by the latest release Unfortunately I m using `git+<https github com PrefectHQ prefect main>` to install Prefect and I built the docker image this morning so it looks like it s still an issue

Zanie · Answer

cry

Zanie · Answer

If you can get ahold of a full traceback and open an issue we ll investigate

John-Craig Borman · Answer

I am also encountering the same issue when trying to standup the orion webserver to run some tests against the orion client I can t get the FastAPI app to start because `block type` already exists

John-Craig Borman · Answer

``` Captured stderr call ERROR Traceback most recent call last File usr local lib python3 10 dist packages sqlalchemy engine base py line 1900 in execute context self dialect do execute File usr local lib python3 10 dist packages sqlalchemy engine default py line 736 in do execute cursor execute statement parameters File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 108 in execute self adapt connection handle exception error File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 236 in handle exception raise error File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 90 in execute self await cursor execute operation parameters File usr local lib python3 10 dist packages sqlalchemy util concurrency py3k py line 68 in await only return current driver switch awaitable File usr local lib python3 10 dist packages sqlalchemy util concurrency py3k py line 121 in greenlet spawn value = await result File usr local lib python3 10 dist packages aiosqlite cursor py line 37 in execute await self execute self cursor execute sql parameters File usr local lib python3 10 dist packages aiosqlite cursor py line 31 in execute return await self conn execute fn args kwargs File usr local lib python3 10 dist packages aiosqlite core py line 129 in execute return await future File usr local lib python3 10 dist packages aiosqlite core py line 102 in run result = function sqlite3 OperationalError table block type already exists The above exception was the direct cause of the following exception Traceback most recent call last File usr local lib python3 10 dist packages starlette routing py line 671 in lifespan async with self lifespan context app File usr local lib python3 10 dist packages starlette routing py line 566 in aenter await self router startup File usr local lib python3 10 dist packages starlette routing py line 648 in startup await handler File usr local lib python3 10 dist packages prefect orion api server py line 345 in run migrations await db create db File usr local lib python3 10 dist packages prefect orion database interface py line 55 in create db await self run migrations upgrade File usr local lib python3 10 dist packages prefect orion database interface py line 63 in run migrations upgrade await run sync in worker thread alembic upgrade File usr local lib python3 10 dist packages prefect utilities asyncutils py line 69 in run sync in worker thread return await anyio to thread run sync call cancellable=True File usr local lib python3 10 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 10 dist packages anyio backends asyncio py line 937 in run sync in worker thread return await future File usr local lib python3 10 dist packages anyio backends asyncio py line 867 in run result = context run func args File usr local lib python3 10 dist packages prefect orion database alembic commands py line 24 in wrapper return fn args kwargs File usr local lib python3 10 dist packages prefect orion database alembic commands py line 53 in alembic upgrade alembic command upgrade alembic config revision sql=dry run File usr local lib python3 10 dist packages alembic command py line 322 in upgrade script run env File usr local lib python3 10 dist packages alembic script base py line 569 in run env util load python file self dir env py File usr local lib python3 10 dist packages alembic util pyfiles py line 94 in load python file module = load module py module id path File usr local lib python3 10 dist packages alembic util pyfiles py line 110 in load module py spec loader exec module module type ignore File lt frozen importlib bootstrap external gt line 883 in exec module File lt frozen importlib bootstrap gt line 241 in call with frames removed File usr local lib python3 10 dist packages prefect orion database migrations env py line 147 in lt module gt apply migrations File usr local lib python3 10 dist packages prefect utilities asyncutils py line 201 in coroutine wrapper return run async from worker thread async fn args kwargs File usr local lib python3 10 dist packages prefect utilities asyncutils py line 152 in run async from worker thread return anyio from thread run call File usr local lib python3 10 dist packages anyio from thread py line 49 in run return asynclib run async from thread func args File usr local lib python3 10 dist packages anyio backends asyncio py line 970 in run async from thread return f result File usr lib python3 10 concurrent futures base py line 458 in result return self get result File usr lib python3 10 concurrent futures base py line 403 in get result raise self exception File usr local lib python3 10 dist packages prefect orion database migrations env py line 141 in apply migrations await connection run sync do run migrations File usr local lib python3 10 dist packages sqlalchemy ext asyncio engine py line 548 in run sync return await greenlet spawn fn conn arg kw File usr local lib python3 10 dist packages sqlalchemy util concurrency py3k py line 128 in greenlet spawn result = context switch value File usr local lib python3 10 dist 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 10 dist packages alembic runtime environment py line 853 in run migrations self get context run migrations kw File usr local lib python3 10 dist packages alembic runtime migration py line 623 in run migrations step migration fn kw File usr local lib python3 10 dist packages prefect orion database migrations versions sqlite 2022 04 25 135207 b75d279ba985 replace version with checksum py line 24 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 10 dist packages alembic operations ops py line 1254 in create table return operations invoke op File usr local lib python3 10 dist packages alembic operations base py line 399 in invoke return fn self operation File usr local lib python3 10 dist packages alembic operations toimpl py line 114 in create table operations impl create table table File usr local lib python3 10 dist packages alembic ddl impl py line 354 in create table self exec schema CreateTable table File usr local lib python3 10 dist packages alembic ddl impl py line 195 in exec return conn execute construct multiparams File usr local lib python3 10 dist packages sqlalchemy future engine py line 280 in execute return self execute 20 File usr local lib python3 10 dist packages sqlalchemy engine base py line 1705 in execute 20 return meth self args 10style kwargs 10style execution options File usr local lib python3 10 dist packages sqlalchemy sql ddl py line 80 in execute on connection return connection execute ddl File usr local lib python3 10 dist packages sqlalchemy engine base py line 1472 in execute ddl ret = self execute context File usr local lib python3 10 dist packages sqlalchemy engine base py line 1943 in execute context self handle dbapi exception File usr local lib python3 10 dist packages sqlalchemy engine base py line 2124 in handle dbapi exception util raise File usr local lib python3 10 dist packages sqlalchemy util compat py line 210 in raise raise exception File usr local lib python3 10 dist packages sqlalchemy engine base py line 1900 in execute context self dialect do execute File usr local lib python3 10 dist packages sqlalchemy engine default py line 736 in do execute cursor execute statement parameters File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 108 in execute self adapt connection handle exception error File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 236 in handle exception raise error File usr local lib python3 10 dist packages sqlalchemy dialects sqlite aiosqlite py line 90 in execute self await cursor execute operation parameters File usr local lib python3 10 dist packages sqlalchemy util concurrency py3k py line 68 in await only return current driver switch awaitable File usr local lib python3 10 dist packages sqlalchemy util concurrency py3k py line 121 in greenlet spawn value = await result File usr local lib python3 10 dist packages aiosqlite cursor py line 37 in execute await self execute self cursor execute sql parameters File usr local lib python3 10 dist packages aiosqlite cursor py line 31 in execute return await self conn execute fn args kwargs File usr local lib python3 10 dist packages aiosqlite core py line 129 in execute return await future File usr local lib python3 10 dist packages aiosqlite core py line 102 in run result = function sqlalchemy exc OperationalError sqlite3 OperationalError table block type already exists SQL CREATE TABLE block type 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 logo url VARCHAR documentation url VARCHAR CONSTRAINT pk block type PRIMARY KEY id Background on this error at <https sqlalche me e 14 e3q8> ERROR Application startup failed Exiting ```

Zanie · Answer

Thanks for the report Would you mind opening an issue