Strange PHP/SQLite problem

RattleSn@ke · 06-19-2009, 05:10 AM

Hi All,

I have a strange PHP/SQLite problem.
When I try to execute a query to a SQLite DB on ServerA, I get this error:

Code:

Query failed.
Last Error: database is locked

Then I copy the DB to another server (ServerB) with exact the same installation of PHP/SQLite, the query succeeds.

Versions:
PHP: 5.2.8
SQLite: PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.11 2008/12/01 12:28:27 felipe Exp $
SQLite Library 2.8.17
SQLite Encoding UTF-8
OS: FreeBSD6.3

It seems really be caused by the server, I just installed sqlite (cli) and then when I run:

Code:

# sqlite db1.sqlite
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .databases
Error: database is locked
sqlite> quit

Is there some lockfile somewhere that I don't know about?

The file is located on NFS, and when I try to open it on ServerB, there is no lock.

So for some reason ServerA is buggy, but I really can't pinpoint the problem. I've already been working on this for over a week and already tried to reinstall SQLite several times with no luck.

I someone can point me at least in the direction of troubleshooting that would be great!

Thanks!
Onno.

tekhead2 · 06-25-2009, 04:51 PM

I'm no expert, but I beleive that SQLite writes a journal file in the same directory as the database so make sure you have write permissions on the directory for the NFS.