0% found this document useful (0 votes)
10 views4 pages

SQLAlchemy Async Error Handling

Uploaded by

Nilay Jain
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views4 pages

SQLAlchemy Async Error Handling

Uploaded by

Nilay Jain
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

factory.

INFO [Link]:52578 - "POST /workspaces/8/pages/44/tasks/308/execute/


HTTP/1.1" 307
2025-08-11 19:11:48,545 INFO [Link] select pg_catalog.version()
2025-08-11 19:11:48,545 INFO [Link] [raw sql] ()
2025-08-11 19:11:48,548 INFO [Link] select current_schema()
2025-08-11 19:11:48,548 INFO [Link] [raw sql] ()
2025-08-11 19:11:48,550 INFO [Link] show
standard_conforming_strings
2025-08-11 19:11:48,550 INFO [Link] [raw sql] ()
2025-08-11 19:11:48,551 INFO [Link] BEGIN (implicit)
2025-08-11 19:11:48,640 INFO [Link] SELECT
page_permissions.permission_level
FROM page_permissions
WHERE page_permissions.user_id = $1::BIGINT AND page_permissions.page_id =
$2::BIGINT
2025-08-11 19:11:48,640 INFO [Link] [generated in 0.00013s] (1,
44)
2025-08-11 19:11:48,659 - alfred - INFO [task_router.py:199] - Starting execution
for task 308 on page 44.
2025-08-11 19:11:48,661 INFO [Link] UPDATE tasks SET status=$1,
updated_at=now() WHERE tasks.task_id = $2::BIGINT AND [Link] = $3 RETURNING
tasks.task_id, tasks.page_id, tasks.block_id, tasks.due_date, [Link],
[Link], tasks.created_at, tasks.updated_at, tasks.task_result
2025-08-11 19:11:48,661 INFO [Link] [generated in 0.00009s]
('InProgress', 308, 'ToDo')
2025-08-11 19:11:48,661 INFO [Link] COMMIT
INFO [Link]:52578 - "POST /workspaces/8/pages/44/tasks/308/execute
HTTP/1.1" 500
ERROR Exception in ASGI application
Traceback (most recent call last):
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 887, in commit
self.await_(self._commit_and_discard())
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/util/_concurrency_py3k.py", line 132, in await_only
return [Link](awaitable) # type: ignore[no-any-return,attr-
defined] # noqa: E501
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/util/_concurrency_py3k.py", line 196, in greenlet_spawn
value = await result
^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 866, in
_commit_and_discard
await self._transaction.commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/asyncpg/[Link]", line 219, in commit
await self.__commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/asyncpg/[Link]", line 187, in __commit
await self._connection.execute(query)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/asyncpg/[Link]", line 349, in execute
result = await self._protocol.query(query, timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "asyncpg/protocol/[Link]", line 360, in query
File "asyncpg/protocol/[Link]", line 745, in
[Link]._check_state
[Link]._base.InterfaceError: cannot perform operation: another
operation is in progress

The above exception was the direct cause of the following exception:

Traceback (most recent call last):


File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 1141, in _commit_impl
[Link].do_commit([Link])
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 706, in do_commit
dbapi_connection.commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 893, in commit
self._handle_exception(error)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 792, in _handle_exception
raise translated_error from error
[Link].AsyncAdapt_asyncpg_dbapi.InterfaceError:
<class '[Link]._base.InterfaceError'>: cannot perform operation:
another operation is in progress

The above exception was the direct cause of the following exception:

Traceback (most recent call last):


File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/uvicorn/protocols/http/httptools_impl.py", line 409, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await [Link](scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/fastapi/[Link]", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/[Link]", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/middleware/[Link]", line 187, in __call__
raise exc
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/middleware/[Link]", line 165, in __call__
await [Link](scope, receive, _send)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/middleware/[Link]", line 85, in __call__
await [Link](scope, receive, send)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/middleware/[Link]", line 176, in __call__
with recv_stream, send_stream, collapse_excgroups():
File "/Users/neerajkumar/.local/share/uv/python/cpython-3.11.12-macos-aarch64-
none/lib/python3.11/[Link]", line 158, in __exit__
[Link](typ, value, traceback)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/_utils.py", line 82, in collapse_excgroups
raise exc
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/starlette/middleware/[Link]", line 178, in __call__
response = await self.dispatch_func(request, call_next)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/alfred_backend/alfred_core/src/alfred/
[Link]", line 38, in db_session_middleware
response: Response = await db_instance.run_in_scope(call_next, request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/alfred_backend/alfred_core/src/alfred/
shared/db/[Link]", line 99, in run_in_scope
await self.scoped_session.commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/ext/asyncio/[Link]", line 471, in commit
return await self._proxied.commit()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/ext/asyncio/[Link]", line 1014, in commit
await greenlet_spawn(self.sync_session.commit)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/util/_concurrency_py3k.py", line 201, in greenlet_spawn
result = [Link](*sys.exc_info())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/orm/[Link]", line 2032, in commit
[Link](_to_root=True)
File "<string>", line 2, in commit
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/orm/[Link]", line 1320, in commit
[Link]()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 2628, in commit
self._do_commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 2733, in _do_commit
self._connection_commit_impl()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 2704, in _connection_commit_impl
[Link]._commit_impl()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 1143, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 2351, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 1141, in _commit_impl
[Link].do_commit([Link])
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/engine/[Link]", line 706, in do_commit
dbapi_connection.commit()
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 893, in commit
self._handle_exception(error)
File "/Users/neerajkumar/vscode/Alfred/Alfred_backend/.venv/lib/python3.11/site-
packages/sqlalchemy/dialects/postgresql/[Link]", line 792, in _handle_exception
raise translated_error from error
[Link]:
([Link]) <class
'[Link]._base.InterfaceError'>: cannot perform operation: another
operation is in progress
(Background on this error at: [Link]

You might also like