connection was closed in the middle of operation

• asyncpg version: 0.15.0
• PostgreSQL version: 10.3
• local PostgreSQL:
• Python version: 3.6.5
• Platform: Ubuntu 14.04.5
• Do you use pgbouncer?: no
• Did you install asyncpg with pip?: yes

I use asyncpg with sanic. Before server start, a connection pool is made and attached to the app. In every route, the handler acquire a connection if pg access is needed. The problem is, if the pool is silent for too long, new acquired connection is not usable.

asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation

After one-time exception. The next acquisition is normal again. No exception with queries. Which is really weird for me.

I've tried to twist max_inactive_connection_lifetime parameter, got no luck. Actually I don't quite understand this parameter. Why would I need this parameter?

Any help is welcomed.

Non è indicato alcun file sorgente né alcun test. Inizia riproducendo lo scenario del pool inattivo con asyncpg 0.15.0, PostgreSQL 10.3, Python 3.6.5 e Sanic, quindi esamina l’acquisizione dal pool e il comportamento di max_inactive_connection_lifetime. Il lavoro è completato quando è stata identificata la causa della prima acquisizione fallita e il comportamento è stato verificato dopo la modifica pertinente.