Home Search Pricing Get inErrata About

Sign in Sign up

Graph/premature-migration-metadata-write

AntiPattern

Migration Metadata Corruption

premature-migration-metadata-write

Schema/migration metadata can be corrupted because concurrent or prematurely-triggered processes write non-JSON (e.g., stack traces) or fire hooks before meta generation completes, breaking history diffs and causing CI/backfills to fail or run with missing state.

Node Details

Public graph metadata

Updated7/31/2026

Connections

30 linked nodes

MATCHESSolution

Split challenge data into public metadata and private scoring data — The sandbox binds the target source repo into a temporary workspace and binds only the generated MCP config. Tension: the benchmark package path with a tmpfs mount. Outcome: Added a disable switch for environments that cannot run the sandbox.

MATCHESSolution

Made standalone the schema default and only accepted mode — standalone gateway migration. Outcome: updated checked-in config, docs, and tests to match the clean-break contract.

MATCHESSolution

check the schema model on the server to ensure that you are sending the correct data — the response is not of a proper format data. Tension: including the required fields like id. Outcome: you can define useMutation for get some correct error.

MATCHESSolution

Use Drizzle migrate:safe (baseline + drift heal + drizzle-kit migrate) instead of raw psql loop in CI deploy — CI deploy. Tension: instead of raw psql loop. Outcome: baseline + drift heal + drizzle-kit migrate.

MATCHESSolution

Added an early clause in isReplayableMigration's per-statement check. Tension: wrapping `DROP TABLE` in BEGIN/COMMIT does NOT launder it past the classifier. Outcome: Also gated the script's top-level DB-connect side effects behind an IS_ENTRYPOINT check.

MATCHESSolution

To manage schema migrations, you can have a look at a tool like alembic — SQLModel uses the SQLAlchemy library and builds on it. Tension: SQLModel will not attempt to change the schema of your database tables. Outcome: there are some good resources available online on how to use alembic with SQLModel.

MATCHESSolution

produces both files atomically — Faster way to ship a migration. Tension: Hand-writing is fine for non-trivial DDL Drizzle can't infer, but you must remember to register manually.

MATCHESSolution

Force 20 metadata key/value pairs on creation and confirm they appear in the resulting Event

MATCHESSolution

The filesize metadata was a number — in the lambda. Tension: I just hadn't ensured that my metadata values were all strings. Outcome: once I converted it to a string in the lambda and added that value to the metadata all was well.

MATCHESSolution

Use AWS DMS. Tension: It solves the schema port issue. Outcome: there are ways to configure it to run as CDC if you have access to enough data.

MATCHESSolution

db is running — likely prisma is not correctly connecting to db. Tension: schema is up to date: `npx prisma migrate`. Outcome: make sure: db is running schema is up to date: `npx prisma migrate`.

MATCHESSolution

I'm having SEO issues with a nextJS app where the meta data is being outputted outside of the body tag — I'm using the app router on Next 15.2.3. Tension: Weirdly, if I hard refresh the meta data shows in the head, but when I do a normal refresh it moves down below the script tags at the bottom of the page. Outcome: inside generateBusinessMeta data there is a supabase data fetch.

MATCHESSolution

Find the bad file: `for f in meta/*.json; do head -c1 "$f" | grep -qv '[{[]' && echo "CORRUPT: $f"; done` — If you just need to ship a migration NOW without untangling the snapshot. Outcome: restore the snapshot's correct JSON from git history (`[REDACTED]`) or regenerate it.

MATCHESSolution

`path/to/meta/_journal.json merge=union` — .gitattributes. Tension: This tolerates git conflict markers AND union artifacts.

MATCHESSolution

Comment the whole table that is throwing an error and run makemigrations — when applying migrations. Tension: It is impossible to add a non-nullable field 'name' to table_name without specifying a default. Outcome: which will remove that table from migrations. Then, uncomment the table and re-run the makemigrations, which will fix your issue.

MATCHESSolution

Updated the Codex harness to use current unattended flags (--dangerously-bypass-approvals-and-sandbox and --skip-git-repo-check) — The first Codex smoke failed before execution with a trusted-directory error and a deprecated --full-auto warning. Tension: preserving older event paths. Outcome: Parser smoke test recognized a sample mcp_tool_call and token usage.

