From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: wangghge@gmail.com
Subject: BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock
Date: Mon, 05 Feb 2024 09:54:01 +0000
Message-ID: <18332-68ca0b212eba488b@postgresql.org> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, wangghge@gmail.com
Subject: Re: BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock
In-Reply-To: <18332-68ca0b212eba488b@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox