Created
November 27, 2025 07:30
-
-
Save valleybay/bb1bd9717596826e125b0343fb20c64a to your computer and use it in GitHub Desktop.
database-is-locked
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [SQL: UPDATE deployment SET last_polled=:last_polled, status=:status, updated=strftime('%Y-%m-%d %H:%M:%f000', 'now') WHERE deployment.id IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1) OR deployment.work_queue_id IN (:work_queue_id_1_1)] | |
| [parameters: {'last_polled': '2025-11-27 07:28:39.122522', 'status': 'READY', 'work_queue_id_1_1': '442d6c33-d7f7-4259-9b9d-c1f7eeedd9fd'}] | |
| (Background on this error at: https://sqlalche.me/e/20/e3q8) | |
| 07:28:51.249 | ERROR | docket.worker - ↫ [ 22ms] mark_deployments_ready(work_queue_ids=...){06927fdb-320c-778c-8000-435411644f8e} | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, 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 "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 672, in _execute | |
| result = await self._run_function_with_timeout( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 784, in _run_function_with_timeout | |
| result = await asyncio.wait_for( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/asyncio/tasks.py", line 520, in wait_for | |
| return await fut | |
| ^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/prefect/server/models/deployments.py", line 1125, in mark_deployments_ready | |
| await session.execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/ext/asyncio/session.py", line 449, in execute | |
| result = await greenlet_spawn( | |
| ^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn | |
| result = context.throw(*sys.exc_info()) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2351, in execute | |
| return self._execute_internal( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal | |
| result: Result[Any] = compile_state_cls.orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1660, in orm_execute_statement | |
| return super().orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement | |
| result = conn.execute( | |
| ^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute | |
| return meth( | |
| ^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection | |
| return connection._execute_clauseelement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement | |
| ret = self._execute_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context | |
| return self._exec_single_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context | |
| self._handle_dbapi_exception( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception | |
| raise sqlalchemy_exception.with_traceback(exc_info[2]) from e | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, in run | |
| result = function() | |
| ^^^^^^^^^^ | |
| sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked | |
| [SQL: UPDATE deployment SET last_polled=:last_polled, status=:status, updated=strftime('%Y-%m-%d %H:%M:%f000', 'now') WHERE deployment.id IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1) OR deployment.work_queue_id IN (:work_queue_id_1_1)] | |
| [parameters: {'last_polled': '2025-11-27 07:28:51.235377', 'status': 'READY', 'work_queue_id_1_1': '442d6c33-d7f7-4259-9b9d-c1f7eeedd9fd'}] | |
| (Background on this error at: https://sqlalche.me/e/20/e3q8) | |
| 07:29:00.106 | ERROR | docket.worker - ↫ [ 23ms] mark_deployments_ready(work_queue_ids=...){06927fdb-c0ef-7fde-8000-3277ec6377e4} | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, 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 "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 672, in _execute | |
| result = await self._run_function_with_timeout( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 784, in _run_function_with_timeout | |
| result = await asyncio.wait_for( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/asyncio/tasks.py", line 520, in wait_for | |
| return await fut | |
| ^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/prefect/server/models/deployments.py", line 1125, in mark_deployments_ready | |
| await session.execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/ext/asyncio/session.py", line 449, in execute | |
| result = await greenlet_spawn( | |
| ^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn | |
| result = context.throw(*sys.exc_info()) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2351, in execute | |
| return self._execute_internal( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal | |
| result: Result[Any] = compile_state_cls.orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1660, in orm_execute_statement | |
| return super().orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement | |
| result = conn.execute( | |
| ^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute | |
| return meth( | |
| ^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection | |
| return connection._execute_clauseelement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement | |
| ret = self._execute_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context | |
| return self._exec_single_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context | |
| self._handle_dbapi_exception( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception | |
| raise sqlalchemy_exception.with_traceback(exc_info[2]) from e | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, in run | |
| result = function() | |
| ^^^^^^^^^^ | |
| sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked | |
| [SQL: UPDATE deployment SET last_polled=:last_polled, status=:status, updated=strftime('%Y-%m-%d %H:%M:%f000', 'now') WHERE deployment.id IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1) OR deployment.work_queue_id IN (:work_queue_id_1_1)] | |
| [parameters: {'last_polled': '2025-11-27 07:29:00.087761', 'status': 'READY', 'work_queue_id_1_1': '442d6c33-d7f7-4259-9b9d-c1f7eeedd9fd'}] | |
| (Background on this error at: https://sqlalche.me/e/20/e3q8) | |
| 07:29:10.693 | ERROR | docket.worker - ↫ [ 23ms] mark_deployments_ready(work_queue_ids=...){06927fdc-6879-7502-8000-9e5be4113122} | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, 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 "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 672, in _execute | |
| result = await self._run_function_with_timeout( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/docket/worker.py", line 784, in _run_function_with_timeout | |
| result = await asyncio.wait_for( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/asyncio/tasks.py", line 520, in wait_for | |
| return await fut | |
| ^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/prefect/server/models/deployments.py", line 1125, in mark_deployments_ready | |
| await session.execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/ext/asyncio/session.py", line 449, in execute | |
| result = await greenlet_spawn( | |
| ^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn | |
| result = context.throw(*sys.exc_info()) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2351, in execute | |
| return self._execute_internal( | |
| ^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal | |
| result: Result[Any] = compile_state_cls.orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1660, in orm_execute_statement | |
| return super().orm_execute_statement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement | |
| result = conn.execute( | |
| ^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1419, in execute | |
| return meth( | |
| ^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 526, in _execute_on_connection | |
| return connection._execute_clauseelement( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement | |
| ret = self._execute_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context | |
| return self._exec_single_context( | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context | |
| self._handle_dbapi_exception( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception | |
| raise sqlalchemy_exception.with_traceback(exc_info[2]) from e | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context | |
| self.dialect.do_execute( | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute | |
| cursor.execute(statement, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 180, in execute | |
| self._adapt_connection._handle_exception(error) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 340, in _handle_exception | |
| raise error | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/sqlite/aiosqlite.py", line 162, in execute | |
| self.await_(_cursor.execute(operation, parameters)) | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only | |
| return current.parent.switch(awaitable) # type: ignore[no-any-return,attr-defined] # noqa: E501 | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn | |
| value = await result | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 40, in execute | |
| await self._execute(self._cursor.execute, sql, parameters) | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/cursor.py", line 32, in _execute | |
| return await self._conn._execute(fn, *args, **kwargs) | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 122, in _execute | |
| return await future | |
| ^^^^^^^^^^^^ | |
| File "/usr/local/lib/python3.12/site-packages/aiosqlite/core.py", line 105, in run | |
| result = function() | |
| ^^^^^^^^^^ | |
| sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked | |
| [SQL: UPDATE deployment SET last_polled=:last_polled, status=:status, updated=strftime('%Y-%m-%d %H:%M:%f000', 'now') WHERE deployment.id IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1) OR deployment.work_queue_id IN (:work_queue_id_1_1)] | |
| [parameters: {'last_polled': '2025-11-27 07:29:10.676965', 'status': 'READY', 'work_queue_id_1_1': '442d6c33-d7f7-4259-9b9d-c1f7eeedd9fd'}] | |
| (Background on this error at: https://sqlalche.me/e/20/e3q8) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment