BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock

Started by PG Bug reporting formabout 2 years ago1 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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?