Lots of jobs "scheduled" for past?

sql-server
Tags: #<Tag:0x00007f8ba6558c58>

#1

I have tons of jobs that seem to be stuck in my server not processing.
I’m using HF 1.7.11.0 with SQL Server storage on AWS/RDS, and just today it seems like I have thousands of “scheduled” jobs that should have triggered, but haven’t.

When I look at a given job, it shows something like “Created 5 hours ago”, and “Enqueue at: 7 hours ago”… AKA this job should have fired off 7 hours ago. Yet there are no additional statuses.

I have tried:

  • Deleting and re-creating this job, same problem
  • Rebooting MSSQL server, does nothing
  • Rebooting IIS/app, does nothing
  • Rebooting whole Windows server, does nothing
  • Re-publishing my app, does nothing

This is what my Startup.vb looks like:

Public Sub Configuration(app As IAppBuilder)
	app.UseHangfireAspNet(AddressOf GetHangfireServers)
	app.UseHangfireDashboard()
End Sub

Private Iterator Function GetHangfireServers() As IEnumerable(Of IDisposable)
	GlobalConfiguration.Configuration.SetDataCompatibilityLevel(CompatibilityLevel.Version_170).
		UseSimpleAssemblyNameTypeSerializer().
		UseRecommendedSerializerSettings().
		UseSqlServerStorage("server=db.myserver.com;UID=admin;PWD=1234;database=hangFireDB",
			New SqlServerStorageOptions With {
				.PrepareSchemaIfNecessary = True,
				.CommandBatchMaxTimeout = TimeSpan.FromMinutes(5),
				.SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5),
				.QueuePollInterval = TimeSpan.Zero,
				.UseRecommendedIsolationLevel = True,
				.UsePageLocksOnDequeue = True,
				.DisableGlobalLocks = True
			}
		)

	Dim options = New BackgroundJobServerOptions() With {
		.ServerName = dbName,
		.WorkerCount = 20,
		.Queues = {"myQueue1", "myQueue2", "myQueue3"}
	}

	Yield New BackgroundJobServer(options)
End Function

#3

Actually scratch that last message, I don’t have recurring jobs, these are just one-off scheduled jobs.

I noticed in the “Set” table, all of the “Score” values are negative. If I set some to 0, the job fires. Some keep ending back up at negative though.