Postgres - Multiple threads successfully acquire the same lock

[Tom4Real]

Postgres - Multiple threads successfully acquire the same lock

[madelson]

Thanks for reporting @Tom4Real . Do you have a repro? Any theories as to what is happening? Anything non-default about your Postgres setup (eg pgbouncer)?

Can you show a snippet of your code?

[madelson]

@Tom4Real any update here?

[madelson]

    [Test]
    public async Task Repro()
    {
        var key = new PostgresAdvisoryLockKey("MyLockName", allowHashing: true);
        var conn = TestingPostgresDb.DefaultConnectionString;
        var lock1 = new PostgresDistributedLock(key, conn);
        var lock2 = new PostgresDistributedLock(key, conn);
        var lock3 = new PostgresDistributedLock(key, conn);
        var counter = 0;
        await Task.WhenAll(new[] { lock1, lock2, lock3 }.Select(l => Task.Run(async () =>
        {
            await using (await l.AcquireAsync())
            {
                var c = Interlocked.Increment(ref counter);
                if (c != 1) { throw new Exception("concurrent acquisition!"); }
                await Task.Delay(1000);
                Interlocked.Decrement(ref counter);
            }
        })));
    }

Attempted to reproduce with the above code. It does not repro for me. @Tom4Real please let me know if you're still observing this and can share additional detail. For now I'm closing this as not reproducible.