hey everyone I had to restart my virtual environment and now

Question

hey everyone I had to restart my virtual environment and now I am getting a 500 error

Emil Christensen · Answer

```prefect config set PREFECT API URL=<http 127 0 0 1 4200 api>```

Rob Manzaro · Answer

12 51 22 172 | ERROR | prefect server Encountered exception in request Traceback most recent call last File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File C GitHub PACC prefect env lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File C GitHub PACC prefect env lib site packages aiosqlite core py line 133 in execute return await future File C GitHub PACC prefect env lib site packages aiosqlite core py line 106 in run result = function sqlite3 OperationalError no such table json each The above exception was the direct cause of the following exception Traceback most recent call last File C GitHub PACC prefect env lib site packages starlette middleware errors py line 162 in call await scope receive send File C GitHub PACC prefect env lib site packages starlette middleware gzip py line 24 in call await responder scope receive send File C GitHub PACC prefect env lib site packages starlette middleware gzip py line 44 in call await scope receive self send with gzip File C GitHub PACC prefect env lib site packages starlette middleware exceptions py line 79 in call raise exc File C GitHub PACC prefect env lib site packages starlette middleware exceptions py line 68 in call await scope receive sender File C GitHub PACC prefect env lib site packages fastapi middleware asyncexitstack py line 20 in call raise e File C GitHub PACC prefect env lib site packages fastapi middleware asyncexitstack py line 17 in call await scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 718 in call await route handle scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 276 in handle await scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 66 in app response = await func request File C GitHub PACC prefect env lib site packages prefect server utilities server py line 103 in handle response scoped depends response = await default handler request File C GitHub PACC prefect env lib site packages fastapi routing py line 273 in app raw response = await run endpoint function File C GitHub PACC prefect env lib site packages fastapi routing py line 190 in run endpoint function return await dependant call values File C GitHub PACC prefect env lib site packages prefect server api flow runs py line 62 in create flow run model = await models flow runs create flow run File C GitHub PACC prefect env lib site packages prefect server database dependencies py line 119 in async wrapper return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect server models flow runs py line 105 in create flow run await models flow runs set flow run state File C GitHub PACC prefect env lib site packages prefect server models flow runs py line 517 in set flow run state await models flow run notification policies queue flow run notifications File C GitHub PACC prefect env lib site packages prefect server database dependencies py line 119 in async wrapper return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect server models flow run notification policies py line 172 in queue flow run notifications await db queries queue flow run notifications File C GitHub PACC prefect env lib site packages prefect server database query components py line 146 in queue flow run notifications await session execute stmt File C GitHub PACC prefect env lib site packages sqlalchemy ext asyncio session py line 454 in execute result = await greenlet spawn File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 190 in greenlet spawn result = context throw sys exc info File C GitHub PACC prefect env lib site packages sqlalchemy orm session py line 2262 in execute return self execute internal File C GitHub PACC prefect env lib site packages sqlalchemy orm session py line 2144 in execute internal result Result Any = compile state cls orm execute statement File C GitHub PACC prefect env lib site packages sqlalchemy orm bulk persistence py line 1276 in orm execute statement result = conn execute File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1412 in execute return meth File C GitHub PACC prefect env lib site packages sqlalchemy sql elements py line 515 in execute on connection return connection execute clauseelement File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1635 in execute clauseelement ret = self execute context File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1844 in execute context return self exec single context File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1984 in exec single context self handle dbapi exception File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 2339 in handle dbapi exception raise sqlalchemy exception with traceback exc info 2 from e File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File C GitHub PACC prefect env lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File C GitHub PACC prefect env lib site packages aiosqlite core py line 133 in execute return await future File C GitHub PACC prefect env lib site packages aiosqlite core py line 106 in run result = function sqlalchemy exc OperationalError sqlite3 OperationalError no such table json each SQL INSERT INTO flow run notification queue flow run notification policy id flow run state id SELECT flow run notification policy id CAST param 1 AS CHAR 36 AS anon 1 FROM flow run notification policy WHERE flow run notification policy is active IS 1 AND flow run notification policy state names = state names 1 OR EXISTS SELECT 1 FROM json each flow run notification policy state names AS json each WHERE json each value IN json each values 1 1 AND flow run notification policy tags = tags 1 OR EXISTS SELECT 1 FROM json each flow run notification policy tags AS json each WHERE json each value IN SELECT 1 FROM SELECT 1 WHERE 1 =1 parameters param 1 a66a3fba 36b8 4898 8fc8 09e8f55d381e state names 1 tags 1 json each values 1 1 Pending Background on this error at Traceback most recent call last File flowtest py line 10 in lt module gt test flow File C GitHub PACC prefect env lib site packages prefect flows py line 540 in call return enter flow run engine from flow call File C GitHub PACC prefect env lib site packages prefect engine py line 272 in enter flow run engine from flow call retval = from sync wait for call in loop thread File C GitHub PACC prefect env lib site packages prefect internal concurrency api py line 243 in wait for call in loop thread return call result File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 283 in result return self future result timeout=timeout File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 169 in result return self get result File C Python38 lib concurrent futures base py line 389 in get result raise self exception File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 346 in run async result = await coro File C GitHub PACC prefect env lib site packages prefect client utilities py line 51 in with injected client return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect engine py line 338 in create then begin flow run flow run = await client create flow run File C GitHub PACC prefect env lib site packages prefect client orchestration py line 596 in create flow run response = await flow runs json=flow run create json File C GitHub PACC prefect env lib site packages httpx client py line 1848 in post return await self request File C GitHub PACC prefect env lib site packages httpx client py line 1530 in request return await self send request auth=auth follow redirects=follow redirects File C GitHub PACC prefect env lib site packages prefect client base py line 280 in send response raise for status File C GitHub PACC prefect env lib site packages prefect client base py line 138 in raise for status raise PrefectHTTPStatusError from httpx error exc from exc cause prefect exceptions PrefectHTTPStatusError Server error 500 Internal Server Error for url Response exception message Internal Server Error For more information check

