Hangfire icon indicating copy to clipboard operation
Hangfire copied to clipboard

Published 20 hours ago • verified publisher icon HangfireIO

Sql DeadLocks

Open McSaverInvestments opened this issue 1 year ago • 2 comments

Im currently running scheme 9, I'm seeing a lot of xp_userlock and (@id bigint)select InvocationData, StateName, Arguments, CreatedAt from [HangFire].Job with (readcommittedlock, forceseek) where Id = @id select Name, Value from [HangFire].JobParameter with (forceseek) where JobId = @id

that are taking a long time to complete and creating deadlock. I'm only try to process about 300 jobs at the moment.

This is my current setup.

image

image

image

McSaverInvestments avatar May 18 '24 08:05 McSaverInvestments

Hm, do you have any deadlock graphs or at least resource names for these locks available? Also, what version of Hangfire.Core and Hangfire.SqlServer you are using? I haven't seen deadlocks in Hangfire for a long time already.

odinserj avatar May 31 '24 08:05 odinserj

@odinserj Hello, I'm current using version 1.8.12. The only was I was able to get around this issue was reduce my work counts by a factor of 10. Any other idea or suggestions, thanks?

McSaverInvestments avatar Jun 16 '24 02:06 McSaverInvestments