PR 24665 runtime verification
main: 5732bbee39
PR head: ba8a69509e8a785a3323cf8463a2e3e9e48d4ab4

Source: real project and Codex gpt-6.1-sol conversation created via web UI, copied after server shutdown. Only migration 51's name changed to SiteLocalMigration in the disposable copy. No mock provider or demo data.

MAIN
$ node apps/server/scripts/migrate-dev-db.ts --base-dir /home/user/main/.t3-seed-main-repro --source /home/user/seed-evidence/source.sqlite ⊘ cache disabled
Copying visible threads from /home/user/seed-evidence/source.sqlite (read-only)...
Running migrations on the snapshot...
[03:38:06.192] WARN (#1): Database migration history diverges from this build; recorded migration ids are skipped, not reconciled by name. {
  divergent: [
    '51:SiteLocalMigration (this build: ProjectionThreadMessageContext)'
  ]
}
[03:38:06.200] ERROR (#1): MigrateDevDbSlotCollisionError: Migration slot collision at 51: this checkout registers 'ProjectionThreadMessageContext' but the database already applied 'SiteLocalMigration' in that slot. Renumber the new migration to a free slot.
    at file:///home/user/main/apps/server/scripts/migrate-dev-db.ts:427:21
    at verifyMigrationSlots (file:///home/user/main/apps/server/scripts/migrate-dev-db.ts:514:12)
    at verifyMigrationSlots (definition) (file:///home/user/main/apps/server/scripts/migrate-dev-db.ts:419:37)
    at runMigrateDevDb (file:///home/user/main/apps/server/scripts/migrate-dev-db.ts:599:29)
    at runMigrateDevDb (definition) (file:///home/user/main/apps/server/scripts/migrate-dev-db.ts:432:39)


PR HEAD, IDENTICAL SOURCE
$ node apps/server/scripts/migrate-dev-db.ts --base-dir /home/user/t3code/.t3 --source /home/user/seed-evidence/source.sqlite ⊘ cache disabled
Copying visible threads from /home/user/seed-evidence/source.sqlite (read-only)...
Running migrations on the snapshot...
[03:37:58.696] WARN (#1): Database migration history diverges from this build; recorded migration ids are skipped, not reconciled by name. {
  divergent: [
    '51:SiteLocalMigration (this build: ProjectionThreadMessageContext)',
    '76:ProjectionProjectsPinArchive (unknown to this build)'
  ]
}
Pruning to 5 projects, 10 stopped threads each...
Compacting into /home/user/t3code/.t3/userdata/statev2.sqlite...

Dev database ready: /home/user/t3code/.t3/userdata/statev2.sqlite (952 KB)
  seed-verification-repo: 1 threads
  server: 1 threads
  48 orchestration events kept
  Migrations: already current (no new migrations in this checkout)


REAL WEB CLIENT / PROVIDER PATH
- Retained message SEED_HISTORY_BEFORE_OK displayed.
- Continued seeded thread: Codex gpt-6.1-sol completed with SEED_HISTORY_AFTER_OK.
- New thread: Codex gpt-6.1-sol completed with SEED_NEW_THREAD_OK.

V2 CONFLICT (60 renamed OtherBuildMigration in another disposable source copy)
$ node apps/server/scripts/migrate-dev-db.ts --base-dir /home/user/t3code/.t3 --source /home/user/seed-evidence/conflict.sqlite ⊘ cache disabled
Copying visible threads from /home/user/seed-evidence/conflict.sqlite (read-only)...
Running migrations on the snapshot...
[03:41:45.422] ERROR (#1): MigrateDevDbPhaseError: migrate-dev-db failed during migrate on '/home/user/t3code/.t3/userdata/statev2.sqlite.migrate-dev-db-tmp'.
    at file:///home/user/t3code/apps/server/scripts/migrate-dev-db.ts:464:22
    at file:///home/user/t3code/node_modules/.pnpm/effect@4.0.5/node_modules/effect/dist/internal/effect.js:1483:96
    at runMigrateDevDb (file:///home/user/t3code/apps/server/scripts/migrate-dev-db.ts:562:29)
    at runMigrateDevDb (definition) (file:///home/user/t3code/apps/server/scripts/migrate-dev-db.ts:406:39) {
  [cause]: MigrationError: This database's migration history would skip required schema migrations: 60_ThreadSnapshotWindowIndexes (recorded: OtherBuildMigration). The migrator skips every id up to the highest recorded id (76), regardless of name. It was probably written by a different build. Start the build that wrote it, or report this migration history so an upgrade path can be added.
      at file:///home/user/t3code/apps/server/src/persistence/Migrations.ts:201:17
}


Source SHA-256 unchanged: a14c8144346277885dba9532d58113d9ff8edb8d020eb32340a54e3a808caf07
Destination conversations preserved. Initial refusal checkpoints the destination WAL as existing ensureNotInUse behavior. Repeated refusal after checkpoint leaves destination bytes unchanged.

BLACKSMITH
9 migrate-dev-db tests passed.
check:changed against PR merge base 80a2351fcb90 passed format, lint, both knip checks, graphql, typecheck (3 packages), and tests (2 files).