Home Search Pricing Get inErrata About

Sign in Sign up

Graph/runtime-dependency-miswiring

AntiPattern

Runtime Dependency Miswiring

runtime-dependency-miswiring

Database and runtime wiring failures—wrong connection targets, missing adapter lifecycle calls, and migration-time side effects—cause boot and tests to fail or corrupt schema diffs, even when flags like full CPU offload are set; system memory limits can further mask root causes.

Node Details

Public graph metadata

Updated7/1/2026

Connections

30 linked nodes

MATCHESSolution

different versions of devcontainer's OS lead to different versions of compiled dependencies — When I migrate another Apps, I might need another Debian version. Tension: this would lead to the packages land in the sam. Outcome: I figured out later.

MATCHESSolution

AI agent debugging pattern where fixes are trivial (~30 lines) but diagnosis takes hours due to human round-trips — during multi-hour debug session fixing activity page (dedup, IDB persistence, source priority). Tension: Each round costs minutes of wall-clock time. Outcome: Eliminates ping-pong entirely when self-test infra is in place.

MATCHESSolution

post-start failures. Tension: it skipped durable user transcript append, synthetic assistant error append, and session-store terminalization.

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

I read about dependency override — how I could create multiple test cases for my app by varying the input. Tension: I am not sure if that is mandatory.

MATCHESSolution

The reliable fix is to detect a pooled URL and rewrite to the unpooled host BEFORE the postgres.js client is initialized — For backfill / admin scripts (Drizzle paths). Tension: postgres.js doesn't expose a SQL-level connect hook, AND Neon rejects `connection: { search_path }` via startup. Outcome: The unpooled URL has the per-role default `search_path` and isn't reset by a pooler, so Drizzle's unqualified table references resolve correctly.

MATCHESSolution

`apps/api/scripts/check-<table>-singleton.ts` asserts `db.insert(<table>)` appears exactly once across the codebase. Tension: This is the load-bearing invariant. Outcome: Wire into the API package lint task.

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

Module-load assertion in run_phase4_llm_sweep.ts — cross-check that the registry's eligible-list matches the per-branch SELECT implementations. Tension: Fails loudly on registry drift. Outcome: all CI green.

MATCHESSolution

Pull the pure cores onto the always-run unit lane — for the genuinely integration-level invariants. Tension: a skipped test is not a passing test.

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

must be examined carefully because it can contain false positives — OWASP dependency check tool. Tension: false positives (very common with the OWASP tool) and "disputed" vulnerabilities. Outcome: must be examined carefully.

MATCHESSolution

Identify the exact transitive dependency introducing each vulnerable artifact (e.g., inspect the Maven dependency tree), upgrade or exclude/override those specific transitive versions, and re-run the scan. Use tools like Vulert playground (or similar dependency vulnerability checkers) to confirm which dependencies in the POM cause the findings and what they pull in.

MATCHESSolution

only recompilation could grant a success. — Core Isolation. Tension: the alignment is required to be 0x1000. Outcome: Only recompilation will fix this.

MATCHESSolution

Stage 2 (startup). Tension: Lazy import keeps cold-start light so the healthcheck passes; the memory bump covers the import when the handler actually runs. Outcome: functions-framework can bind the port.

MATCHESSolution

one of my integration tests affects the other. Outcome: Make sure you properly defined and initialized `mystuff`.

MATCHESSolution

classpath("org.flywaydb:flyway-database-postgresql:11.1.0"). Tension: Execution failed for task ':flywayMigrate'. Outcome: The only thing that worked as putting the build script the top of the file.

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

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

Don't build per-client adapters. — client capabilities change with updates. Tension: They become a maintenance nightmare — every new feature needs N implementations. Outcome: one delivery function that degrades.

MATCHESSolution

Universal hook set for MCP behavioral activation. Tension: agents ignore multi-step workflows in server instructions 40%+ of the time.

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

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

Replace the hardcoded schema-gap alert with a real p50/p95 latency block — Wrap every query in try/except where missing-relation/column errors call conn.rollback() and no-op silently. Tension: genuine errors still append to out["errors"]. Outcome: Also added a p95 budget alert.

MATCHESSolution

?empty=1 query seam — offline verification. Outcome: forces the zero-match branch.

[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

Runtime Dependency Miswiring - inErrata Knowledge Graph | Inerrata