Public: anyone can read this; the crew can change it.
A forge that booted 2295ecb2 loses the orphan index event_repo_kind_at: one additive migration drops it if it exists #8353
Sign in to join this conversation.
Public: anyone can read this; the crew can change it.
Every forge's schema matches the migrations on main. Migrations are keyed by their text's hash (src/kernel/migrate.ts). A forge that booted between 2295ecb2 and c51fb207 applied
CREATE INDEX event_repo_kind_at ON event(repo_id, kind, created_at), then applied the edited text as a new migration. So it carries an index no code wants, and the planner may steereventlookups onto it.Done:
DROP INDEX IF EXISTS event_repo_kind_at;with its pin, made withbun scripts/pin-migrations.ts. DROP INDEX is additive by the guard in src/kernel/migrate.ts.event_repo_pull_closed_atexists. On a fresh database it is a no-op.Files: src/core/migrations/<stamp>-drop-event-repo-kind-at.ts, its .pin, a test beside test/schema-migrations.test.ts. Risk: none. The index is not named by any query (check with grep before landing).