Postgres Pro
Downloads
Home   >   mailing lists

BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock
Date
Msg-id 18332-68ca0b212eba488b@postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      18332
Logged by:          Winter Surname
Email address:      wangghge@gmail.com
PostgreSQL version: 15.0
Operating system:   Centos
Description:

Even if the process holds a stronger lock, the conditional lock request will
still return false if another process is waiting 
for the same lock.

See  the scenario：

process A
process B

hold AccessExclusiveLock   of  lock1;


  request ShareLock of lock1;

ConditionalLockXXX ShareLock of lock1          <--- this returns false

But actually, process A is able to get the the ShareLock of lock1, is this a
FEATURE or BUG?

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18331: Why is the session lock (DEFAULT_LOCKMETHOD) not automatically released during process exit?
Next
From: PG Bug reporting form
Date:
Subject: BUG #18333: Postgres is crashing if we have special character in the query