Multiple workers execute same job

[marius-stanescu-archive360]

There is a bug. All the server workers execute the same job. I described the problem in more detail here.

Is this project still maintained?

[pauldotknopf]

Is this issue specific to the Sqlite provider?

[pauldotknopf]

Maybe the issue is here:

Hangfire.Sqlite/Hangfire.SQLite/SQLiteConnection.cs

Line 81 in 70e6162

return new SQLiteDistributedLock();

It looks like a fresh lock is being created for every request for a distributed lock.

Considering there should only be one process using a single database, maybe we can just use an in-memory lock? Maybe we can borrow this class? https://github.com/perrich/Hangfire.MemoryStorage/blob/661839c2e83c0e8cd349cd4310fda7ac6b685335/src/Hangfire.MemoryStorage/MemoryStorageConnection.cs#L28