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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock
Дата
Msg-id 18332-68ca0b212eba488b@postgresql.org
обсуждение исходный текст
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18331: Why is the session lock (DEFAULT_LOCKMETHOD) not automatically released during process exit?
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18333: Postgres is crashing if we have special character in the query