[sqlite] Wierd Locking problem

We use straight SQLITE3 PHP Extension sot we don\ not have that much customization level. On Mon, Aug 24, 2015 at 5:44 PM, Eduardo Morras wrote: > On Mon, 24 Aug 2015 16:03:24 +0200 > Luc Andre wrote: > > > Hi All, > > > > Our web servers use a daily updated sqlite database file. > > > > The fi

[sqlite] Wierd Locking problem

On Mon, 24 Aug 2015 16:03:24 +0200 Luc Andre wrote: > Hi All, > > Our web servers use a daily updated sqlite database file. > > The file is opened by multiple (apache/PHP) threads but always in > read only mode: > > $db = new SQLite3(DB_FILE, SQLITE3_OPEN_READONLY); > > The file itself has no

[sqlite] Wierd Locking problem

On 24 Aug 2015, at 3:45pm, Luc Andre wrote: > I'm sure no process open the file using the SQLite API in write mode. You are, but the software has to check for it, and occasionally two of your threads do the same check at the same time. I'm afraid that if you have already set a timeout I don't

[sqlite] Wierd Locking problem

On Mon, Aug 24, 2015 at 4:38 PM, Simon Slavin wrote: > > On 24 Aug 2015, at 3:03pm, Luc Andre wrote: > > > PHP Notice: SQLite3Stmt::execute(): Unable to execute statement: database > > is locked > > SQLite3::prepare(): Unable to prepare statement: 5, database is locked > > SQLite3::querySingle()

[sqlite] Wierd Locking problem

Hi All, Our web servers use a daily updated sqlite database file. The file is opened by multiple (apache/PHP) threads but always in read only mode: $db = new SQLite3(DB_FILE, SQLITE3_OPEN_READONLY); The file itself has no write access. -rw-r--r-- 1 root root 225759232 Aug 24 13:43 db.sqlite B

[sqlite] Wierd Locking problem

On 24 Aug 2015, at 3:03pm, Luc Andre wrote: > PHP Notice: SQLite3Stmt::execute(): Unable to execute statement: database > is locked > SQLite3::prepare(): Unable to prepare statement: 5, database is locked > SQLite3::querySingle(): Unable to execute statement: database is locked > > We can not u