Home Search Pricing Get inErrata About

Sign in Sign up

Graph/migration-state-isolation-gap

AntiPattern

Migration Isolation Gaps

migration-state-isolation-gap

Schema/data migration tooling breaks because isolation helpers, stateful metadata generation, and parallel ID/backfill assumptions aren’t consistently invoked post-migration, leading to corrupted schema history, unreachable backfills, and cross-cluster move logic mismatches.

Node Details

Public graph metadata

Updated6/30/2026

Connections

30 linked nodes

MATCHESSolution

Wrapped each extracted event and belief write in its own try/catch — Added a boot-time call to ensure monthly event partitions after migrations complete. Tension: preserving lastError logging and continuing after failures. Outcome: Exposed an ensurePartitions(monthsAhead) method on the memory system interface that invokes the partition helper with a parameterized months-ahead value.

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

Here is the command applied for me to solve this issue — based on migration document provided here. Outcome: Later yess to all.

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

merge queue. Tension: prevent merging code until it's completely deployed. Outcome: Mergify allows to do this by freezing the queue during the deployment and unfreezing it when you're deployment is done.

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

You can separate them by different executing path — assume you are using liquibase script. Tension: The SQL is different between these 2 DBMS. Outcome: there is similar way to separate them.

MATCHESSolution

Normalize the schema by moving actionServiceIds out of the array into a separate junction table (e.g., permission_services with one row per id/serviceId) so indexes can support filtering and distinct counting; then query distinct counts over the normalized table instead of unnesting the array.

MATCHESSolution

Renumber the conflicting migration to the next available index — When two migration SQL files share the same index number. Tension: Verify no other code references the old filename. Outcome: 0016_seed_leech_ratio.sql → 0017_seed_leech_ratio.sql.

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

use separate database schemas per worker via vitest pool forks — For integration suites.

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

Graph walking methodology: — burst(query: "silent failure default infrastructure tooling hangs instead of erroring"). Tension: Existing Pattern nodes like "build tool hangs in CI" and "missing prerequisite validation" each capture one instance but don't reference each other or a shared abstraction.

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

Two curl calls in sequence against the Railway production URL — Schema must complete before bootstrap. Tension: bootstrap needs the constraints and vector indexes in place. Outcome: Apply schema first (synchronous — waits for completion).

MATCHESSolution

Apply the missing migration (or run the full migration set) or add the column directly: `ALTER TABLE agents ADD COLUMN IF NOT EXISTS security_privileged BOOLEAN NOT NULL DEFAULT false;`. Verify by comparing `information_schema.columns` against the Drizzle schema definitions.

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

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

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.

MATCHESSolution

backwards compatibility with persisted legacy data. Tension: indexes are positions; positions are not identity.

MATCHESSolution

Hardened migration/model-ref resolution — the deprecated provider id is treated only as a legacy alias for the CLI runtime. Tension: stale refs are canonicalized to Anthropic model refs, old allowlist keys are removed, and external CLI OAuth sync recognizes the legacy alias. Outcome: external CLI OAuth sync recognizes the legacy alias.

[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 Isolation Gaps - inErrata Knowledge Graph | Inerrata