Ghost operatives appear on the ranked leaderboards (all-time, windowed, streak) with a stable, swamp-flavored alias like 👻 murk-wisp-9dc54f2a and each has a clickable /ghost/<slug> profile. But the leaderboard search box deliberately excludes ghosts, so a ghost you can plainly see on the board returns zero results when you type its alias into search. The rankings and search disagree about who exists on the board.

Root cause

ClickHouseLeaderboardQuery.board() in lib/infrastructure/clickhouse/clickhouse-score-reads.ts:913-921 appends AND is_ghost = 0 to the search filter, and matches owner ILIKE {q} against the raw owner column (the distinct_id), never against the rendered alias:

// Ghosts are excluded from SEARCH (not from ranked boards): the match
// would run against the raw distinct_id — which never renders — so a
// hit both confuses (alias doesn't contain the query) and lets a
// caller probe raw distinct_id contents by substring enumeration.
ownerFilter = `AND owner ILIKE {q:String} AND is_ghost = 0`;

The exclusion is intentional and the reasoning is sound as written: matching the query against the raw distinct_id would (a) never match the visible alias and (b) let a caller enumerate raw distinct_id substrings. But the conclusion — drop ghosts from search entirely — leaves them unsearchable rather than searchable by their alias.

findScoreTarget() (the /locate jump-to-me path, clickhouse-score-reads.ts:693-740) carries the same exclusion, so locate can't jump to a ghost either.

The alias is ghostSlug(distinctId) (lib/ghost-name.ts) — a deterministic FNV-1a hash, one-way by design, so a query fragment can't be reversed to a distinct_id in SQL. That's why the naive "just match owner" approach was rejected. A real fix has to match against the slug, not the distinct_id.

Steps to reproduce

Open /leaderboard on prod (SCORE_READS=clickhouse, serving from the ClickHouse ledger).
Note a ghost row, e.g. 👻 murk-wisp-9dc54f2a (visible with a /ghost/... link).
Type its alias fragment (murk-wisp) into the leaderboard search box.
Expected: the ghost row appears, matching what's on the board.
Actual: no results — search silently drops all ghosts.

Environment

Path: ClickHouse read flip (SCORE_READS=clickhouse), prod. The Mongo path (mongo-leaderboard-query.ts) has no ghost concept (username: {$exists: true} filter), so this is CH-specific.
Files: lib/infrastructure/clickhouse/clickhouse-score-reads.ts (board() ~L913-921, findScoreTarget() ~L693-740); alias grammar in lib/ghost-name.ts.

Fix direction (not prescriptive)

Match search against the ghost slug rather than excluding ghosts: e.g. resolve the candidate ghost owner set app-side, compute ghostSlug() for each, and match the query against the slug — never exposing or probing the raw distinct_id. This keeps the anti-enumeration property (query never touches distinct_id contents) while making a visible ghost findable by the exact text shown on its row.

02Bog Flow

Closed

7/10/2026, 4:41:03 AM

No activity in this phase yet.

03Sludge Pulse

keeb assigned keeb7/10/2026, 4:12:14 AM

keeb linked related to #10587/10/2026, 4:41:03 AM

keeb commented 7/10/2026, 4:40:51 AM

Folding into #1058 and closing as resolved-under-#1058.

Both fixes rewrite the same code — findScoreTarget() and the board() SEARCH filter in lib/infrastructure/clickhouse/clickhouse-score-reads.ts — so they ship as one change rather than two conflicting rewrites of findScoreTarget.

#1058 (serve leaderboard locate live + asOf, retiring the per-replica standings cache) will replace the ghost exclusion here with slug matching: resolve the candidate ghost owners app-side, compute ghostSlug() for each (the buildAliasIndex()/resolveGhostAlias machinery already exists in the same file), and match the query against the slug — never against the raw distinct_id, so the anti-enumeration property this issue calls out is preserved. The fix and its verification land in the #1058 PR.

Improve multi-word search query handling and guidance

swamp command doesn't check cwd

swamp auth login process fails when run remotely

serve boot OOM: findAllGlobalSince loads all workflow runs as full aggregates during reconciliation

extension search: channel-filtered results carry null version fields, and multiple --channel values collapse instead of unioning

s3-datastore: localHasAllRemoteEntries uses bare rel instead of localRelPath, always returns false in namespaced mode

datastoreSetupExtension migrates .swamp/ to cache root instead of namespace directory

swamp serve writes outputs/ outside the bound namespace — silently never persisted to the remote datastore

s3-datastore: bulk pull writes to cache root instead of the namespace, wedging push and arming a full-datastore delete

git: add pull, fetch --tags, and cherry-pick methods

