Hi team I m getting a sqllite database is locked error

Question

Ronald Sam · Answer

here s my stack trace

Ronald Sam · Answer

Worker ProcessWorker 97e45821 c4f4 4bb2 8e31 b3c883b23c92 started 15 54 36 552 | ERROR | prefect server Encountered exception in request Traceback most recent call last File D Prefect venv lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File D Prefect venv lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File D Prefect venv lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File D Prefect venv lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File D Prefect venv lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File D Prefect venv lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File D Prefect venv lib site packages aiosqlite core py line 133 in execute return await future File D Prefect venv lib site packages aiosqlite core py line 106 in run result = function sqlite3 OperationalError database is locked The above exception was the direct cause of the following exception Traceback most recent call last File D Prefect venv lib site packages starlette middleware errors py line 162 in call await scope receive send File D Prefect venv lib site packages starlette middleware gzip py line 24 in call await responder scope receive send File D Prefect venv lib site packages starlette middleware gzip py line 44 in call await scope receive self send with gzip File D Prefect venv lib site packages starlette middleware exceptions py line 79 in call raise exc File D Prefect venv lib site packages starlette middleware exceptions py line 68 in call await scope receive sender File D Prefect venv lib site packages fastapi middleware asyncexitstack py line 20 in call raise e File D Prefect venv lib site packages fastapi middleware asyncexitstack py line 17 in call await scope receive send File D Prefect venv lib site packages starlette routing py line 718 in call await route handle scope receive send File D Prefect venv lib site packages starlette routing py line 276 in handle await scope receive send File D Prefect venv lib site packages starlette routing py line 66 in app response = await func request File D Prefect venv lib site packages prefect server utilities server py line 103 in handle response scoped depends response = await default handler request File D Prefect venv lib site packages fastapi routing py line 273 in app raw response = await run endpoint function File D Prefect venv lib site packages fastapi routing py line 190 in run endpoint function return await dependant call values File D Prefect venv lib site packages prefect server api workers py line 539 in worker heartbeat await models workers worker heartbeat File D Prefect venv lib site packages prefect server database dependencies py line 119 in async wrapper return await fn args kwargs File D Prefect venv lib site packages prefect server models workers py line 609 in worker heartbeat result = await session execute insert stmt File D Prefect venv lib site packages sqlalchemy ext asyncio session py line 439 in execute result = await greenlet spawn File D Prefect venv lib site packages sqlalchemy util concurrency py3k py line 190 in greenlet spawn result = context throw sys exc info File D Prefect venv lib site packages sqlalchemy orm session py line 2246 in execute return self execute internal File D Prefect venv lib site packages sqlalchemy orm session py line 2141 in execute internal result Result Any = compile state cls orm execute statement File D Prefect venv lib site packages sqlalchemy orm bulk persistence py line 1272 in orm execute statement result = conn execute File D Prefect venv lib site packages sqlalchemy engine base py line 1412 in execute return meth File D Prefect venv lib site packages sqlalchemy sql elements py line 483 in execute on connection return connection execute clauseelement File D Prefect venv lib site packages sqlalchemy engine base py line 1635 in execute clauseelement ret = self execute context File D Prefect venv lib site packages sqlalchemy engine base py line 1844 in execute context return self exec single context File D Prefect venv lib site packages sqlalchemy engine base py line 1984 in exec single context self handle dbapi exception File D Prefect venv lib site packages sqlalchemy engine base py line 2339 in handle dbapi exception raise sqlalchemy exception with traceback exc info 2 from e File D Prefect venv lib site packages sqlalchemy engine base py line 1965 in exec single context self dialect do execute File D Prefect venv lib site packages sqlalchemy engine default py line 921 in do execute cursor execute statement parameters File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 113 in execute self adapt connection handle exception error File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 263 in handle exception raise error File D Prefect venv lib site packages sqlalchemy dialects sqlite aiosqlite py line 95 in execute self await cursor execute operation parameters File D Prefect venv lib site packages sqlalchemy util concurrency py3k py line 125 in await only return current driver switch awaitable type ignore no any return File D Prefect venv lib site packages sqlalchemy util concurrency py3k py line 185 in greenlet spawn value = await result File D Prefect venv lib site packages aiosqlite cursor py line 48 in execute await self execute self cursor execute sql parameters File D Prefect venv lib site packages aiosqlite cursor py line 40 in execute return await self conn execute fn args kwargs File D Prefect venv lib site packages aiosqlite core py line 133 in execute return await future File D Prefect venv lib site packages aiosqlite core py line 106 in run result = function sqlalchemy exc OperationalError sqlite3 OperationalError database is locked SQL INSERT INTO worker name last heartbeat time work pool id id created updated VALUES name last heartbeat time work pool id id created updated ON CONFLICT work pool id name DO UPDATE SET last heartbeat time = param 1 parameters name ProcessWorker 97e45821 c4f4 4bb2 8e31 b3c883b23c92 last heartbeat time 2023 07 25 15 54 36 546542 work pool id 51dd9272 b47f 40ef b7f7 020539255582 id 0a39d0a7 486f 4aba 9b61 1497fc05e0d8 created 2023 07 25 15 54 36 546542 updated 2023 07 25 15 54 36 546542 param 1 2023 07 25 15 54 36 546542 Background on this error at

Ronald Sam · Answer

This is a new install and I m using windows

Ronald Sam · Answer

any ideas on how to resolve please

Ronald Sam · Answer

hi < Taylor Curran> any idea on how to resolve this