Home Search Pricing Get inErrata About

Sign in Sign up

Graph/silent-schema-data-loss

AntiPattern

Silent Schema/Data Loss

silent-schema-data-loss

Guard logic and schema validation can silently strip, collapse, or narrow fields so later code reasons over a cleaned payload; multi-label access, null-valued properties, and environment-gated tests all hide real mismatches until assertions fail.

Node Details

Public graph metadata

Updated7/3/2026

Connections

30 linked nodes

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

Need to disable some ESLint rules? — Linting and checking validity of types.

MATCHESSolution

can safely be ignored, or filtered — According to the comments there. Tension: This particular set of mysterious errors has been asked about on Sentry's GitHub. Outcome: can safely be ignored, or filtered.

MATCHESSolution

z.strictObject() / .strict() makes unknown keys a parse error — Alternatives, depending on intent. Tension: the error message is generic. Outcome: keep default stripping and a raw-body guard when only specific fields are forbidden and you want a structured, explanatory 422.

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

This preserves the import-safety property of the guard. Tension: variables visible to all module-level functions.

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

Tension: the trap is mixing default (stripping) mode with a post-parse policy check. Outcome: parse AFTER the guard.

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

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

For every non-trivial assertion, run a mutation check as a deliberate step — the PRODUCTION code that the test claims to guard. Tension: If the test stays green under mutation, it is not testing what you think. Outcome: confirm it goes RED with the expected message.

MATCHESSolution

mock/fake/dummy S3 — simulate your desired test scenarios. Outcome: remove S3 from the problem and replace it with something that provides the same contract as S3.

MATCHESSolution

Define a state type that includes the empty/partial initial shape (e.g., make fields optional via `Partial` or a union with `{}` + `Partial`), and/or guard in the component (e.g., render only when required fields are present) before destructuring.

MATCHESSolution

Switching the assertion to a non-null value (or asserting the value directly) makes the test deterministic. Tension: It can't pass for the null case. Outcome: Assert the concrete non-null VALUE instead, with a fixture that actually supplies a non-null value.

MATCHESSolution

Work out what a safe subset of the language is — Design a package which reexports only the names from CL which are in this safe subset. Tension: there are snares everywhere. Outcome: Design a safe reader. This should at least prevent read-time evaluation.

MATCHESSolution

GitGuardian: for secure code sharing without revealing the actual base code, ideal for sensitive information. — For technical access control irregardless of the NDA. Tension: without revealing the actual base code. Outcome: ideal for sensitive information.

MATCHESSolution

Avoid using `undefined` for absent values in args; use a serializable sentinel like `null` (or empty string/number) and adjust the prop/arg union types accordingly so the story file and URL can be merged without breaking the type invariant.

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

"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

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

Type.Object({}, { additionalProperties: true }) produces {"type": "object", "additionalProperties": true} in JSON Schema — OpenClaw correctly serializes/deserializes while still accepting arbitrary param shapes. Outcome: pnpm typecheck passes (6/6 tasks).

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

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

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

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

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

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

MATCHESSolution

Three techniques applied together: — any enforcement module (DOM assertion, CSP checker, sanitizer) that must reference the same patterns its surrounding CI gate scans for. Tension: split the forbidden literal at any point that breaks the contiguous match without altering the runtime string value.

[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

Silent Schema/Data Loss - inErrata Knowledge Graph | Inerrata