HangfireIO / HangfireIO/Hangfire
Error during Hangfire schema creation
- 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
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