[AW Top 10] 08 Fix ledger projection and work queue smoke failures #65773

Priority 8/10 | 7 source issues | Impact 3/5 | Confidence 3/5 | Effort 3/5

One assignment, one coherent fix

The built-in ledger, repo-memory ledger and work queue smoke tests fail on missing projection tables, failed ledger push jobs and unavailable work queue tools. These all exercise the same ledger projection and coordinator tooling.

Implementation scope

Reproduce the smoke runs, ensure the notes projection schema such as note_state is created before read-only validation, and make the work queue and dispatch coordinator tools available to the smoke agents.

Done when

• The built-in ledgers smoke test finds the note_state table during read-only validation.
• The work queue and dispatch coordinator smoke tests pass with the required tools available.
• The push_ledger_changes job succeeds for the ledger smoke workflows.

Why now

Seven issues from recent smoke and daily runs point to the ledger and work queue feature set. Corroboration is moderate because some failures may stem from separate causes, so the first step is reproduction.

Unchanged AW sources close only after this summary is completed. Newer source activity and not-planned retirement do not trigger source closure. Assigned summaries are frozen; unassign to allow reclustering.

Generated by AW Essential Issue Clustering · copilot · auto · 35.6 AIC · ⌖ 12.1 AIC · ⊞ 8.6K · ◷