Hangfire.PostgreSql

Hangfire.PostgreSql copied to clipboard

Distributed Lock is causing issues

5

The default value of the lock timeout is 10min but if a job takes longer than 10min, it will spawn a new cron job, assuming that the lock timed out....

phillijw

System.InvalidCastException when querying for postgis Point if Hangfire is being setup before the application context

13

Hi! I have a console application "worker" that performs background tasks using Hangfire with postgresql storage. I have postgis extension installed and some of my entities have properties with the...

Cherepoc

Ability to have GUIDs as PK

4

It would be great to have the option to use GUIDs as the Primary Key for jobs. Perhaps the appropriate place for this could be in the "PostgreSqlStorageOptions()" constructor? I'm...

ips-jm

Dashboard not showing history graph

2

The dashboard doesn't show any data in the History Graph section, even though there is plenty of jobs. Its just all squashed up to the right. If i switch the...

zpxp

HomePage raises Npgsql.PostgresException: op ANY/ALL (array) requires array on right side

1

Hello! We use PostgreSQL 12.16 Sometimes Dashboard home page raises Npgsql.PostgresException (0x80004005): `42809: op ANY/ALL (array) requires array on right side` Here is exception stack trace ``` POSITION: 105 at...

r00xus

Performance issues when there is a large number of failed jobs

1

Hello - we encountered an issue recently where we had a Hangfire instance that had collected a large number of failed jobs (over 6,000) due to some issues in our...

mattburton

Single listen thread proof of concept.

11

-- PROOF OF CONCEPT ONLY, NOT PRODUCTION READY -- I was excited to see the new listen / long polling functionality in the latest release as the polling is a...

alyssa-dahlberg

Hey, The current implementation of the `PostgreSqlDistributedLock` throw a custom exception `PostgreSqlDistributedLockException` when the resource can't be locked before the timeout. Short story, we use the public API `AcquireDistributedLock` in...

Luce-Florian

Cache all SQL queries using sliding expiration

4

Closes #278.

azygis

Optimisation of SQL generation logic

12

Whenever some method of `PostgreSqlJobQueue` is executed - a new instance of the String class containing formatted SQL is created. That puts some footprint on the memory: B/c SQL strings...

luber