SQLite Forum

SQLITE_IOERR on `pragma optimize`
I'm sometimes getting `SQLITE_IOERR` from sqlite 3.28.0 when I run `pragma optimize` (with no mask) prior to closing a connection, and I'm at a loss for what to do about it.

`pragma optimize(0xffff)` gives me
ANALYZE "main"."causal_parent"
ANALYZE "main"."causal"
which seems reasonable, but then `pragma optimize`, immediately following that, crashes.

It's a new database, created by a unit test.  I don't get a crash if I don't run `pragma optimize`.

Any suggestions?


P.S. Fwiw, I do use `PRAGMA journal_mode = WAL;` after db open.