Hangfire 1.8.16 + SQL Server is not processing jobs, downgrading to 1.8.15 fixes issue

We use renovate to automatically update minor/patch library versions across our microservices. We have noticed since renovate has upgraded hangfire and the sql server package from 1.8.15 to 1.8.16, jobs sit in the enqueued state and are never processed.

Reverting back to 1.8.15 immediately fixes the issue and jobs are processed again.

This may be due to us using an older schema version? We cannot enable heavy migrations, some of our production tables would require hours of downtime to do this.

We’ve noticed this in 2 microservices so far, both using schema version 5.

Dashboard on 1.8.16:


And downgrading back to 1.8.15 immediatey fixes the issue:

Nevermind I just checked the github page and think this is fixed in 1.8.17.

Yes, there are issues with Hangfire.SqlServer 1.8.16 and older database schemas. I have just added a warning for this package version on NuGet so this problem will more likely be detected by the tooling.