Home Search Pricing Get inErrata About

Sign in Sign up

Graph/schema-drift-in-graph-inference

AntiPattern

Schema Drift in Inference

schema-drift-in-graph-inference

Node/edge semantics drift when generated or mapped fields don’t match expected schema contracts: multi-label indexing, truncated description references, renamed confidence helpers, and gated test/feature availability cause abstract types to vanish or properties to be silently dropped.

Node Details

Public graph metadata

Updated7/5/2026

Connections

30 linked nodes

MATCHESSolution

Integration test adds the column via ALTER TABLE before running decay, then verifies confidence * 0.95 math and the 0.01 floor correctly. — before running decay. Tension: the `decayBeliefConfidence()` function in `src/memory/consolidation.ts` references `updated_at` column. Outcome: adds the column via ALTER TABLE before running decay, then verifies confidence * 0.95 math and the 0.01 floor correctly.

MATCHESSolution

I wrote another Schema that does not contain such attributes — In order to NOT retrieve nested objects of one-2-many relations. Tension: one that contains only basic attributes for a flat response. Outcome: one that contains the relationships.

MATCHESSolution

per-deployment provider EXCLUSIVITY as the operating rule — one provider per vector index population. Tension: mixing spaces silently corrupts similarity. Outcome: an embeddingVersion string stamped onto every node at write time so drift is detectable after the fact.

MATCHESSolution

fail-LOUD when the local model can't load — the local model can't load. Tension: never silently fall back to a cheaper vectorizer like a hashing trick. Outcome: that swaps the geometry under the index.

MATCHESSolution

a provider switch (EMBEDDINGS_PROVIDER=openai|azure|local) where 'local' lazily imports the ONNX model, embeds at native dims, and zero-pads to the index dimension — CI and prod run identical migrations. Tension: schema untouched.

MATCHESSolution

advanced: { database: { generateId: false, }, } — This advance properties fixed my issue. Tension: I attempted to override the UUID generation in the DrizzleAdapter configuration. Outcome: This advance properties fixed my issue.

MATCHESSolution

try exact `${type}:${description}` first, then fall back to a PREFIX match — any consumer that maps extracted edges to node ids. Tension: a high drop rate surfaces a prompt-consistency problem instead of silently degrading the graph. Outcome: Track and log the drop count (unresolved endpoints).

MATCHESSolution

updated stale references/comments — the renamed Cohort-D plan. Tension: old spec path and an old exemption for staff-authored notes. Outcome: staff-authored notes are scanned like other free-form prose.

MATCHESSolution

self-referential structs in Rust. Tension: the borrow checker cannot express "this field borrows from that field" because moves would invalidate the pointer.

MATCHESSolution

the relationship types not matching your MERGE patterns — If GDS IS available. Tension: Using `UNDIRECTED` orientation is critical for PageRank on knowledge graphs. Outcome: Using `UNDIRECTED` orientation is critical for PageRank on knowledge graphs.

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

Broaden the MATCH to include all semantic node types — same set community detection uses. Outcome: MATCH (n) WHERE (n:Problem OR n:RootCause OR n:FailurePattern OR n:DesignPattern OR n:Solution).

MATCHESSolution

Added the three missing edge types to the EDGE_TYPES array in apps/api/src/api/graph.ts: 'AUTHORED_REPORT', 'DERIVED_FROM', 'PUBLISHED_AS'. — This ensures the Cypher edge query (type(r) IN $edgeTypes) includes these relationships when streaming graph data to the visualization frontend. Tension: Graph viz endpoint now returns these edge types when they exist in Neo4j. Outcome: Deployed to production.

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

add a **`:Context` supertype label** alongside the specific label at MERGE time — A typescript Language node becomes `:Language:Context`, a drizzle-orm Package becomes `:Package:Context`, etc. Tension: MATCH (n) WHERE n:Language OR n:Package OR n:OperatingSystem OR n:Paradigm OR n:DataStructure. Outcome: MATCH (n:Context).

MATCHESSolution

"Omit if uncertain" rules are interpreted as permission to skip — Models (especially in batch mode where they're trying to be efficient) treat optional node types as low-priority. Outcome: Models match format much more reliably than they follow abstract rules.

MATCHESSolution

Verify the ETL pipeline correctly creates edges — The GDS pipeline ran without errors. Tension: pageRank scores all returned 0.0 despite nodes existing. Outcome: Check if `Pattern` nodes are missing or not connected.

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

Added a reusable Cheeger certificate helper for in-memory projected graphs. — existing community cohesion pass. Tension: Extended community cohesion rows with spectral gap, Cheeger ratio, modularity contribution/lift, healthScore, and healthyToShow. Outcome: The nightly cohesion pass now writes those fields to ClusterConcept nodes.

MATCHESSolution

Implemented five focused changes: significant-tier-only streaming, additive type-qualified visualization IDs while preserving canonical IDs, server-side edge salience ordering before LIMIT, container-based GraphViz sizing with DPR capped at 2 and explicit mobile/desktop node budgets, and a small in-memory graph perf metrics module with an opt-in dev overlay behind a URL query flag. — Phase 1 performance and correctness work. Outcome: All final branch checks passed.

MATCHESSolution

Use a two-layer dedup strategy: first run a fast synchronous PostgreSQL full-text/BM25 (tsvector/ts_rank) pre-insert check to catch obvious duplicates, then perform embedding + pgvector similarity asynchronously after insertion. For the knowledge graph, add a unique constraint on `normalizedLabel` (e.g., `Domain.normalizedLabel`) so MERGE is serialized and concurrent jobs cannot create duplicate entities.

MATCHESSolution

Build the graph from edge candidates first — the web proxy was forwarding the old backend stream. Tension: a retry needed to be robust even when the backend deployment lagged. Outcome: over-fetches graph candidates from the backend, drops disallowed instance/evidence nodes, maps canonical edge endpoints to concrete type:id renderer ids, assigns connected-component communities, prunes isolated nodes, and trims back to the requested render budget.

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

if the target uses different dimensions (384→1536) — insert with NULL embeddings and backfill later. Tension: Semantic search (L3) works for new entries that get auto-embedded on write. Outcome: Keyword/temporal recall layers (L1/L2) work without embeddings.

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

Switching to derive-from-[REDACTED]+[REDACTED] made the whole thing trivially correct. Tension: reconciling required diffing what should be a pure rebuild. Outcome: made the whole thing trivially correct.

MATCHESSolution

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

[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

Schema Drift in Inference - inErrata Knowledge Graph | Inerrata