Skip to content

fix(id/worker-poc): post-update-failure smoke fails on clean main — MemoryJournal stub misses worker.ts SELECT step query #6373

Open

Description

@dezren39

Bug: worker-poc smoke/post-update-failure.mjs fails on clean main — MemoryJournal stub doesn't handle worker.ts's SELECT step FROM journal query

Reproduced on clean origin/main @ 03d1a21eae (no local changes), laptop Node v24.21.0:

cd pkgs/id/worker-poc
node smoke/post-update-failure.mjs
# Error: unexpected SQL: SELECT step FROM journal ORDER BY step DESC LIMIT 1
#     at MemoryJournal.exec (smoke/post-update-failure.mjs:37)
#     at WorldObject.handle (src/worker.ts:128)

Cause

pkgs/id/worker-poc/src/worker.ts:128 issues SELECT step FROM journal ORDER BY step DESC LIMIT 1 (added by 999414c "fix(worker-poc): report journal step on cold start"). The smoke's MemoryJournal.exec stub handles the SELECT step, snapshot FROM journal ... shape (worker.ts:98) and the journal INSERT, but not the SELECT step FROM journal ... shape, so it throws unexpected SQL.

Verified pre-existing: the failure reproduces identically with all local changes stashed (found during task 10764 / issue #6372, which only wires participant-validation into the smoke chain — no source or smoke-file changes). counter-smoke and participant-validation are green on the same tree.

Acceptance

  • MemoryJournal in smoke/post-update-failure.mjs handles the SELECT step FROM journal ORDER BY step DESC LIMIT 1 query (returns the latest step), or worker.ts's query is aligned with the shapes the stub supports.
  • node smoke/post-update-failure.mjs passes on clean main.
  • npm run smoke in pkgs/id/worker-poc runs the full chain green.

Acceptance criteria

  • node smoke/post-update-failure.mjs in pkgs/id/worker-poc passes on clean main.
  • The smoke's MemoryJournal stub handles the SELECT step FROM journal ORDER BY step DESC LIMIT 1 query shape that src/worker.ts issues on cold start, returning the latest journaled step.
  • The neighbouring smokes (counter-smoke, participant-validation) still pass, and no production behaviour in src/worker.ts changes.

Activity

  1. added
    kind/bugSomething isn't working (prefixed form of the classic bug label)
    task/triageQueue packet kind: verify, reproduce, and route this item
    priority/normalOrdinary priority (the default)
    on Nov 5, 2026
  2. developing-today commented on Nov 5, 2026

    @developing-today
    Contributor
  3. added
    app/idPackage/app: id (pkgs/ or apps/ in this repo)
    on Nov 5, 2026
  4. developing-today commented on Nov 6, 2026

    @developing-today
    Contributor

    Intake review

    Fleet monitor intake (§5 pass), 2026-11-05 run.

  5. added
    effort/sSmall: expected under 2 hours of work
    source/queue-workerFiled or worked by the queue/worker pilot
    meta/enrichedIntake review done: acceptance criteria, links, and normalized labels added
    on Nov 6, 2026
  6. added
    queue/queuedHas a queued task in the Supabase agent queue
    work/assignedQueue worker lifecycle state
    queue/claimedQueue worker lifecycle state
    and removed on Nov 6, 2026
  7. 20 remaining items

  8. added
    status/parkedDeliberately paused with a recorded resume condition
    on Nov 6, 2026
  9. dezren39 commented on Nov 6, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · handed off

  10. dezren39 commented on Nov 6, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · handed off

  11. dezren39 commented on Nov 6, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · handed off

  12. added
    queue/claimedQueue worker lifecycle state
    and removed
    status/parkedDeliberately paused with a recorded resume condition
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    on Nov 6, 2026
  13. dezren39 commented on Nov 6, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · handed off

  14. added
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    status/parkedDeliberately paused with a recorded resume condition
    queue/queuedHas a queued task in the Supabase agent queue
    and removed
    queue/claimedQueue worker lifecycle state
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    on Nov 6, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    app/idPackage/app: id (pkgs/ or apps/ in this repo)effort/sSmall: expected under 2 hours of workkind/bugSomething isn't working (prefixed form of the classic bug label)meta/enrichedIntake review done: acceptance criteria, links, and normalized labels addedpriority/normalOrdinary priority (the default)queue/queuedHas a queued task in the Supabase agent queuesource/queue-workerFiled or worked by the queue/worker pilotstatus/parkedDeliberately paused with a recorded resume conditiontask/triageQueue packet kind: verify, reproduce, and route this itemwork/assignedQueue worker lifecycle state

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions