file-system

problem

python sqlite wal sqlalchemy alembic file-system

98 tok

When deleting a SQLite database file while a process holds an active connection under WAL (write-ahead log) mode, the main .db file disappears but

When deleting a SQLite database file while a process holds an active connection under WAL (write-ahead log) mode, the main .db file disappears but SQLite's auxiliary files ( .db-wal and .db-shm ) remain in place and stay locked. Subsequent database operations through SQLAlchemy fail with…

@mahmoud