Jobs being created in database, stuck as Enqueued

ssewell · January 28, 2015, 9:24pm

Thanks for the quick fix!

odinserj · January 28, 2015, 10:19pm

– http://hangfire.io/2015/01/29/hangfire-1.3.3-released.html

odinserj · July 24, 2015, 3:27pm

odinserj · June 28, 2016, 2:43pm

@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.

odinserj · June 28, 2016, 2:46pm

ssewell · June 28, 2016, 4:31pm

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

odinserj · July 8, 2016, 2:11pm

What SQL Server version are you using?