Issuing Advisory Lock

• asyncpg version: 0.25.0
• PostgreSQL version: 12.11
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?:
• Python version: 3.9
• Platform: Linux
• Do you use pgbouncer?: No
• Did you install asyncpg with pip?: yes
• If you built asyncpg locally, which version of Cython did you use?: No
• Can the issue be reproduced under both asyncio and
  uvloop?: NA

Receiving this error

asyncio.exceptions.TimeoutError
[View similar errors](https://link.datadoghq.com/apm/error-tracking?issueId=...471-da7ad0900002)

Traceback (most recent call last):
  File /usr/local/lib/python3.9/site-packages/ddtrace/contrib/asyncpg/patch.py, line 89, in _traced_query
    return await method(*args, **kwargs)
File asyncpg/protocol/protocol.pyx, line 338, in query
asyncio.exceptions.TimeoutError

Due to internal query call:
SELECT pg_advisory_unlock_all ( ) CLOSE ALL UNLISTEN * RESET ALL

Happening quite frequently

asyncpg/protocol/protocol.pyx の traceback のエントリポイントと、SELECT pg_advisory_unlock_all()、CLOSE ALL、UNLISTEN *、RESET ALL を含む内部クエリシーケンスから始めます。asyncpg 0.25.0 と PostgreSQL 12.11 で報告されたタイムアウトを再現し、その後、期待される動作を特定して、advisory lock のクリーンアップでタイムアウトが発生しなくなったことを確認します。