fix(store): prune run checkpoints and persist their delta state

[DeliciousBuding]

Summary

Investigate and fix the concrete checkpoint delta omission found during #2333, rather than retuning SQLite's pool. At 2f5f987a, cloneFileSnapshot does not copy Checkpoints, although deltaSQLiteCheckpointRows compares the old/new checkpoint maps. The #2333 baseline measures 13 / 103 / 1003 SQL row changes for one run mutation with 10 / 100 / 1000 resident checkpoints. This proves write amplification in the declared workload; cleanup durability still needs an independent red test. Further source inspection found a second omission: Store.removeRunEvidence does not delete checkpoints when deleting a thread or pruning a run. The reproduction must therefore check both memory cleanup and durable deletion; do not assume memory cleanup already works.

Scope / Files / File Ownership

One local writer, independent from the benchmark PR #2334:

• edge-server/internal/store/sqlite_store_query.go: preserve a deep-cloned checkpoint map in the committed delta baseline, if the red tests confirm the omission.
• edge-server/internal/store/store_projects.go: remove the run-owned checkpoint at the existing shared evidence-pruning boundary, if the lifecycle regression confirms the omission.
• docs/architecture/02-edge-server.md: synchronize the existing cascade description with the verified checkpoint behavior.
• edge-server/internal/store/sqlite_store_query_test.go: extend the existing clone ownership/immutability test rather than add a mirror-of-fields test.
• edge-server/internal/store/sqlite_checkpoint_delta_test.go: real SQLite regressions for unchanged checkpoint rewrites and checkpoint deletion surviving run cleanup and reopen.

No connection-pool, PRAGMA, schema/migration, API, background timer, FileStore, benchmark or live-service changes.

Interfaces / Invariants

Retain current public signatures and update the delta baseline only after successful transaction commit. Reuse cloneCheckpointMap, including nested Files ownership. Legitimate checkpoint updates must still persist; retained runs/checkpoints must survive cleanup of a different terminal run. Do not mask missing durable writes with a final Close/Flush before validating the database.

Acceptance

1. Reproduce on the starting code: a real SQLite audit trigger observes rewriting unchanged checkpoint rows after an unrelated run mutation; terminal-run cleanup and thread deletion must remove the checkpoint both in memory and in its persisted row, and keep it absent through reopen. Record actual red output before any production edit.
2. Minimal fix plus existing clone test verifies nested checkpoint files are not shared.
3. Green regressions include a legitimate checkpoint content update (audit sensitivity), preservation of the unrelated checkpoint, and actual reopen before an extra final Close flush.
4. Full store-package Linux race, Windows store tests, vet/staticcheck and all required PR checks pass. Preserve unrelated WIP.
5. Reuse the merged test(store): benchmark snapshot persistence and SQLite facade contention #2334 workload for a matching-scope before/after check: report row-change delta and timing without promising production gains. Do not change the fixture to improve the result.
6. Update perf(store): measure snapshot persistence and real SQLite facade contention #2333/后端性能候选收口：限定测量与 ctx / checkpoint 修复完成 #2256 with the reproduced outcome and linked fix, then clean the merged task worktree/branch.

Negative Constraints / Dependencies

Only local disposable SQLite fixtures. No user data, production database repair, deployment or live performance claim. No automatic deletion of historical persisted orphans: any existing-data cleanup is a separate migration/repair decision. Benchmark tooling is #2334; the correctness regression is independently runnable on the current mainline.

[DeliciousBuding]

Reproduced locally, then fixed — 2026-09-06

Starting production code: 9495dbd8e321bae46987840d96b921e5270e0963. These tests use real temporary SQLite stores and database triggers, not mocks.

=== RUN   TestSQLiteCheckpointDeltaSkipsUnchangedRows
    sqlite_checkpoint_delta_test.go:33: unrelated run mutation rewrote 2 unchanged checkpoints
    sqlite_checkpoint_delta_test.go:46: legitimate checkpoint edit updated 2 rows, want only its own row
--- FAIL: TestSQLiteCheckpointDeltaSkipsUnchangedRows (0.02s)
=== RUN   TestSQLiteCheckpointDeltaRemovesRunEvidence
=== RUN   TestSQLiteCheckpointDeltaRemovesRunEvidence/terminal-cleanup
    sqlite_checkpoint_delta_test.go:91: removed run's checkpoint remains in memory
    sqlite_checkpoint_delta_test.go:99: removed run still has 1 durable checkpoint rows
    sqlite_checkpoint_delta_test.go:108: removed run's checkpoint reappears after reopen
