HangFire.SqlServer 1.6.21

SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).

There is a newer version of this package available.
See the version list below for details.
Install-Package HangFire.SqlServer -Version 1.6.21
dotnet add package HangFire.SqlServer --version 1.6.21
<PackageReference Include="HangFire.SqlServer" Version="1.6.21" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add HangFire.SqlServer --version 1.6.21
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

https://www.hangfire.io/blog/
   
1.6.21
• Fixed – Change locking scheme in the `Connection.SetRangeInHash` method to avoid deadlocks.
     
1.6.20
• Fixed – Remove the synthetic limitation to support Azure SQL Management instance (by @TimSQL).
     
1.6.19
• Fixed – "String or binary data would be truncated" exception when state reason is too long.
• Fixed – Command handling in batch mode now stops after the first error due to "XACT_ABORT ON".
• Fixed – Make SqlCommandBatch disposable to dispose all the commands.
     
1.6.18
• Fixed – Rare deadlocks in SQL Server caused by the SetRangeInHash command.
   
1.6.17
• Added – `SqlServerStorageOptions.CommandBatchMaxTimeout` parameter to enable batching in transactions.
• Fixed – Timeout exceptions when there are a lot of large concurrent transactions by using the new batching method.
• Fixed – Distributed locks are safe now even in very unreliable networks and after network blips.
• Performance – Greatly decreased the number of connections required to process background jobs.
• Performance – Significantly decrease the number of roundtrips required to commit a transaction.
   
1.6.16
• Fixed – Lower the number of requests, when trying to acquire a distributed lock.
• Fixed – Problems with continuations and batch continuations, when using existing `SqlConnection` instance.
• Fixed – Distributed locks were silently released, when passing explicit closed connection to a storage.
• Fixed – `KeyNotFoundException` errors on various dashboard pages don't appear anymore (by @benjymous).
• Fixed – "Cannot release the application lock because it is not currently held" exceptions, when connection was closed.
• Fixed – Allow to use zero timeout for SQL Server-based distributed locks.
   
1.6.15
• Fixed – Timeout exceptions that's caused by SQL Server's thread pool starvation, caused by sp_getapplock.
• Fixed – Antecedent background job is constantly failing, when its continuation hasn't been fully created.
   
1.6.14
• Added – `SqlServerStorageOptions.SlidingInvisibilityTimeout` to fetch jobs without using transaction.
• Fixed – Transaction log is full due to 'ACTIVE_TRANSACTION' by enabling to use new non-transactional fetch.
• Fixed – `SqlServerJobQueueMonitoringApi` can't cause READ UNCOMMITTED isolation level to leak on SQL Server 2012 or earlier.
• Fixed – Add missing `SqlServerStorage(DbConnection, SqlServerStorageOptions)` constructor.
   
1.6.13
• Fixed – Don't hide errors occurred while running SQL migrations.
• Fixed – `KeyNotFoundException` when accessing Deleted Jobs page in Dashboard.
• Fixed – `SqlServerDistributedLock` leaks connections, when lock acquisition is failed.
   
1.6.9
• Fixed – `TimeoutException` on large arguments or large batches via `SqlServerOptions.CommandTimeout`.

1.6.8
• Fixed – Use `long` where possible instead of `int` for background job identifiers, full support will be in 1.7.0.
   
1.6.7
• Fixed – Validation added to avoid "An invalid application lock time-out" exceptions (by t0mburton).
   
1.6.6
• Fixed – SqlServerJobQueue class doesn't use obsolete InvisibilityTimeout parameter anymore.
   
1.6.5
• Fixed – Different timeout issues after making performance optimizations.
• Fixed – SQL timeouts while getting a connection, when using default settings and >= 8 CPU cores.
• Fixed – ExpirationManager is bloated by SqlError instances, when there are a lot of messages from server.
• Fixed – Counters query returned inconsistent results during CountersAggregator executions.
• Performance – Added missing NOLOCK hint for monitoring queries when using SqlServer-based queues.
• Performance – ExpirationManager is forced to use index seek operations for cascade deletions.
• Performance – CountersAggregator now uses clustered index scan to issue less logical reads.
• Performance – Paging queries in dashboard now use CTEs to utilize less logical reads.
   
1.6.4
• Fixed – `SqlConnection` object leaks when using nested distributed locks (in batches and continuations).

1.6.3
• Fixed – Prevent `ExpirationManager`'s command from timing out, when there are a lot of records.
• Fixed – `CountersAggregator` issue introduced in 1.6.2, that causes slow record aggregation.
• Fixed – Add `XLOCK` hint for `CountersAggregator` query to prevent deadlocks on lock escalation.
   
1.6.2
• Changed – `JobExpirationCheckInterval` property value now defaults to 30 minutes.
• Fixed – Excessive blocking when expiring records in `State` and `JobParameters` tables.
• Fixed – Migration script `Install.sql` was deadlocked by itself, leading to errors on startup.

