Collected from the PG bugs email list.
|Reported by||andy ye|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16194 Logged by: andy ye Email address: (redacted) 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.
|2020-01-07 09:33:26+00||PG Bug reporting form||BUG #16194: use postgresql's pg_advisory_xact_lock error|
|2020-01-07 09:49:37+00||Tomas Vondra||Re: BUG #16194: use postgresql's pg_advisory_xact_lock error|