Rob Manzaro · Answer

12 51 22 172 | ERROR | prefect server Encountered exception in request Traceback most recent call last File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File C GitHub PACC prefect env lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File C GitHub PACC prefect env lib site packages aiosqlite core py line 133 in execute return await future File C GitHub PACC prefect env lib site packages aiosqlite core py line 106 in run result = function sqlite3 OperationalError no such table json each The above exception was the direct cause of the following exception Traceback most recent call last File C GitHub PACC prefect env lib site packages starlette middleware errors py line 162 in call await scope receive send File C GitHub PACC prefect env lib site packages starlette middleware gzip py line 24 in call await responder scope receive send File C GitHub PACC prefect env lib site packages starlette middleware gzip py line 44 in call await scope receive self send with gzip File C GitHub PACC prefect env lib site packages starlette middleware exceptions py line 79 in call raise exc File C GitHub PACC prefect env lib site packages starlette middleware exceptions py line 68 in call await scope receive sender File C GitHub PACC prefect env lib site packages fastapi middleware asyncexitstack py line 20 in call raise e File C GitHub PACC prefect env lib site packages fastapi middleware asyncexitstack py line 17 in call await scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 718 in call await route handle scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 276 in handle await scope receive send File C GitHub PACC prefect env lib site packages starlette routing py line 66 in app response = await func request File C GitHub PACC prefect env lib site packages prefect server utilities server py line 103 in handle response scoped depends response = await default handler request File C GitHub PACC prefect env lib site packages fastapi routing py line 273 in app raw response = await run endpoint function File C GitHub PACC prefect env lib site packages fastapi routing py line 190 in run endpoint function return await dependant call values File C GitHub PACC prefect env lib site packages prefect server api flow runs py line 62 in create flow run model = await models flow runs create flow run File C GitHub PACC prefect env lib site packages prefect server database dependencies py line 119 in async wrapper return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect server models flow runs py line 105 in create flow run await models flow runs set flow run state File C GitHub PACC prefect env lib site packages prefect server models flow runs py line 517 in set flow run state await models flow run notification policies queue flow run notifications File C GitHub PACC prefect env lib site packages prefect server database dependencies py line 119 in async wrapper return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect server models flow run notification policies py line 172 in queue flow run notifications await db queries queue flow run notifications File C GitHub PACC prefect env lib site packages prefect server database query components py line 146 in queue flow run notifications await session execute stmt File C GitHub PACC prefect env lib site packages sqlalchemy ext asyncio session py line 454 in execute result = await greenlet spawn File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 190 in greenlet spawn result = context throw sys exc info File C GitHub PACC prefect env lib site packages sqlalchemy orm session py line 2262 in execute return self execute internal File C GitHub PACC prefect env lib site packages sqlalchemy orm session py line 2144 in execute internal result Result Any = compile state cls orm execute statement File C GitHub PACC prefect env lib site packages sqlalchemy orm bulk persistence py line 1276 in orm execute statement result = conn execute File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1412 in execute return meth File C GitHub PACC prefect env lib site packages sqlalchemy sql elements py line 515 in execute on connection return connection execute clauseelement File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1635 in execute clauseelement ret = self execute context File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1844 in execute context return self exec single context File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1984 in exec single context self handle dbapi exception File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 2339 in handle dbapi exception raise sqlalchemy exception with traceback exc info 2 from e File C GitHub PACC prefect env lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File C GitHub PACC prefect env lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File C GitHub PACC prefect env lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File C GitHub PACC prefect env lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File C GitHub PACC prefect env lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File C GitHub PACC prefect env lib site packages aiosqlite core py line 133 in execute return await future File C GitHub PACC prefect env lib site packages aiosqlite core py line 106 in run result = function sqlalchemy exc OperationalError sqlite3 OperationalError no such table json each SQL INSERT INTO flow run notification queue flow run notification policy id flow run state id SELECT flow run notification policy id CAST param 1 AS CHAR 36 AS anon 1 FROM flow run notification policy WHERE flow run notification policy is active IS 1 AND flow run notification policy state names = state names 1 OR EXISTS SELECT 1 FROM json each flow run notification policy state names AS json each WHERE json each value IN json each values 1 1 AND flow run notification policy tags = tags 1 OR EXISTS SELECT 1 FROM json each flow run notification policy tags AS json each WHERE json each value IN SELECT 1 FROM SELECT 1 WHERE 1 =1 parameters param 1 a66a3fba 36b8 4898 8fc8 09e8f55d381e state names 1 tags 1 json each values 1 1 Pending Background on this error at Traceback most recent call last File flowtest py line 10 in lt module gt test flow File C GitHub PACC prefect env lib site packages prefect flows py line 540 in call return enter flow run engine from flow call File C GitHub PACC prefect env lib site packages prefect engine py line 272 in enter flow run engine from flow call retval = from sync wait for call in loop thread File C GitHub PACC prefect env lib site packages prefect internal concurrency api py line 243 in wait for call in loop thread return call result File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 283 in result return self future result timeout=timeout File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 169 in result return self get result File C Python38 lib concurrent futures base py line 389 in get result raise self exception File C GitHub PACC prefect env lib site packages prefect internal concurrency calls py line 346 in run async result = await coro File C GitHub PACC prefect env lib site packages prefect client utilities py line 51 in with injected client return await fn args kwargs File C GitHub PACC prefect env lib site packages prefect engine py line 338 in create then begin flow run flow run = await client create flow run File C GitHub PACC prefect env lib site packages prefect client orchestration py line 596 in create flow run response = await flow runs json=flow run create json File C GitHub PACC prefect env lib site packages httpx client py line 1848 in post return await self request File C GitHub PACC prefect env lib site packages httpx client py line 1530 in request return await self send request auth=auth follow redirects=follow redirects File C GitHub PACC prefect env lib site packages prefect client base py line 280 in send response raise for status File C GitHub PACC prefect env lib site packages prefect client base py line 138 in raise for status raise PrefectHTTPStatusError from httpx error exc from exc cause prefect exceptions PrefectHTTPStatusError Server error 500 Internal Server Error for url Response exception message Internal Server Error For more information check

Emil Christensen · Answer

Emil Christensen · Answer

Rob Manzaro · Answer

< Emil Christensen> All set python 3 10 virtual environment did the trick

Emil Christensen · Answer

raised hands

Rob Manzaro · Answer

thank you again for your help

Rob Manzaro · Answer

just like old times haha

giphy · Answer

let s go

Emil Christensen · Answer

smile glad that did the trick