Jobs being created in database, stuck as Enqueued

bug?
,
21

Thanks for the quick fix!

22

:tada: :fireworks: ā€“ http://hangfire.io/2015/01/29/hangfire-1.3.3-released.html

24

@ssewell, I donā€™t like the fix introduced in Hangfire 1.3.3 that solves a problem with stucked enqueued jobs when using MSMQ. I even couldnā€™t imagine why this problem occurs at all, but was able to reproduce this problem recently by enabling snapshot isolation.

Does your database use the READ_COMMITTED_SNAPSHOT or ALLOW_SNAPSHOT_ISOLATION option?

Iā€™ve already added a note to the documentation that snapshot isolation isnā€™t supported by Hangfire, and want to rollback the fix. The problem is that we canā€™t efficiently handle non-existing background jobs with the fix, and a number of wrong identifiers in a queue may cause background job processing to stuck.

26

My database has (and always has) both READ_COMMITTED_SNAPSHOT and AlLOW_SNAPSHOT_ISOLATION set to false.

27

What SQL Server version are you using?