HangFire.SqlServer 1.7.3

Hangfire SQL Server Storage

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

Install-Package HangFire.SqlServer -Version 1.7.3
dotnet add package HangFire.SqlServer --version 1.7.3
<PackageReference Include="HangFire.SqlServer" Version="1.7.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add HangFire.SqlServer --version 1.7.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

https://www.hangfire.io/blog/

Please see https://docs.hangfire.io/en/latest/upgrade-guides/upgrading-to-hangfire-1.7.html to learn how to upgrade from 1.6.X.

1.7.3
• Fixed – Wrong error message in migration script, when @CurrentSchemaVersion has a NULL value (by @penenkel).

1.7.2
• Fixed – Occasional "DataException: Error parsing column" error when using blocking fetch.

1.7.1
• Changed – Use blocking fetch implementation only for sub-second polling intervals.
• Fixed – Don't fail with an exception when can't connect to MSSQL instance during start-up.
• Fixed – Don't access the `JobQueue` table when using blocking query and don't have results.

1.7.0
• Added – Full .NET Core 2.0 support by explicitly targeting .NET Standard 2.0.
• Added – `Schema 7` migration to fix the `IX_HangFire_Set_Score` index to include the `Key` column.
• Added – `Schema 6` migration with less indexes, better physical layout and `bigint` support (disabled by default).
• Added – Blocking fetch support for sliding expiration-based fetch to avoid excessive polling.
• Added – `SqlServerStorageOptions.EnableHeavyMigrations` switch to automatically install even heavy migrations.
• Added – `SqlServerStorageOptions.DisableGlobalLocks` property to avoid custom locking scheme.
• Added – `SqlServerStorageOptions.UsePageLocksOnDequeue` property to use less CPU consuming fetch.
• Added – Callback method to allow to open the database with impersonation (by @BjoernHund).
• Added – `SqlServerStorageOptions.UseRecommendedIsolationLevel` option to set the minimum possible level.
• Changed – Identity columns either converted to the `bigint` type, or entirely removed.
• Changed – Clustered indexes were organized according to the access patterns of their tables.
• Changed – Most of secondary indexes were either removed or made filtered.
• Changed – Optimize sliding-expiration-based fetching to use even less CPU time.
• Changed – Use write reordering and fine-grained locking scheme to improve parallelism.
• Changed – Monitoring API doesn't check state data to see state transition time.
• Changed – Allow to use zero-based poll interval when sliding invisibility timeout.
• Changed – Short paths for the `CreateExpiredJob` method to avoid some round-trips.
• Changed – Set `SqlParameter` types explicitly to not to duplicate query plans.
• Changed – Batch support for `AddToQueue` method when default provider is used.
• Changed – Check `FetchedAt` has expected value to prevent prolonging others' work.
• Changed – Use more recent Dapper 1.50.7 on all platforms except .NET Framework 4.5.
• Changed – Dapper package is internalized now even on .NET Core to avoid possible conflicts.
• Fixed – Avoid unnecessary waits in state changer when job was already expired.
• Fixed – Cannot resolve the collation conflict in `CountersAggregator`.
• Fixed – Background processing stops when identity columns exceed the `Int32.MaxValue`.
• Fixed – Slowdown of scheduled jobs due to the missing index on the `[Set]` table.

Version History

Version Downloads Last updated
1.7.3 43,928 5/23/2019
1.7.2 73,483 4/29/2019
1.7.1 49,354 4/16/2019
1.7.0 76,532 3/29/2019
1.7.0-rc2 1,868 3/22/2019
1.7.0-rc1 1,881 3/15/2019
1.7.0-beta4 6,941 2/18/2019
1.7.0-beta3 167 2/15/2019
1.7.0-beta2 30,732 9/1/2018
1.7.0-beta1 49,059 3/2/2018
1.6.26 1,127 5/23/2019
1.6.25 3,403 4/9/2019
1.6.24 10,663 3/27/2019
1.6.23 76,423 3/13/2019
1.6.22 256,302 1/25/2019
1.6.21 374,161 11/1/2018
1.6.20 476,301 7/31/2018
1.6.19 594,222 4/6/2018
1.6.18 7,042 4/5/2018
1.6.17 987,745 9/19/2017
1.6.16 75,021 9/2/2017
1.6.15 143,147 8/8/2017
1.6.14 204,870 6/16/2017
1.6.13 42,433 6/7/2017
1.6.12 364,684 3/22/2017
1.6.11 23,174 3/14/2017
1.6.10 11,309 3/13/2017
1.6.9 30,347 3/2/2017
1.6.8 214,135 12/21/2016
1.6.7 81,351 11/25/2016
1.6.6 117,006 10/13/2016
1.6.5 88,046 9/24/2016
1.6.4 72,584 8/30/2016
1.6.3 24,848 8/19/2016
1.6.2 38,970 8/5/2016
1.6.1 28,894 7/27/2016
1.6.0 17,876 7/15/2016
1.5.9 25,364 7/11/2016
1.5.8 28,698 6/17/2016
1.5.7 20,596 5/30/2016
1.5.6 55,218 4/22/2016
1.5.5 14,482 4/14/2016
1.5.4 30,754 3/22/2016
1.5.3 205,734 11/6/2015
1.5.2 20,358 10/15/2015
1.5.1 1,856 10/14/2015
1.5.0 22,714 10/1/2015
1.4.7 1,560 10/1/2015
1.4.6 20,707 8/29/2015
1.4.5 23,028 7/24/2015
1.4.4 797 7/23/2015
1.4.3 28,209 5/27/2015
1.4.2 9,159 5/6/2015
1.4.1 14,628 4/14/2015
1.3.4 44,086 2/4/2015
1.3.3 2,331 1/28/2015
1.3.2 931 1/27/2015
1.3.1 6,069 1/13/2015
1.3.0 4,507 12/10/2014
1.2.2 5,391 11/24/2014
1.2.1 607 11/22/2014
1.2.0 3,551 11/17/2014
1.1.1 13,277 9/5/2014
1.1.0 1,563 9/3/2014
1.0.2 4,397 7/1/2014
1.0.1 517 6/30/2014
1.0.0 576 6/30/2014
0.9.1 1,554 6/12/2014
0.9.0 520 6/7/2014
0.8.3 544 5/23/2014
0.8.2 477 5/21/2014
0.8.1 789 5/17/2014
0.8.0 1,401 5/2/2014
0.7.5 462 4/10/2014
0.7.4 399 4/7/2014
0.7.3 407 4/4/2014
0.7.1 394 4/1/2014
0.7.0 1,313 3/22/2014