=== RUN   TestSQLiteCheckpointDeltaRemovesRunEvidence/delete-thread
    sqlite_checkpoint_delta_test.go:91: removed run's checkpoint remains in memory
    sqlite_checkpoint_delta_test.go:99: removed run still has 1 durable checkpoint rows
    sqlite_checkpoint_delta_test.go:108: removed run's checkpoint reappears after reopen
--- FAIL: TestSQLiteCheckpointDeltaRemovesRunEvidence (0.03s)
    --- FAIL: TestSQLiteCheckpointDeltaRemovesRunEvidence/terminal-cleanup (0.01s)
    --- FAIL: TestSQLiteCheckpointDeltaRemovesRunEvidence/delete-thread (0.01s)
=== RUN   TestCloneFileSnapshot
=== PAUSE TestCloneFileSnapshot
=== CONT  TestCloneFileSnapshot
    sqlite_store_query_test.go:286: checkpoint missing or changed in cloned snapshot
--- FAIL: TestCloneFileSnapshot (0.00s)
FAIL
FAIL	github.com/agenthub/edge-server/internal/store	0.064s
FAIL

The first TTL attempt used completed, which is not an Edge terminal run status; that fixture failure is excluded. The output above is the corrected finished fixture rerun before production edits. The architecture owner's terminal-status wording is corrected along with checkpoint lifetime.

Two independent omissions are confirmed:

1. Store.removeRunEvidence did not remove the run-owned checkpoint during terminal cleanup or thread deletion. Both memory and persisted rows retained it, including after reopen.
2. cloneFileSnapshot omitted checkpoints from the committed SQLite delta baseline. Unrelated run mutations rewrote both unchanged fixture checkpoints; the nested clone test also failed.

The implementation adds only delete(s.checkpoints, runID) at the existing shared cleanup boundary and Checkpoints: cloneCheckpointMap(snapshot.Checkpoints) at the existing clone boundary. No pool/schema/timer/API change.

Corrected regressions now pass on Windows (pure-Go SQLite, 0.058 s): unchanged checkpoints get zero row updates; a legitimate content edit updates its own row and survives readback; cleanup and thread deletion remove their checkpoint both in memory and SQLite while preserving the unrelated run/checkpoint. Readback precedes an extra Close/Flush. Nested Files clone ownership is verified. Full package verification and matching-fixture non-race measurement follow before merge.

This does not automatically repair historical orphan checkpoints already present in a live store; there is no migration, production database access or deployment in this change.

[DeliciousBuding]

Matching-fixture post-fix measurement

