On 24 Jan 2019, at 2:37am, Robert Searle <robert.sea...@taitradio.com> wrote:

> occasionally get either
> SQLITE_READONLY_RECOVERY or SQLITE_READONLY_CANTINIT responses to select
> statements

No programmer should be seeing these.  They indicate low-level errors that 
cannot be handled in a systematic manner.  Rather than dealing with them, 
figure out why they're happening in the first place.  You do not want to deal 
with a database which is constantly being corrupted, since recovery of it may 
lead to lost data/changes.

As temporary diagnostic measures, try one or both of

(A) Moving the database out of tmpfs to a normal drive
(B) Opening the database as read/write

See whether either/both of those make the fault go away.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to