Re: [sqlite] WAL mode readonly errors to SELECT statements

2019-01-24 Thread Robert Searle
Jan 2018) On Thu, 24 Jan 2019 at 15:37, Robert Searle wrote: > Hi, > > I have an sqlite3 database (version 3.25.3) in tmpfs which has many > readers and writers. > > The database is running in WAL mode and seems to work efficiently in that > mode. > Since the databas

[sqlite] WAL mode readonly errors to SELECT statements

2019-01-23 Thread Robert Searle
e database that might reduce the probability of occurrence? 4) If there aren't any configuration settings, are there any usage patterns to avoid or to embrace? -- Robert Searle Lead Design Engineer Tait Communications DDI: +64 3 3570717 Email: robert.sea...@taitradio.com www.tai

[sqlite] Intermittent "locking protocol" errors for access to tmpfs database.

2011-08-12 Thread Robert Searle
Hi, SQLite version 3.7.7.1 2011-06-28 17:39:05 Problem - I have a sqlite database for monitored data on an embedded linux ARM processor. There are many writing processes and two reading processes (one to handle SNMP queries, one to handle Web UI monitoring queries) The database is stored in a tmp