Hangfire tables created without identity

recurring
Tags: #<Tag:0x00007f499a5e4c10>

#1

Using Net Core 2.2 or 3.0 doesnt matter

when running application hangfire creates all of its tables

but Job, JobQueue, List, and State Tables have their Id PK with Identity Specification Off

so not autoincrement

this causes the recurring job to fail with error

cannot insert null into column Id of Table Job. whenever it tries to enqueue


#2
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'Id', table 'MyDatabase.HangFire.Job'; column does not allow nulls. INSERT fails.

#3

Hi Trevor. Don’t understand how this could happen – identity specification is set in the migration/initialization script, and I have never seen errors like this before. Did you modify or copy table structure manually?