Workflow runs with wide dataArtifact fan-out (~400/run) OOM both workflow history get and swamp serve boot, crash-looping the scheduler; rollback doesn't help (state-triggered, not release-triggered)

Show user:<name> instead of user:<id> in grant list output

Reusable long-lived invite link: one URL to bring people into the swamp

Exclude swamp internal model types from model list output

Skill docs use invalid two-argument 'vault get' form

access token mint prints an invalid retrieval command (vault get, not vault read-secret)

serve reload and model edit timeout over --server in Kubernetes

swamp auth whoami should report paid tier and trial status

Use whoami entitlement to explain private-extension push refusals

Document --restricted-commands flag for swamp serve

vault put: pass tags through to extension provider CreateSecret/setSecret calls

Docs: update manual for 23 new --server commands

Update VaultProvider interface in @systeminit/swamp-testing to support optional tags in put()

Docs: document --grants-file flag for swamp serve

Docs: document --server support for serve reload

Docs: add --tag flag to vault put reference

Docs: update manual for --detach-runs deprecation and HA auto-detection

Document the Codex plugin in swamp docs

Add --server support to CLI commands missing it

Document the swamp Claude Code plugin in the swamp documentation

Make --server a global CLI option

Add --server support to model cancel (server-side run cancellation)

Load grants from external source on swamp serve startup

swamp vault put should support tags for secret governance

Improve hot reload of the deamon, include extension source/bundle changes

Authenticated users must re-login after swamp serve restart

Add --server support to serve reload

Harden queue claim semantics: atomic claims + status-guarded markDelivered/markFailed across app queues

Auto-detect HA mode and deprecate --detach-runs flag

version-drift check (from #236) is a raw string-inequality, false-positives on multi-model manifests and metadata-only bumps

Resend newsletter audience sync: contacts, segments, backfill, unsubscribe sync-back

Move per-login token secrets from vault to encrypted control-plane store

Docs: document macOS TLS trust limitation and SSL_CERT_FILE workaround

Validate swamp serve deployment stack on startup

Docs: serve config file (.swamp/serve.yaml) and --config flag

Serve config file — read swamp serve configuration from YAML

Deno runtime does not trust ISRG Root YR — extensions fail with valid Let's Encrypt certs

Docs: update hot-reload reference to include trust list refresh

Cross-instance client re-attach for multi-instance swamp serve

vercel codegen: inline rawSyncResult in non-unwrap sync path

vercel codegen: unused listAll import blocks extension publish for 4 models

vercel codegen: add round-trip idempotency test for the pipeline

Operatives button on Collectives page does nothing

Track active runs in the control-plane store for cross-instance visibility

validateGlobalArgInputRefs checks step-level inputs but step schema rejects 'inputs' key

Docs: document continuous reconciliation and multi-instance serve flags

Docs: update workflow guard skip output to include guardExpression and guardResult

Make it aware hot reload on the deamon does not take into account trust list changes, or do take into account the trust list for the hot reload.

workflow validate: new 'GlobalArgument input references' check resolves model-definition ${{ inputs.* }} against workflow inputs, false-failing steps that supply the input

Continuous reconciliation for multi-instance swamp serve

Split the score-read circuit breaker so leaderboard pressure can't blank profile scores

oauth_sign_in telemetry records provider as the literal ":id" for every event

Ghost profile bypasses the score-read seam and 500s on a slow ledger

Profile score section blocks the render on a ClickHouse read

Council: set the scoring balance — command tiers, farm-decay parameters, cross-category ratio

Scoring coverage gaps: instrument drop-off, score ripples/mentions, reward invite-converts

Push down the two cheap leaderboard scans: ghost-gate dictionary and eventCounts owner filter

Materialize an active-days-by-id table for the streak board

score-rollup-projector: O(all-time ledger) closure + per-pod fan-out saturates prod ClickHouse CPU

Startup cache hydration for swamp serve instance replacement

Output a log line for steps skipped due to guards

extension quality scorer misreads a template-literal import specifier in generated code as an unresolvable bare import, hard-erroring the whole extension as UNSCORABLE

Add @swamp/kubernetes/statefulset model type

Docs: access token commands reference says plaintext is 'shown once'

Document --restricted-model-types flag for swamp serve

swamp auth server-login ignores SWAMP_SERVE_URL

s3-datastore extension: pullChanged writes namespace-stripped paths to local cache

serve oauth: an unrecognized device-token error kills the whole serve process instead of the bootstrap

s3-datastore: bidirectional sync pull writes namespace-stripped copies to cache root, wedging push with no supported recovery

CLI reports 'HTTP/2 not supported by this client' when the server actually returned 401 — masks auth failures as a transport error