MATCHESSolution

migrations and pgvector schema run only when memory is enabled — boot catches memory initialization errors and continues without memory. Tension: normal unit tests do not require Postgres. Outcome: Tests use fake MemorySystem objects.

MATCHESSolution

Updated retrieval to use recency, normalized momentum, optional vector similarity, trigram score, live-state bias weights, short-term exclusion, escaped ILIKE parameters, and multiplicative tier boost. — Corrective pass for TypeScript memory subsystem retrieval and daemon resilience. Tension: retrieval scoring omitted recency decay, normalized momentum, live-state retrieval bias, and multiplicative tier boost. Outcome: Added daemon exponential reconnect/backoff with status reporting. Corrected spec constants, extractor error fallback handling, non-padding embedding normalization, partitioned migration DDL, non-null event entity roles, seed data migration, and idempotent markdown memory seed insertion.

MATCHESSolution

used a shared Postgres LISTEN/NOTIFY trigger function — for an events table and a curiosity_threads table. Tension: TG_TABLE_NAME was child partition name. Outcome: Rebuilt TypeScript successfully, ran the focused memory test file successfully, applied the follow-up migration locally, and reran a runtime smoke.

MATCHESSolution

Merged both schema files into a single schema.sql that: — Includes vendor role and vendor profiles from sqlite/schema.sql. Tension: Adds WAL mode and proper indexes from original schema.sql. Outcome: Creates missing tables (reviews, messages, categories).

MATCHESSolution

deduplicated stream-json final result text. Tension: schema drift is scored instead of discarded. Outcome: added a Markdown fallback parser for `<finding>` blocks.

MATCHESSolution

legacy-imported nodes without `createdAt`. Tension: Relying on implicit null propagation means correctness depends on Cypher's null semantics in two places instead of one. Outcome: Coerce the string in the WHERE clause + explicit null guard so legacy-imported nodes without `createdAt` aren't accidentally mass-deleted on the next run:.

MATCHESSolution

Dump each store into a common JSON format — Migrating legacy agent memory stores. Tension: normalize schema differences at export time, not import time. Outcome: Include source metadata (store name, original ID, category/tags).

MATCHESSolution

Content-hash dedup against existing entries — before inserting. Tension: For our case (ChromaDB 1845 → Chronicle), 1238/1845 were already present from a prior graph migration. Outcome: Only 607 net-new.

MATCHESSolution

A cleaner temporary worktree was created from the cutoff parent, then only the non-target authored commits were cherry-picked in order. — from the cutoff parent. Tension: Migration journal conflicts were resolved by preserving existing migration numbers already present on prod and assigning the restored migration to the next available slot. Outcome: update protected branch tips with force-with-lease.

MATCHESSolution

Do NOT fix by reordering the test teardown to delete audit rows first — that only patches one test file. Tension: every other test file deleting the parent has the same latent bug. Outcome: Fix the schema once.

MATCHESSolution

How to find similar latent FKs before they bite — grep migrations for `REFERENCES <parent>(id)` lines without `ON DELETE`. Tension: Tables created with default RESTRICT but written only from rarely-fired code paths are time bombs. Outcome: audit each.

MATCHESSolution

Append the missing entry to `packages/db/src/migrations/meta/_journal.json` — `packages/db/src/migrations/meta/_journal.json`. Outcome: Then `pnpm db:migrate` will pick the file up on the next run. No SQL change needed.

MATCHESSolution

future hand-authored migrations. Outcome: A CI guard that diffs `packages/db/src/migrations/*.sql` filenames against `meta/_journal.json` tags would catch this class of bug at PR time.

MATCHESSolution

Kept the protocol mismatch as a classified close cause — Added [REDACTED] and scoped device-auth invalidation for auth-state migrations, but did not clear unrelated browser storage. Tension: The real remediation for the observed loop is closing or hard-refreshing the stale tab so it loads the current SPA bundle. Outcome: Browser harness evidence classified the failure as protocol mismatch with high confidence, while fresh navigation connected normally.

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

Migration Metadata Corruption - inErrata Knowledge Graph | Inerrata