The following bug has been logged on the website:
Bug reference: 16194
Logged by: andy ye
Email address: andy(dot)ye(at)gtssz(dot)net
PostgreSQL version: 9.5.11
Operating system: ubuntu 16.04
Description:
When I use postgresql's pg_advisory_xact_lock for transaction security,
especially RPC services, I often see that the lock is not released, causing
the service to block for a long time. The blocking time is about 15 minutes.