PgLockRegistry exhausts connection pool — one connection per lock #171

New issue

Closed

opened 2026-03-02 22:56:52 +00:00 by ash · 0 comments

ash commented

2026-03-02 22:56:52 +00:00

Owner

Problem

Each Acquire() grabs a dedicated connection from the pool and holds it for the lock lifetime. With many subscriptions/automations, this exhausts the pool.

Real-world: YoYoPass server stuck on startup — 38 subscriptions each holding a connection.

Fix

Single shared connection holds all locks (advisory locks are session-scoped). Refcount tracks held locks. Connection released when last lock released. Close() for clean shutdown.

## Problem Each Acquire() grabs a dedicated connection from the pool and holds it for the lock lifetime. With many subscriptions/automations, this exhausts the pool. Real-world: YoYoPass server stuck on startup — 38 subscriptions each holding a connection. ## Fix Single shared connection holds all locks (advisory locks are session-scoped). Refcount tracks held locks. Connection released when last lock released. Close() for clean shutdown.