asyncpg acquire timeout
Hi! i was migrating db from mongodb to postgres using asyncpg and created pool and did pool.acquire to get connection and passed to functions
One of the functions had to call discord api to check some stuff which took quite some time and when it completed, i got connection has been back to pool
So is there any time limit after which the connection is released back to pool ?
4 Replies
fair-rose•11mo ago
Hey, Is this asyncpg the python library?
Could you share the exact error message you get back? I'm not finding anything in my searching
fascinating-indigo•11mo ago
Yes
I will try to find again in a bit
fascinating-indigo•11mo ago
Found similar GitHub issue
https://github.com/MagicStack/asyncpg/issues/988
GitHub
asyncpg.exceptions._base.InterfaceError: cannot call Connection.fet...
asyncpg version: 0.26.0 PostgreSQL version: 12.0 Do you use a PostgreSQL SaaS? If so, which? Can you reproduce : NO, from pg docker the issue with a local PostgreSQL install?: YES, Python version: ...
fascinating-indigo•11mo ago
Except i had issue with Conn.transaction()
I was making connection pool to Postgres and then acquiring the connection, passing it to other functions for use
Think it's bug or Postgres released connection after certain time (or inactivity) 🤔