electric-sql / electric-sql/pglite

pg_advisory_lock is not waiting for unlock

Open
#704 1 comment 0 reactions 0 assignees View on GitHub
documentation
Dominant language
TypeScript
Stars
16k
Forks
442
Avg merge
20h 19m
Merged PRs (30d)
7

Description

To reproduce:

SELECT pg_advisory_lock(123);

-- Now a new lock appear in pg_locks
SELECT * FROM pg_locks WHERE locktype = 'advisory' AND objid = 123;

SELECT pg_advisory_lock(123); -- IS NOT WAITING, just a new lock in the pg_locks appear

-- to clear, pg_locks, pg_advisory_unlock must be called twice (it's not the right behavior...)
SELECT pg_advisory_unlock(123);

SELECT * FROM pg_locks WHERE locktype = 'advisory' AND objid = 123; -- still presente

SELECT pg_advisory_unlock(123);

SELECT * FROM pg_locks WHERE locktype = 'advisory' AND objid = 123; -- now empty

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.