[Bug] Database gets corrupted from time to time since multi agents

[ipodishima]

I don't know about you guys, but I'm having database corruption lately on my project.

  sqlite3 .autocoder/features.db "PRAGMA integrity_check;" 2>/dev/null
*** in database main ***
Tree 2 page 17: btreeInitPage() returns error code 11
Tree 2 page 11: btreeInitPage() returns error code 11
Tree 18 page 18: btreeInitPage() returns error code 11
ok

sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed

Usually what works is a simple

sqlite3 features.db ".recover" | sqlite3 recovered.db

Then check recovered.db and replace features.db with it.

Wondering if there aren't missing lock on db when agents write to it