Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Invalidate connection <sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_connection object at 0x000001FE9C0E8C40> (reason: Error:<class 'asyncpg.exceptions.ConnectionDoesNotExistError'>: connection was closed in the middle of operation)
- Task exception was never retrieved
- future: <Task finished name='Task-4' coro=<calculate_score() done, defined at C:\Users\moowi\Documents\GitHub\bpl-backend\app\poe\calculate_score.py:866> exception=DBAPIError("(sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.ConnectionDoesNotExistError'>: connection was closed in the middle of operation")>
- Traceback (most recent call last):
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 388, in _prepare_and_execute
- prepared_stmt, attributes = await adapt_connection._prepare(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 630, in _prepare
- prepared_stmt = await self._connection.prepare(operation)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 548, in prepare
- return await self._prepare(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 564, in _prepare
- stmt = await self._get_statement(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 408, in _get_statement
- types, intro_stmt = await self._introspect_types(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 454, in _introspect_types
- return await self.__execute(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 1664, in __execute
- return await self._do_execute(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\asyncpg\connection.py", line 1711, in _do_execute
- result = await executor(stmt, None)
- File "asyncpg\protocol\protocol.pyx", line 201, in bind_execute
- asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in _execute_context
- self.dialect.do_execute(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\default.py", line 717, in do_execute
- cursor.execute(statement, parameters)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 449, in execute
- self._adapt_connection.await_(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 69, in await_only
- return current.driver.switch(awaitable)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 122, in greenlet_spawn
- value = await result
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 424, in _prepare_and_execute
- self._handle_exception(error)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 358, in _handle_exception
- self._adapt_connection._handle_exception(error)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 652, in _handle_exception
- raise translated_error from error
- sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.Error: <class 'asyncpg.exceptions.ConnectionDoesNotExistError'>: connection was closed in the middle of operation
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\app\poe\calculate_score.py", line 871, in calculate_score
- lead_info = await fetch_lead_info(conn)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\app\poe\calculate_score.py", line 215, in fetch_lead_info
- event_id = (await get_current_event(db)).id
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\app\crud\event.py", line 43, in get_current_event
- event = (await db.execute(event_query)).scalar()
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\ext\asyncio\session.py", line 143, in execute
- return await greenlet_spawn(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 129, in greenlet_spawn
- result = context.switch(value)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 1692, in execute
- result = compile_state_cls.orm_setup_cursor_result(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\context.py", line 327, in orm_setup_cursor_result
- return loading.instances(result, querycontext)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\loading.py", line 169, in instances
- _prebuffered = list(chunks(None))
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\loading.py", line 158, in chunks
- post_load.invoke(context, path)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\loading.py", line 1329, in invoke
- loader(context, path, states, self.load_keys, *arg, **kw)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\strategies.py", line 2997, in _load_for_path
- self._load_via_parent(our_states, query_info, q, context)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\strategies.py", line 3060, in _load_via_parent
- context.session.execute(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\orm\session.py", line 1689, in execute
- result = conn._execute_20(statement, params or {}, execution_options)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1583, in _execute_20
- return meth(self, args_10style, kwargs_10style, execution_options)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\sql\elements.py", line 323, in _execute_on_connection
- return connection._execute_clauseelement(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1452, in _execute_clauseelement
- ret = self._execute_context(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1814, in _execute_context
- self._handle_dbapi_exception(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1995, in _handle_dbapi_exception
- util.raise_(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
- raise exception
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in _execute_context
- self.dialect.do_execute(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\engine\default.py", line 717, in do_execute
- cursor.execute(statement, parameters)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 449, in execute
- self._adapt_connection.await_(
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 69, in await_only
- return current.driver.switch(awaitable)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 122, in greenlet_spawn
- value = await result
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 424, in _prepare_and_execute
- self._handle_exception(error)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 358, in _handle_exception
- self._adapt_connection._handle_exception(error)
- File "C:\Users\moowi\Documents\GitHub\bpl-backend\.venv\lib\site-packages\sqlalchemy\dialects\postgresql\asyncpg.py", line 652, in _handle_exception
- raise translated_error from error
- sqlalchemy.exc.DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.ConnectionDoesNotExistError'>: connection was closed in the middle of operation
Add Comment
Please, Sign In to add comment