HangfireIO / HangfireIO/Hangfire

Error during Hangfire schema creation

Open
#1,676 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
10.1k
Forks
1.8k
Avg merge
1h 19m
Merged PRs (30d)
1

Description

The hangfire script has the following issue...

Re-created constraint [PK_HangFire_List]
Re-created constraint [PK_HangFire_Set]
Re-created constraint [PK_HangFire_State]
Msg 1934, Level 16, State 1, Line 596
CREATE INDEX failed because the following SET options have incorrect settings: 'NUMERIC_ROUNDABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Contributor guide

Open the contributing guide

Research direction

Locate the Hangfire schema creation script and inspect the statement around line 596, where the reported CREATE INDEX fails. Reproduce the script against SQL Server with the indicated SET option state; done when schema creation completes without the NUMERIC_ROUNDABORT error.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.