Hangfire timing out on insert into jobQueue table

question
1

We are using Hangfire 1.7.11 with SQL Server.
Getting timeout errors on the following:
insert into [HangFire].JobQueue (JobId, Queue) values (@jobId, @queue)

Job Queue table is tiny, at any time less than ten records, but it is being constantly inserted and deleted from.

Any clues will be helpful. Timeout on such a tiny table is strange.

Thanks,
Tauqir

2

What happens if you run the insert 100 times without hangfire- do you have the same problem then? it sounds like a deal-lock or issue in the database rather than hangfire …