Skip to content

fix: harden kanban sqlite durability#30645

Closed
GravityTone wants to merge 1 commit into
NousResearch:mainfrom
GravityTone:fix/kanban-sqlite-full-sync
Closed

fix: harden kanban sqlite durability#30645
GravityTone wants to merge 1 commit into
NousResearch:mainfrom
GravityTone:fix/kanban-sqlite-full-sync

Conversation

@GravityTone

Copy link
Copy Markdown

Summary

  • switch the Kanban SQLite connection from PRAGMA synchronous=NORMAL to FULL
  • document why Kanban favors durability over write-throughput
  • reduce the chance of malformed board state after gateway/worker crashes or forced restarts during in-flight writes

Test plan

  • python -m pytest tests/hermes_cli/test_kanban_db.py tests/hermes_cli/test_kanban_db_init.py tests/hermes_cli/test_kanban_core_functionality.py tests/hermes_cli/test_kanban_boards.py tests/hermes_cli/test_kanban_blocked_sticky.py tests/hermes_cli/test_kanban_diagnostics.py tests/hermes_cli/test_kanban_notify.py tests/hermes_cli/test_kanban_specify_db.py tests/hermes_cli/test_kanban_decompose_db.py tests/tools/test_kanban_tools.py tests/plugins/test_kanban_worker_runs.py tests/plugins/test_kanban_dashboard_plugin.py tests/gateway/test_kanban_notifier.py -q -o 'addopts='
    • 654 passed, 1 skipped

Review

Independent reviewer verdict: passed. No security concerns or logic errors; non-blocking note to watch for write-latency impact.

@alt-glitch alt-glitch added type/bug Something isn't working P3 Low — cosmetic, nice to have comp/plugins Plugin system and bundled plugins labels May 22, 2026
@steveonjava

Copy link
Copy Markdown
Contributor

+1 on this change. I hit the same issue and had to make this fix to prevent corruption.

@kshitijk4poor

Copy link
Copy Markdown
Collaborator

Closing as already fixed on main — landed via #33482 commit 6416dd518 (@steveonjava's batch-salvage). The synchronous=NORMAL → FULL change you proposed is exactly what landed, and the merged commit also adds secure_delete=ON + cell_size_check=ON + wal_autocheckpoint=100 for additional hardening. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

comp/plugins Plugin system and bundled plugins P3 Low — cosmetic, nice to have type/bug Something isn't working

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants