[Motion-user] Question about sqlite3 and locking / read-only mode

[Chris C. <Chr...@Go...>]

Hi Everyone,

I am using motion with 5 cameras and an sqlite database.

I am trying to use PHP to create an interface for it, which is partially 
working, but quite often the DB goes into "read-only" mode, even though 
I can manipulate the database from the sqlite3 command in a bash shell.

I did notice that I get the following messages on start up:

dbse_init_sqlite3: Setting busy timeout to 0 msec


Could this be the problem? How can I change the timeout to a couple of seconds or something?
My setup is too simple to warrant a whole mysql (or similar) setup, and I want as fewer dependencies as possible.
If I stop motion (and/or apache) and start it again, that usually fixes the problem, but it's difficult to tell when this happens, unless I write some sort of log parser, which seems a bit of a kludge.

Thanks,

Chris