Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
the issue with a local PostgreSQL install?: Yes, works locally.
Python version:3.10
Platform:Windows
Do you use pgbouncer?:No
Did you install asyncpg with pip?:yes
If you built asyncpg locally, which version of Cython did you use?:N/A
Can the issue be reproduced under both asyncio and
uvloop?:Don't know
A few days ago Microsoft has bumped up a minor version of a "Azure Database for PostgreSQL flexible server" to version 13.12 from 13.11
After that - all PGstac methods using that are utilized by Stac-Fast-Api stopped working !
resulting in a "segmentation fault" and not returning any data back.
Executing the same queries or stored procedures using a PGAdmin works fine, indicating a problem with pgstab library
We are in the middle of production outage right now due to this, and will add more details as they become available.
After deeper investigation we see that the issue is coming from asyncpg library
packages/asyncpg/connection.py", line 1366, in reset
await self.execute(reset_query, timeout=timeout)
File "/home/mantasmantas/projects/Atlas-Platform/app/atlas_ui/stac_fastapi/venv/lib/python3.10/site-packages/asyncpg/connection.py", line 317, in execute
return await self._protocol.query(query, timeout)
File "asyncpg/protocol/protocol.pyx", line 338, in query
asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
A few days ago Microsoft has bumped up a minor version of a "Azure Database for PostgreSQL flexible server" to version 13.12 from 13.11
After that - all PGstac methods using that are utilized by Stac-Fast-Api stopped working ! resulting in a "segmentation fault" and not returning any data back.
Executing the same queries or stored procedures using a PGAdmin works fine, indicating a problem with pgstab library
We are in the middle of production outage right now due to this, and will add more details as they become available.
After deeper investigation we see that the issue is coming from asyncpg library