How to increase hangfire job timeout

Question

I have a .net core application which has hangfire 1.7.2 running.

So I have this job, which executes SQL stored procedure and its a long running task, can be of 30 minutes.

This gives me following error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

services.AddHangfire(configuration => 

configuration.UseSqlServerStorage(Configuration.GetConnectionString("HangfireConnection"), 
new SqlServerStorageOptions
    {
        SlidingInvisibilityTimeout = TimeSpan.FromMinutes(30),
        QueuePollInterval = TimeSpan.Zero,
        UsePageLocksOnDequeue = false,
        DisableGlobalLocks = false
    }));

Please help me out.

score 4 · Answer 1 · answered Nov 12 '19 at 22:01

4

The CommandTimeout property on SqlServerStorageOptions should be what you are looking for.

Increase this to be more than 30 minutes and your jobs will stop timing out.

(See source https://github.com/HangfireIO/Hangfire/blob/cf7bb08d24ee4953926b7717461bf8a23d895eb4/src/Hangfire.SqlServer/SqlServerConnection.cs)

answered Nov 12 '19 at 22:01

Mattkwish

753
7
16

2

I tried this answer but it was still the giving me same error, then I debugged it more and got to know that my SqlCommand was failing. It has its own CommandTimeout which is by default 30 secs. Your answer helped me debug more, thank you. – Gaurav Nov 15 '19 at 07:58
Glad i could be of some help! – Mattkwish Nov 15 '19 at 16:03

score 2 · Accepted Answer · answered Nov 15 '19 at 08:00

I managed to fix this by increasing SQLCommand timeout which is by default 30 seconds.

 using (SqlCommand cmd = new SqlCommand(query, con))
 {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandTimeout = 3600; // 1 hour
        await cmd.ExecuteNonQueryAsync();
 }

How to increase hangfire job timeout

2 Answers2