Postgres Pro
Downloads
Home   >   mailing lists

BUG #16194: use postgresql's pg_advisory_xact_lock error - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16194: use postgresql's pg_advisory_xact_lock error
Date
Msg-id 16194-8f7bff6e93dbe84c@postgresql.org
Whole thread Raw
Responses Re: BUG #16194: use postgresql's pg_advisory_xact_lock error  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      16194
Logged by:          andy ye
Email address:      andy.ye@gtssz.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.

pgsql-bugs by date:

Previous
From: andy ye
Date:
Subject: About postgresql pg_advisory_xact_lock use!!!!
Next
From: Tomas Vondra
Date:
Subject: Re: Unable to fork: Resource Unavailable