Tag: SQLite

The Lament of WAL: A Database Digs Itself Out

newapi suddenly became unreachable, reporting sqlite error 4618. The root cause was neither corruption nor a full disk, but the old quarrel between SQLite WAL mode and Windows bind mounts: ftruncate returns EINVAL. strace caught the exact line; the fix was migrating the data directory into a Docker named volume — 51,938 log entries and user data intact to the byte.