One outbox event costs seven to nine write transactions on SQLite
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 54/100
Research direction
Start with OutboxDrainer.cs at the cited lines and OutboxKick.cs:24, then trace how delivery claims, leases, and settlement work with SQLite. The proposal identifies four changes, but does not name tests or explain how maintenance scheduling is structured. Done means the acceptance criterion holds: delivering N events uses O(1) write transactions, excluding handlers' own transactions.
Written by the indexing model from the issue text.
Description
Problem
On SQLite every ExecuteUpdate/ExecuteDelete takes BEGIN IMMEDIATE. OutboxDrainer (OutboxDrainer.cs:87,115,248,258) runs the exhausted sweep on every loop, renews each row on start, and settles each row on its own, on top of the kick insert and the job claim and settle (OutboxKick.cs:24). Under editing load this multiplies writer-lock waits and the risk of database is locked.
Proposal
Move the exhausted sweep to maintenance, skip the start renewal while the claim lease covers the delivery timeout, settle a batch in one update, and filter the kick query by queue and due time.
Acceptance
- Delivering a batch of N events takes O(1) write transactions plus the handlers' own
Found in the code review of 17 Nov 2026 (P3).
- Dominant language
- C#
- Stars
- 569
- Forks
- 107
- Avg merge
- 2h 49m
- Merged PRs (30d)
- 397
Getting set up
- Ships a Dockerfile or Docker Compose file
- Has a pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from fluentcms/FluentCMS
-
area:host area:operations type:bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 1 day
-
area:build security type:chore
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 1 day
-
area:sdk security type:bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 1 day
-
area:content security type:bug
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
Maintainers usually reply within 1 day
-
area:build type:bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 1 day
All issues in fluentcms/FluentCMS
Similar issues
-
bug needs-triage
Difficulty 2/5 1-3 hours Newbie friendliness 67/100
microsoft/microsoft-ui-reactor#1567 ·
Maintainers usually reply within 1 day
-
clawsweeper:fix-shape-clear clawsweeper:queueable-fix clawsweeper:source-repro impact:ux-friction issue-rating: 🦞 diamond lobster no-stale P2
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
openclaw/openclaw-windows-node#2287 · 2 comments · 1 reaction ·
Maintainers usually reply within 1 day
-
kind:ux needs-triage
Difficulty 2/5 1-3 hours Newbie friendliness 66/100
elsa-workflows/elsa-foundation#4742 ·
Maintainers usually reply within 1 day
-
priority:P2
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
enhancement good first issue help wanted new-language
Difficulty 2/5 1-3 hours Newbie friendliness 82/100