I'm attempting to set a SQLite database's journal_mode to wal (write-ahead logging) via an IronPython script.
The IronPython's install version is
IronPython 2.7 2.7.0.40 on .NET 4.0.30319.18444
and the SQLite version it uses is 3.7.7, obtained by running print sqlite3.sqlite_version
.
WAL support was added to SQLite in version 3.7.0, so why does this script fail to run?
If I execute pragma journal_mode=wal;
I just get a response of delete
.
If I try to open a database already set to WAL, I get an error of _sqlite3.DatabaseError: file is encrypted or is not a database (wal format detected)
.
Aucun commentaire:
Enregistrer un commentaire