I noticed that the SQL column Id in the table hangfire.job is an int. I need to keep the job for a lot longer and am worried that I’ll go pass the ~2million mark. Can we change this to BigInt or can I change it in SQL for my instance of hangfire?
But will you exceed the 2 billion mark? (that’s the 32-bit integer max value)
yes in several years.
We exceeded recently in 16 months. And we alter table
ALTER TABLE [HangFire].[State] DROP CONSTRAINT [PK_HangFire_State]
ALTER TABLE HangFire.State ALTER COLUMN Id BIGINT
ALTER TABLE HangFire.Job ALTER COLUMN StateId BIGINT
ALTER TABLE [HangFire].[State] ADD CONSTRAINT [PK_HangFire_State] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]