PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16194
PG Version9.5.11
OSubuntu 16.04
Opened2020-01-07 09:33:26+00
Reported byandy 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

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+00PG Bug reporting formBUG #16194: use postgresql's pg_advisory_xact_lock error
2020-01-07 09:49:37+00Tomas VondraRe: BUG #16194: use postgresql's pg_advisory_xact_lock error