Post-fix source: 350ee4fba3bc938e0fe472fe059218724fcbed40 (PR #2336). Baseline source/raw samples: 3e326515b46ade47692012dbcc45e1e563ce8d7b; production baseline is now merged at 9495dbd8. git diff 9495dbd8 -- edge-server/internal/store/persistence_bench_test.go edge-server/internal/store/sqlite_contention_bench_test.go is empty: fixture and instrumentation are unchanged.

Same local Ubuntu 24.04 / WSL2, Linux temp filesystem, Go 1.26.5, i7-14700HX, GOMAXPROCS=4. From edge-server:

CGO_ENABLED=1 go test -p 2 ./internal/store -run '^$' \
  -bench '^BenchmarkSQLiteFacadeContention$' \
  -benchtime=1s -count=5 -cpu=4 -benchmem -timeout=10m

All 45 post-fix samples pass. All SQL pool wait-count/duration deltas remain zero and the pool remains single-connection. All checkpoint-inclusive snapshot readbacks before Close pass. No SQL/lock/busy/read-correctness errors.

Case	baseline median ms/write	fixed median ms/write	change in median mean	fixed min–max ms/write	SQL row changes/write
runs=10/readers=0	0.791	0.659	-16.7%	0.638–0.668	13 → 3
runs=10/readers=1	1.338	1.074	-19.7%	1.024–1.109	13 → 3
runs=10/readers=4	2.559	2.505	-2.1%	2.127–2.625	13 → 3
runs=100/readers=0	6.277	4.121	-34.3%	4.046–4.445	103 → 3
runs=100/readers=1	10.769	6.509	-39.6%	6.193–7.214	103 → 3
runs=100/readers=4	20.827	14.132	-32.1%	13.349–18.561	103 → 3
runs=1000/readers=0	62.315	39.663	-36.4%	39.283–40.544	1003 → 3
runs=1000/readers=1	84.782	48.036	-43.3%	47.424–51.839	1003 → 3
runs=1000/readers=4	127.743	93.124	-27.1%	87.386–94.319	1003 → 3

The deterministic result is that one run mutation no longer rewrites every unchanged checkpoint: 13 / 103 / 1003 → 3 total_changes() deltas at the declared scales. The table reports medians of per-run mean operation times, not operation p50 or a production SLO. The smallest four-reader comparison has overlapping ranges and is not claimed as a statistically significant speedup. The 1,000-run writer-only local median is 62.315 → 39.663 ms (36.4% lower); this is a local workload result, not a production guarantee.

The fix does not reduce writer-only allocation: its 1,000-run median goes from about 55.25 to 56.39 MiB/write, consistent with retaining/deep-copying the missing checkpoint baseline and comparing it. Concurrent-reader allocated bytes are process-wide and are not attributed to the writer. No memory/RSS saving is claimed. All raw histogram values remain clock-observed power-of-two bucket upper bounds; the short run does not exercise five-minute background maintenance.

Verification is complete locally: full store-package Linux race (4.996 s), full Windows store tests with pure-Go SQLite (1.569 s), vet, staticcheck and doc SSOT pass. GitHub required checks are checked independently before merge. No live store repair, migration or deployment.

All 45 post-fix non-race samples

goos: linux
goarch: amd64
pkg: github.com/agenthub/edge-server/internal/store
cpu: Intel(R) Core(TM) i7-14700HX
BenchmarkSQLiteFacadeContention/runs=10/readers=0-4         	    1941	    638362 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	    524288 write-p50-observed-upper-ns	   2097152 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1941 write-samples	      1567 writes/s	  584307 B/op	    1683 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=0-4         	    1810	    658792 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	    524288 write-p50-observed-upper-ns	   2097152 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1810 write-samples	      1518 writes/s	  584381 B/op	    1683 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=0-4         	    1780	    663610 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	    524288 write-p50-observed-upper-ns	   2097152 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1780 write-samples	      1507 writes/s	  584384 B/op	    1683 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=0-4         	    1840	    657589 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	    524288 write-p50-observed-upper-ns	   2097152 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1840 write-samples	      1521 writes/s	  584367 B/op	    1683 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=0-4         	    1758	    668218 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	    524288 write-p50-observed-upper-ns	   2097152 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1758 write-samples	      1497 writes/s	  584394 B/op	    1683 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=1-4         	    1166	   1024174 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       256.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	      8192 read-cycle-p99-observed-upper-ns	   1551527 read-cycle-samples	   1299151 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   1048576 write-p50-observed-upper-ns	   4194304 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1166 write-samples	       976.4 writes/s	 2971864 B/op	    3024 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=1-4         	    1131	   1074948 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       256.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	      8192 read-cycle-p99-observed-upper-ns	   1535873 read-cycle-samples	   1263198 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   1048576 write-p50-observed-upper-ns	   4194304 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1131 write-samples	       930.3 writes/s	 3021131 B/op	    3053 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=1-4         	    1116	   1061557 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       256.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	      8192 read-cycle-p99-observed-upper-ns	   1473380 read-cycle-samples	   1243579 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   1048576 write-p50-observed-upper-ns	   4194304 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1116 write-samples	       942.0 writes/s	 2953379 B/op	    3015 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=1-4         	    1094	   1074001 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       256.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	      8192 read-cycle-p99-observed-upper-ns	   1467449 read-cycle-samples	   1248851 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   1048576 write-p50-observed-upper-ns	   4194304 write-p95-observed-upper-ns	   4194304 write-p99-observed-upper-ns	      1094 write-samples	       931.1 writes/s	 2991223 B/op	    3036 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=1-4         	    1129	   1108711 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       256.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	      8192 read-cycle-p99-observed-upper-ns	   1518280 read-cycle-samples	   1212701 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   1048576 write-p50-observed-upper-ns	   4194304 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	      1129 write-samples	       901.9 writes/s	 2997338 B/op	    3039 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=4-4         	     517	   2126539 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       512.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	     32768 read-cycle-p99-observed-upper-ns	   1863131 read-cycle-samples	   1694324 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   2097152 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       517.0 write-samples	       470.2 writes/s	 7048205 B/op	    5309 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=4-4         	     502	   2505096 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       512.0 read-cycle-p50-observed-upper-ns	      4096 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	   1895463 read-cycle-samples	   1507157 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       502.0 write-samples	       399.2 writes/s	 7357597 B/op	    5485 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=4-4         	     513	   2625488 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       512.0 read-cycle-p50-observed-upper-ns	      4096 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	   1942645 read-cycle-samples	   1442272 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       513.0 write-samples	       380.9 writes/s	 7377295 B/op	    5496 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=4-4         	     504	   2371191 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       512.0 read-cycle-p50-observed-upper-ns	      4096 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	   1822413 read-cycle-samples	   1524837 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       504.0 write-samples	       421.7 writes/s	 7070749 B/op	    5324 allocs/op
BenchmarkSQLiteFacadeContention/runs=10/readers=4-4         	     416	   2518845 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	       512.0 read-cycle-p50-observed-upper-ns	      2048 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	   1621406 read-cycle-samples	   1546936 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       416.0 write-samples	       397.0 writes/s	 7576077 B/op	    5607 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=0-4        	     264	   4444877 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       264.0 write-samples	       225.0 writes/s	 5879843 B/op	   14587 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=0-4        	     280	   4199428 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       280.0 write-samples	       238.1 writes/s	 5878084 B/op	   14581 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=0-4        	     290	   4088130 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       290.0 write-samples	       244.6 writes/s	 5877969 B/op	   14580 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=0-4        	     286	   4121214 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       286.0 write-samples	       242.6 writes/s	 5878027 B/op	   14581 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=0-4        	     291	   4045582 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	   4194304 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	   8388608 write-p99-observed-upper-ns	       291.0 write-samples	       247.2 writes/s	 5877796 B/op	   14580 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=1-4        	     168	   7213613 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	     16384 read-cycle-p95-observed-upper-ns	    131072 read-cycle-p99-observed-upper-ns	    212702 read-cycle-samples	    175500 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	  16777216 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       168.0 write-samples	       138.6 writes/s	29230812 B/op	   15910 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=1-4        	     180	   6577508 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	     16384 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	    254133 read-cycle-samples	    214635 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       180.0 write-samples	       152.0 writes/s	31910463 B/op	   16028 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=1-4        	     184	   6508586 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	     16384 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	    272580 read-cycle-samples	    227602 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       184.0 write-samples	       153.6 writes/s	33193154 B/op	   16100 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=1-4        	     193	   6193184 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	     16384 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	    276472 read-cycle-samples	    231275 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       193.0 write-samples	       161.5 writes/s	32291128 B/op	   16049 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=1-4        	     190	   6267884 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	     16384 read-cycle-p95-observed-upper-ns	     65536 read-cycle-p99-observed-upper-ns	    275227 read-cycle-samples	    231099 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	   8388608 write-p50-observed-upper-ns	   8388608 write-p95-observed-upper-ns	  16777216 write-p99-observed-upper-ns	       190.0 write-samples	       159.5 writes/s	32587118 B/op	   16065 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=4-4        	      64	  18560576 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      2048 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    524288 read-cycle-p99-observed-upper-ns	    299857 read-cycle-samples	    252415 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  33554432 write-p50-observed-upper-ns	  33554432 write-p95-observed-upper-ns	  33554432 write-p99-observed-upper-ns	        64.00 write-samples	        53.88 writes/s	92293791 B/op	   19497 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=4-4        	      90	  13348538 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      4096 read-cycle-p50-observed-upper-ns	     65536 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	    382802 read-cycle-samples	    318622 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  16777216 write-p50-observed-upper-ns	  16777216 write-p95-observed-upper-ns	  33554432 write-p99-observed-upper-ns	        90.00 write-samples	        74.91 writes/s	84304545 B/op	   18954 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=4-4        	      98	  14132213 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      4096 read-cycle-p50-observed-upper-ns	     65536 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	    407112 read-cycle-samples	    293940 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  16777216 write-p50-observed-upper-ns	  33554432 write-p95-observed-upper-ns	  33554432 write-p99-observed-upper-ns	        98.00 write-samples	        70.76 writes/s	82476766 B/op	   18852 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=4-4        	      86	  14392526 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      4096 read-cycle-p50-observed-upper-ns	     65536 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	    365594 read-cycle-samples	    295353 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  16777216 write-p50-observed-upper-ns	  33554432 write-p95-observed-upper-ns	  33554432 write-p99-observed-upper-ns	        86.00 write-samples	        69.48 writes/s	84261514 B/op	   18943 allocs/op
BenchmarkSQLiteFacadeContention/runs=100/readers=4-4        	      99	  14110334 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	      4096 read-cycle-p50-observed-upper-ns	     65536 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	    423421 read-cycle-samples	    303062 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  16777216 write-p50-observed-upper-ns	  33554432 write-p95-observed-upper-ns	  33554432 write-p99-observed-upper-ns	        99.00 write-samples	        70.87 writes/s	84738764 B/op	   18971 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=0-4       	      27	  40543574 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        27.00 write-samples	        24.66 writes/s	59127808 B/op	  143435 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=0-4       	      26	  39626987 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        26.00 write-samples	        25.24 writes/s	59124796 B/op	  143423 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=0-4       	      26	  39663205 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        26.00 write-samples	        25.21 writes/s	59124900 B/op	  143424 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=0-4       	      26	  39990789 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        26.00 write-samples	        25.01 writes/s	59124438 B/op	  143422 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=0-4       	      27	  39283235 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        27.00 write-samples	        25.46 writes/s	59124922 B/op	  143424 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=1-4       	      22	  51839336 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	     27347 read-cycle-samples	     23977 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        22.00 write-samples	        19.29 writes/s	272990697 B/op	  144753 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=1-4       	      22	  47821757 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	     26895 read-cycle-samples	     25562 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        22.00 write-samples	        20.91 writes/s	269444845 B/op	  144685 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=1-4       	      24	  47423937 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	     29636 read-cycle-samples	     26036 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        24.00 write-samples	        21.09 writes/s	271564432 B/op	  144693 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=1-4       	      21	  48036459 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	     25819 read-cycle-samples	     25590 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        21.00 write-samples	        20.82 writes/s	270644175 B/op	  144692 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=1-4       	      21	  48307012 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    131072 read-cycle-p95-observed-upper-ns	    262144 read-cycle-p99-observed-upper-ns	     25895 read-cycle-samples	     25523 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	  67108864 write-p50-observed-upper-ns	  67108864 write-p95-observed-upper-ns	  67108864 write-p99-observed-upper-ns	        21.00 write-samples	        20.70 writes/s	271256906 B/op	  144690 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=4-4       	      12	  94318885 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    262144 read-cycle-p95-observed-upper-ns	   2097152 read-cycle-p99-observed-upper-ns	     49372 read-cycle-samples	     43616 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	 134217728 write-p50-observed-upper-ns	 134217728 write-p95-observed-upper-ns	 134217728 write-p99-observed-upper-ns	        12.00 write-samples	        10.60 writes/s	766942246 B/op	  147790 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=4-4       	      13	  93124180 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    262144 read-cycle-p95-observed-upper-ns	   1048576 read-cycle-p99-observed-upper-ns	     51241 read-cycle-samples	     42322 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	 134217728 write-p50-observed-upper-ns	 134217728 write-p95-observed-upper-ns	 134217728 write-p99-observed-upper-ns	        13.00 write-samples	        10.74 writes/s	737221241 B/op	  147469 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=4-4       	      13	  87385970 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    262144 read-cycle-p95-observed-upper-ns	   1048576 read-cycle-p99-observed-upper-ns	     49075 read-cycle-samples	     43195 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	 134217728 write-p50-observed-upper-ns	 134217728 write-p95-observed-upper-ns	 134217728 write-p99-observed-upper-ns	        13.00 write-samples	        11.44 writes/s	708559122 B/op	  147303 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=4-4       	      12	  92670679 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    262144 read-cycle-p95-observed-upper-ns	   1048576 read-cycle-p99-observed-upper-ns	     47790 read-cycle-samples	     42966 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	 134217728 write-p50-observed-upper-ns	 134217728 write-p95-observed-upper-ns	 134217728 write-p99-observed-upper-ns	        12.00 write-samples	        10.79 writes/s	744211318 B/op	  147510 allocs/op
BenchmarkSQLiteFacadeContention/runs=1000/readers=4-4       	      13	  94032529 ns/op	         1.000 db-open-conns	         0 db-wait-ns/op	         0 db-waits/op	         0 read-cycle-clock-zero	     32768 read-cycle-p50-observed-upper-ns	    262144 read-cycle-p95-observed-upper-ns	   1048576 read-cycle-p99-observed-upper-ns	     50197 read-cycle-samples	     41057 read-cycles/s	         3.000 sql-row-changes/op	         0 write-clock-zero	 134217728 write-p50-observed-upper-ns	 134217728 write-p95-observed-upper-ns	 134217728 write-p99-observed-upper-ns	        13.00 write-samples	        10.63 writes/s	723382832 B/op	  147399 allocs/op
PASS
ok  	github.com/agenthub/edge-server/internal/store	75.944s