1.6.0
• Added – .NET Core support for Hangfire.Core and Hangfire.SqlServer packages (`netstandard1.3` target).
• Added – Zero latency processing when client and server reside in the same process (by @bgurmendi).
• Changed – `SqlServerStorage` class constructor now takes `DbConnection` instances (by @tystol).
• Changed – `SqlServerObjectsInstaller` class is public now (by @vbfox).
• Changed – Update Dapper to 1.50.1 version.
• Fixed – Drop constraints on Server.Id prior to altering it to avoid conflicts.

Showing the top 8 GitHub repositories that depend on HangFire.SqlServer:

Repository Stars
simplcommerce/SimplCommerce
A simple, cross platform, modularized ecommerce system built on .NET Core
abpframework/abp
Open Source Web Application Framework for ASP.NET Core
eventflow/EventFlow
Async/await first CQRS+ES and DDD framework for .NET
HTBox/allReady
This repo contains the code for allReady, an open-source solution focused on increasing awareness, efficiency and impact of preparedness campaigns as they are delivered by humanitarian and disaster response organizations in local communities.
Jimmey-Jiang/ABP-ASP.NET-Boilerplate-Project-CMS
ABP module-zero +AdminLTE+Bootstrap Table+jQuery+Redis + sql server+quartz+hangfire权限管理系统
trueai-org/module-shop
一个基于 .NET Core构建的简单、跨平台、模块化的商城系统
stoveproject/Stove
Domain Driven Design oriented application framework, meets CRUD needs
bit-foundation/bit-framework
Full stack dev framework for C# / TypeScript / JavaScript developers

Version History

Version Downloads Last updated
1.7.6 193,948 8/5/2019
1.7.5 60,267 7/18/2019
1.7.4 104,203 6/28/2019
1.7.3 191,825 5/23/2019
1.7.2 154,493 4/29/2019
1.7.1 87,245 4/16/2019
1.7.0 138,221 3/29/2019
1.6.27 4,110 6/27/2019
1.6.26 9,456 5/23/2019
1.6.25 5,181 4/9/2019
1.6.24 15,892 3/27/2019
1.6.23 120,962 3/13/2019
1.6.22 384,292 1/25/2019
1.6.21 475,283 11/1/2018
1.6.20 571,741 7/31/2018
1.6.19 718,113 4/6/2018
1.6.18 8,716 4/5/2018
1.6.17 1,083,368 9/19/2017
1.6.16 83,897 9/2/2017
1.6.15 153,315 8/8/2017
1.6.14 216,680 6/16/2017
1.6.13 44,841 6/7/2017
1.6.12 390,163 3/22/2017
1.6.11 23,927 3/14/2017
1.6.10 11,507 3/13/2017
1.6.9 32,238 3/2/2017
1.6.8 227,741 12/21/2016
1.6.7 87,822 11/25/2016
1.6.6 126,309 10/13/2016
1.6.5 92,816 9/24/2016
1.6.4 76,972 8/30/2016
1.6.3 27,391 8/19/2016
1.6.2 45,028 8/5/2016
1.6.1 29,710 7/27/2016
1.6.0 18,746 7/15/2016
1.5.9 29,989 7/11/2016
1.5.8 29,942 6/17/2016
1.5.7 21,228 5/30/2016
1.5.6 56,461 4/22/2016
1.5.5 14,674 4/14/2016
1.5.4 34,320 3/22/2016
1.5.3 215,203 11/6/2015
1.5.2 22,111 10/15/2015
1.5.1 1,972 10/14/2015
1.5.0 25,721 10/1/2015
1.4.7 1,611 10/1/2015
1.4.6 21,042 8/29/2015
1.4.5 26,063 7/24/2015
1.4.4 889 7/23/2015
1.4.3 29,607 5/27/2015
1.4.2 9,287 5/6/2015
1.4.1 15,436 4/14/2015
1.3.4 45,589 2/4/2015
1.3.3 2,404 1/28/2015
1.3.2 969 1/27/2015
1.3.1 6,151 1/13/2015
1.3.0 4,665 12/10/2014
1.2.2 6,619 11/24/2014
1.2.1 654 11/22/2014
1.2.0 3,638 11/17/2014
1.1.1 13,959 9/5/2014
1.1.0 1,612 9/3/2014
1.0.2 4,451 7/1/2014
1.0.1 561 6/30/2014
1.0.0 631 6/30/2014
0.9.1 1,625 6/12/2014
0.9.0 569 6/7/2014
0.8.3 593 5/23/2014
0.8.2 525 5/21/2014
0.8.1 999 5/17/2014
0.8.0 1,460 5/2/2014
0.7.5 514 4/10/2014
0.7.4 452 4/7/2014
0.7.3 454 4/4/2014
0.7.1 448 4/1/2014
0.7.0 1,399 3/22/2014
Show less