Malavika S Menon
09/30/2022, 10:06 AMTraceback (most recent call last):
File "/root/.Envs/healthgraph/lib/python3.8/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 442, in _prepare_and_execute
self._rows = await prepared_stmt.fetch(*parameters)
File "/root/.Envs/healthgraph/lib/python3.8/site-packages/asyncpg/prepared_stmt.py", line 176, in fetch
data = await self.__bind_execute(args, 0, timeout)
File "/root/.Envs/healthgraph/lib/python3.8/site-packages/asyncpg/prepared_stmt.py", line 241, in __bind_execute
data, status, _ = await self.__do_execute(
File "/root/.Envs/healthgraph/lib/python3.8/site-packages/asyncpg/prepared_stmt.py", line 230, in __do_execute
return await executor(protocol)
File "asyncpg/protocol/protocol.pyx", line 201, in bind_execute
asyncpg.exceptions.ActiveSQLTransactionError: ALTER TYPE ... ADD cannot run inside a transaction block
Coming across this error while trying to run a prefect agent and orion. Has anyone come across this before?Bianca Hoch
09/30/2022, 3:14 PMMalavika S Menon
09/30/2022, 6:21 PMprefect orion start
through the command line. Was running in a virtualenv with SQLAlchemy==1.4.40, asyncpg=0.26.0, postgres server = 9.5