Peter Steinberger
10453a8d8b
* fix(doctor): migrate every agent database before repairs open it Complete configured session-store targets before media/schema repair. Recognize intact pre-journal v1 state without releasing lost-history holds, and fail explicit Doctor repair when those holds remain unresolved. Refs #158359. * fix(tooling): include journal admission in wrapper inventory * fix(doctor): admit pre-journal v1 stores with writer metadata Treat app_version as optional writer metadata rather than evidence that a schema-v1 store had a deletion journal. Keep the schema, ownership, newer-table, journal-receipt, and recovery-hold guards intact. Register the agent database ordering regression with the runtime-build prerequisite owner so it runs in a clean checkout. The two CI runtime-inventory expectation updates add exactly this newly registered test input; they preserve exact equality, runtime preparation, ownership, and worker-bound checks. Refs #158359. * test(state): require initialized journal after v1 admission The accepted production behavior intentionally initializes the canonical agent_deletion_journal when admitting a valid pre-journal v1 store. Update the v2026.7.1-2 fixture contract to require the complete canonical schema and assert that the deletion-history owner reports known-empty history. This expectation changes because journal initialization changed intentionally in production, not to silence the check. Preserve the full schema comparison, frozen fixture hashes, retained-data checks, and modern lost-history assertions. Refs #158359.
SQLite Release Fixtures
openclaw-agent-schema-v14.sql is the exact agent DDL from tag
v2026.7.2-beta.4; openclaw-agent-schema-v15.sql is the exact DDL from
commit 509a5f0373764. Their media-migration tests retain the original SHA-256
contracts. openclaw-agent-schema-v21.sql freezes commit
f69617aa3818d805889692918ee7f51bef666597 as an independent schema-21 migration input.
openclaw-agent-schema-v19.sql freezes commit
fb380bd4879be34aa160675d653560bb79690db9, the last schema-19 commit before the
schema-20 cold-storage migration, for container image replacement startup tests.
openclaw-agent-schema-v22.sql freezes the deployed FTS ownership DDL from
commit 00caa84ce72c0b4edd584cfa225bd262cd10ba49 (#153834).
It contains (session_id, fts_rowid) ownership and nullable fts_row_count,
not the unpublished compressed schema-22 draft.
Golden source contracts:
- Schema 19: 28,402 bytes; Git blob
c7034eff720b35a8f78f48ce07c3d2a554f5124e; SHA-256fe93217454642e911608f81afc53c9fb3bb7c20cc32bc73f8f6eeaaf232b91b8. - Schema 21: 34,836 bytes; Git blob
3dda3eb4928efc3fb74ff3a37337417cc7d30e74; SHA-2568deb7d7000eab7c43bbee427f2e7a9b603bc549562594088a14eecf7c8cc5926. - Schema 22: 35,110 bytes; Git blob
9c6c775549e92a021ea7f5b43d749718ba1189c7; SHA-25623f2a1e85494a512bce3f32623aed2beaf4e82bbeeb4362f6cc33d5dd3b8a6ea.
Historical fixtures read these sources without deriving old tables from current DDL.
openclaw-state-v2026.7.1-2.sqlite.gz is a deterministic fixture for the
shared state database created by OpenClaw tag v2026.7.1-2 at commit
0790d9f593ad30c940ed93b5872a8cf6d6f3cf8c.
The tagged runtime, whose package version is 2026.7.1, created the database
with Node v26.7.0 and SQLite 3.51.0. The fixture then received fixed
synthetic rows for durable state, audit sequence preservation, diagnostic
ordering, task foreign keys, cron history import, and one representative
commitment. The commitment exists solely to prove irreversible retirement of
shipped commitment data; it is not archived or exported. Metadata timestamps
are fixed, the WAL is checkpointed, and the database is vacuumed before
deterministic Node gzipSync(raw, { level: 9, mtime: 0 }) compression.
The sorted sqlite_schema rows are byte-identical to a database initialized
from src/state/openclaw-state-schema.sql at the commit above. Synthetic data
and metadata normalization do not alter the released schema.
Fixture contract:
- raw SQLite SHA-256:
8511bb91f02d104f818c70b08397a678045d04741c931b0ee7ce6650b5519e85 - gzip SHA-256:
c775499d9a46462ae2368090a0c4ec75877784c40694046dd3af63df77b8737c - sorted
sqlite_schemaSHA-256:f2fd6488e283470718547fb45886f04cc940b1de798e52fbf34a3a3408ae25e4 - 73 application tables
- 103 named indexes
- zero
STRICTtables