Created
June 2, 2022 09:07
-
-
Save Kigstn/f0732e5303bab43eebec5055f96a0179 to your computer and use it in GitHub Desktop.
Asyncpg traceback
This file contains 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
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 714, in _start_transaction | |
| await self._transaction.start() | |
| File "/usr/local/lib/python3.10/site-packages/asyncpg/transaction.py", line 101, in start | |
| raise apg_errors.InterfaceError( | |
| asyncpg.exceptions._base.InterfaceError: cannot use Connection.transaction() in a manually started transaction | |
| The above exception was the direct cause of the following exception: | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect | |
| return fn() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect | |
| return _ConnectionFairy._checkout(self) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 901, in _checkout | |
| result = pool._dialect.do_ping(fairy.dbapi_connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 699, in do_ping | |
| cursor.execute(self._dialect_specific_select_one) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 479, in execute | |
| self._adapt_connection.await_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only | |
| return current.driver.switch(awaitable) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn | |
| value = await result | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 408, in _prepare_and_execute | |
| await adapt_connection._start_transaction() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 716, in _start_transaction | |
| self._handle_exception(error) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 682, in _handle_exception | |
| raise translated_error from error | |
| sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.InterfaceError: <class 'asyncpg.exceptions._base.InterfaceError'>: cannot use Connection.transaction() in a manually started transaction | |
| The above exception was the direct cause of the following exception: | |
| Traceback (most recent call last): | |
| File "/app/./Backend/main.py", line 91, in log_requests | |
| response = await call_next(request) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/middleware/base.py", line 44, in call_next | |
| raise app_exc | |
| File "/usr/local/lib/python3.10/site-packages/starlette/middleware/base.py", line 34, in coro | |
| await self.app(scope, request.receive, send_stream.send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/exceptions.py", line 82, in __call__ | |
| raise exc | |
| File "/usr/local/lib/python3.10/site-packages/starlette/exceptions.py", line 71, in __call__ | |
| await self.app(scope, receive, sender) | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 21, in __call__ | |
| raise e | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__ | |
| await self.app(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 656, in __call__ | |
| await route.handle(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 259, in handle | |
| await self.app(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 61, in app | |
| response = await func(request) | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/routing.py", line 227, in app | |
| raw_response = await run_endpoint_function( | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/routing.py", line 160, in run_endpoint_function | |
| return await dependant.call(**values) | |
| File "/app/./Backend/endpoints/destiny/profile.py", line 38, in discord_has_token | |
| await auth.get_working_token() | |
| File "/app/./Backend/networking/bungieApi.py", line 203, in get_working_token | |
| token = await self._refresh_token() | |
| File "/app/./Backend/networking/bungieApi.py", line 230, in _refresh_token | |
| self.user = await crud.discord_users.update( | |
| File "/app/./Backend/crud/destiny/discordUsers.py", line 233, in update | |
| updated: DiscordUsers = await self._update(db=db, to_update=to_update, **update_kwargs) | |
| File "/app/./Backend/crud/base.py", line 119, in _update | |
| new_obj = await new_db.merge(to_update) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/session.py", line 391, in merge | |
| return await greenlet_spawn( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 126, in greenlet_spawn | |
| result = context.throw(*sys.exc_info()) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2993, in merge | |
| return self._merge( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3073, in _merge | |
| merged = self.get( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2805, in get | |
| return self._get_impl( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2912, in _get_impl | |
| return db_load_fn( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/loading.py", line 530, in load_on_pk_identity | |
| session.execute( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1711, in execute | |
| conn = self._connection_for_bind(bind) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1552, in _connection_for_bind | |
| return self._transaction._connection_for_bind( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 747, in _connection_for_bind | |
| conn = bind.connect() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line 406, in connect | |
| return super(Engine, self).connect() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3234, in connect | |
| return self._connection_cls(self, close_with_result=close_with_result) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 96, in __init__ | |
| else engine.raw_connection() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3313, in raw_connection | |
| return self._wrap_pool_connect(self.pool.connect, _connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3283, in _wrap_pool_connect | |
| Connection._handle_dbapi_exception_noconnection( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2117, in _handle_dbapi_exception_noconnection | |
| util.raise_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ | |
| raise exception | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect | |
| return fn() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect | |
| return _ConnectionFairy._checkout(self) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 901, in _checkout | |
| result = pool._dialect.do_ping(fairy.dbapi_connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 699, in do_ping | |
| cursor.execute(self._dialect_specific_select_one) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 479, in execute | |
| self._adapt_connection.await_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only | |
| return current.driver.switch(awaitable) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn | |
| value = await result | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 408, in _prepare_and_execute | |
| await adapt_connection._start_transaction() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 716, in _start_transaction | |
| self._handle_exception(error) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 682, in _handle_exception | |
| raise translated_error from error | |
| sqlalchemy.exc.InterfaceError: (sqlalchemy.dialects.postgresql.asyncpg.InterfaceError) <class 'asyncpg.exceptions._base.InterfaceError'>: cannot use Connection.transaction() in a manually started transaction | |
| (Background on this error at: https://sqlalche.me/e/14/rvf5) | |
| 2022-06-02 08:30:05,192 UTC || ERROR || `POST` for `http://backend:8070/persistentMessages/669293365900214293/delete` | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 714, in _start_transaction | |
| await self._transaction.start() | |
| File "/usr/local/lib/python3.10/site-packages/asyncpg/transaction.py", line 101, in start | |
| raise apg_errors.InterfaceError( | |
| asyncpg.exceptions._base.InterfaceError: cannot use Connection.transaction() in a manually started transaction | |
| The above exception was the direct cause of the following exception: | |
| Traceback (most recent call last): | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect | |
| return fn() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect | |
| return _ConnectionFairy._checkout(self) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 901, in _checkout | |
| result = pool._dialect.do_ping(fairy.dbapi_connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 699, in do_ping | |
| cursor.execute(self._dialect_specific_select_one) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 479, in execute | |
| self._adapt_connection.await_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only | |
| return current.driver.switch(awaitable) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn | |
| value = await result | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 408, in _prepare_and_execute | |
| await adapt_connection._start_transaction() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 716, in _start_transaction | |
| self._handle_exception(error) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 682, in _handle_exception | |
| raise translated_error from error | |
| sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.InterfaceError: <class 'asyncpg.exceptions._base.InterfaceError'>: cannot use Connection.transaction() in a manually started transaction | |
| The above exception was the direct cause of the following exception: | |
| Traceback (most recent call last): | |
| File "/app/./Backend/main.py", line 91, in log_requests | |
| response = await call_next(request) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/middleware/base.py", line 44, in call_next | |
| raise app_exc | |
| File "/usr/local/lib/python3.10/site-packages/starlette/middleware/base.py", line 34, in coro | |
| await self.app(scope, request.receive, send_stream.send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/exceptions.py", line 82, in __call__ | |
| raise exc | |
| File "/usr/local/lib/python3.10/site-packages/starlette/exceptions.py", line 71, in __call__ | |
| await self.app(scope, receive, sender) | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 21, in __call__ | |
| raise e | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__ | |
| await self.app(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 656, in __call__ | |
| await route.handle(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 259, in handle | |
| await self.app(scope, receive, send) | |
| File "/usr/local/lib/python3.10/site-packages/starlette/routing.py", line 61, in app | |
| response = await func(request) | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/routing.py", line 227, in app | |
| raw_response = await run_endpoint_function( | |
| File "/usr/local/lib/python3.10/site-packages/fastapi/routing.py", line 160, in run_endpoint_function | |
| return await dependant.call(**values) | |
| File "/app/./Backend/endpoints/misc/persistentMessages.py", line 56, in delete | |
| await persistent_messages.delete(db=db, guild_id=guild_id, to_delete=to_delete) | |
| File "/app/./Backend/crud/misc/persistentMessages.py", line 87, in delete | |
| objs = await self._delete_multi(db=db, guild_id=guild_id, channel_id=to_delete.channel_id) | |
| File "/app/./Backend/crud/base.py", line 151, in _delete_multi | |
| objs = await self._get_multi(db=db, **delete_kwargs) | |
| File "/app/./Backend/crud/base.py", line 49, in _get_multi | |
| result = await self._execute_query(db, query) | |
| File "/app/./Backend/crud/base.py", line 171, in _execute_query | |
| result = await db.execute(query) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/ext/asyncio/session.py", line 212, in execute | |
| result = await greenlet_spawn( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 126, in greenlet_spawn | |
| result = context.throw(*sys.exc_info()) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1711, in execute | |
| conn = self._connection_for_bind(bind) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1552, in _connection_for_bind | |
| return self._transaction._connection_for_bind( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 747, in _connection_for_bind | |
| conn = bind.connect() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/future/engine.py", line 406, in connect | |
| return super(Engine, self).connect() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3234, in connect | |
| return self._connection_cls(self, close_with_result=close_with_result) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 96, in __init__ | |
| else engine.raw_connection() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3313, in raw_connection | |
| return self._wrap_pool_connect(self.pool.connect, _connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3283, in _wrap_pool_connect | |
| Connection._handle_dbapi_exception_noconnection( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2117, in _handle_dbapi_exception_noconnection | |
| util.raise_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ | |
| raise exception | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect | |
| return fn() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 310, in connect | |
| return _ConnectionFairy._checkout(self) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 901, in _checkout | |
| result = pool._dialect.do_ping(fairy.dbapi_connection) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 699, in do_ping | |
| cursor.execute(self._dialect_specific_select_one) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 479, in execute | |
| self._adapt_connection.await_( | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 68, in await_only | |
| return current.driver.switch(awaitable) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 121, in greenlet_spawn | |
| value = await result | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 408, in _prepare_and_execute | |
| await adapt_connection._start_transaction() | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 716, in _start_transaction | |
| self._handle_exception(error) | |
| File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 682, in _handle_exception | |
| raise translated_error from error | |
| sqlalchemy.exc.InterfaceError: (sqlalchemy.dialects.postgresql.asyncpg.InterfaceError) <class 'asyncpg.exceptions._base.InterfaceError'>: cannot use Connection.transaction() in a manually started transaction | |
| (Background on this error at: https://sqlalche.me/e/14/rvf5) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment