Dead-lettered jobs and failed outbox rows are kept forever without indexes

Open
#3,285 0 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 1 day

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
48/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Active
Tech stack
csharp
Domain
backend, databases

Research direction

Start with JobRunnerOptions.cs:46 and OutboxOptions.FailedRetention, then trace the admin list queries and existing database index definitions for jobs and failed outbox rows. Check how retention and filtered indexes are configured in the project. Done means both row types are pruned by default and both admin lists can use the requested indexes.

Written by the indexing model from the issue text.

Description

area:events area:jobs performance type:bug

Problem

Dead-lettered jobs are never removed (JobRunnerOptions.cs:46) and failed outbox rows have no retention by default (OutboxOptions.FailedRetention), with full payloads. Their admin lists sort and page over every such row: jobs by completed_at with only a (status, lease_until) index, failed outbox rows with no index.

Proposal

Opt-out retention defaults (for example 30 to 90 days) for both; an index on jobs (status, completed_at) and a filtered index on failed outbox rows.

Acceptance

  • Both are pruned by default and their lists use an index

Found in the code review of 17 Nov 2026 (P6).

Dominant language
C#
Stars
569
Forks
107
Avg merge
2h 49m
Merged PRs (30d)
397

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fluentcms/FluentCMS

All issues in fluentcms/FluentCMS

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.