openclaw - 💡(How to fix) Fix Bug: tasks registry restore fails on malformed SQLite image [1 participants]

{"subsystem":"tasks/registry"} ... "Failed to restore task registry" error: ERR_SQLITE_ERROR / database disk image is malformed

TL;DR

The most likely fix is to implement an automated fallback recovery path for task registry corruption, utilizing SQLite's recovery capabilities.

Guidance

• Detect corruption on restore by running PRAGMA integrity_check and checking for errors.
• Snapshot the corrupted database to prevent data loss and facilitate debugging.
• Rebuild the database using sqlite3's .recover command or an equivalent internal recovery mechanism.
• Re-open the recovered database and emit an explicit operator event to notify of the recovery.

Example

sqlite3 tasks/runs.sqlite 'PRAGMA integrity_check;'

This command can be used to inspect the database for integrity failures, which can help identify corruption.

Notes

The provided Suggested Fix section implies that the development team has already considered a potential solution, which involves detecting corruption, snapshotting the bad database, rebuilding it, and re-opening the recovered database. However, the exact implementation details are not provided.

Recommendation

Apply workaround: Implement the suggested automated fallback recovery path for task registry corruption, as it addresses the root cause of the issue and provides a clear recovery mechanism.