electric-sql / electric-sql/pglite
pg_advisory_lock is not waiting for unlock
Open
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.