Hangfire.SqlServer 1.8.22

Release notes are available in our blog https://www.hangfire.io/blog/ Please see https://docs.hangfire.io/en/latest/upgrade-guides/upgrading-to-hangfire-1.8.html to learn how to upgrade.

1.8.22 • Fixed – InvalidCastException when creating a background job with Schema 5 (regression from 1.8.15). • Project – Replace the netcoreapp3.1 target with the net8.0 one in tests.

1.8.21 • Added – SqlServerStorageOptions.DisableTransactionScope option for .NET Framework targets. • Project – Port Monitoring API tests from the Hangfire.InMemory storage for better coverage. • Project – Run tests for different targets in parallel with different databases.

1.8.19 • Fixed – Sliding invisibility timeout isn't prolonged in lightweight servers, causing jobs to be restarted.

1.8.17 • Fixed – InvalidCastException while fetching a job with older schemas regression from 1.8.16.

1.8.16 • Changed – Use vanilla ADO.NET when fetching a job in the SqlServerJobQueue implementation. • Fixed – SqlException: Must declare the scalar variable "@key" in delayed and recurring job schedulers. • Fixed – Decrease the LockTimeout time when calling the sp_getapplock procedure to 1 second for less blocking. • Project – Disable parallel tests execution when building under .NET 9.0. • Project – Run tests over the latest Microsoft.Data.SqlClient package and the net6.0 platform. • Project – Reduce execution time of integration tests. • Project – Disable PoolBlockingPeriod setting on AppVeyor to handle transient test failures.

1.8.15 • Changed – Use query template caching based on schema name to avoid excessive string allocations. • Changed – Use static callbacks almost anywhere to avoid unnecessary delegate allocations. • Changed – Use QuerySingle* or ReadSingle* where possible to avoid allocating lists. • Changed – Unify DbCommand and DbParameter creation logic to improve code consistency.

1.8.13 and 1.8.14 • Changed – Limit polling queries when queues are empty with a semaphore for all configurations. • Changed – Use per-queue signaling for same-process workers, instead of having a global signal. • Fixed – Don't silently truncate queue names, throw an exception instead. • Project – Decrease delays in SQL Server-related tests to complete them faster.

1.8.12 • Fixed – Populate InvocationData and LoadException properties in JobDetails method results.

1.8.10 • Changed – Bump Dapper for the netstandard2.0 platform to version 2.1.28. • Changed – Bump Dapper for net451 and netstandard1.3 platforms to version 1.60.6. • Project – Enable NuGet package and DLL signing with a company certificate. • Project – Require NuGet package signature validation on restore for dependencies. • Project – Add HangfireIO as a package owner.

1.8.9 • Project – Enable full source link support with embedded symbols and repository-based sources. • Project – Enable repeatable package restore using a lock file. • Project – Run unit tests against the net6.0 platform.

1.8.7 • Changed – Avoid throwing an exception when a connection string has duplicate property names. • Project – Disable tests for netcoreapp1.0 and netcoreapp2.1 targets since they aren't supported in AppVeyor. • Project – Add a net6.0 target for unit tests instead of the removed ones. • Project – Modernise projects and build environments to use the newest features.

1.8.6 • Fixed – Exception in Dashboard UI when schema version is not present in a database. • Fixed – DbCommand resource leak when releasing a lock detected by static analysis. • Fixed – Don't add SQL Server-related metrics multiple times in Dashboard UI.

1.8.5 • Fixed – "Query processor could not produce a query plan" when removing expired counters in Schema 5.

1.8.2 • Fixed – InvalidOperationException with new dashboard metrics when a database has multiple data/log files.

1.8.1 • Fixed – Blocked workers regression since 1.7.33 when using multiple servers inside a process. • Fixed – Target schema version is less than the current schema version error. • Fixed – Implement database metrics without the need for additional permissions. • Fixed – Use the forceseek table hint whenever possible to avoid performance drops.

1.8.0 • Breaking – Prioritise Microsoft.Data.SqlClient package over System.Data.SqlClient one. • Breaking – Dropped the NET45 platform target in favor of the NET451 target to support Visual Studio 2022. • Added – Schema 8 migration with fixed JobQueue.Id column to use the bigint type. • Added – Schema 9 migration that creates an index for the State.CreatedAt column. • Added – Automatic client package detection based on available types, preferring System.Data.SqlClient (by @0xced). • Added – SqlServerStorageOptions.DbProviderFactory option to use a custom provider factory. • Added – Clean up of old state entries of a non-finished job when InactiveStateExpirationTimeout is set. • Added – TryAutoDetectSchemaDependentOptions option to automatically enable options based on the schema. • Added – Optional experimental transactional acknowledge for SQL Server (UseTransactionalAcknowledge option). • Added – Implement the Connection.GetUtcDateTime feature to make work the new changes in schedulers. • Added – SqlServerStorage.SchemaVersion metric for Dashboard UI. • Added – DefaultQueueProvider option to specify a custom default queue provider. • Changed – Remove dependency on System.Data.SqlClient for Hangfire.SqlServer (by @0xced). • Changed – Set default value for the QueuePollInterval option to TimeSpan.Zero. • Changed – Polling delay when QueuePollInterval is set to zero now defaults to 200 ms. • Changed – Sliding invisibility timeout-based fetching method is now used by default with a 5-minute timeout. • Changed – Use command batching by default with a 5-minute maximum timeout. • Changed – Enable the UseRecommendedIsolationLevel option by default. • Changed – GetJobData now populates the JobData.ParametersSnapshot property to avoid additional roundtrips. • Changed – Display scheduled and processing jobs in ascending order in Dashboard UI. • Changed – Implement the Transaction.AcquireDistributedLock feature. • Changed – Implement the GetSetCount.Limited feature. • Changed – Implement the GetSetContains feature. • Changed – Bump the internal version of Dapper to 2.0.123. • Changed – Enable common metrics for SQL Server storage to be shown by default. • Changed – Enable the Monitoring.AwaitingJobs feature for SQL storage. • Deprecated – UsePageLocksOnDequeue option is now obsolete and doesn't affect anything.